SAINORA

HomeCourses Oracle Sql/Plsql

Oracle Sql/Plsql

Linux/Solaris

  • Directory and file commands
  • System files and files directories
  • Files and directory security
  • VI Editor
  • Shell Scripts
  • Scheduling jobs
  • AWK programming
  • Administrator Commands
  • Monitoring memory and processor
  • Disk Maintenance
  • LVM

SQL

  • Introduction to RDBMS
  • Data types
  • Sql Languages
  • Constraints
  • Single row and multirow functions
  • Conversion functions
  • Conditional expressions
  • Operators
  • SET operators
  • Joins
  • Sub Queries
  • Co-related Sub Queries
  • Views
  • Sequence
  • Synonyms
  • Indexes
  • User Access
  • Rollup and Cube
  • Time Zone
  • External Tables
  • Multiple Table Inserts
  • Workshop With Scenarios
  • Assessment

PL/SQL

  • Introduction to PLSQL Environment
  • Variables and Data Types
  • Languages
  • Control Structures
  • Cursors
  • Exceptions Procedures
  • Functions
  • Triggers
  • Packages
  • Oracle inbuilt Packages
  • Dynamic SQL
  • REF Cursors
  • PLSQL Tables
  • Workshop with Scenarios
  • Assessments

SQL Tuning

  • Oracle optimizer modes
  • Interpreting execution plan
  • Trace Events
  • Using proper indexes
  • Workshop with Scenarios
  • Assessments