Databases-Oracle 9i,MySql

Certificate in Oracle 9i

Course Code : COR

Course Duration: 3 months (Regular) 1.5 months (Fast Track)

The course provides a comprehensive introduction to use Oracle’s SQL for database access, covering data manipulation and transaction management concepts.

This course is aimed for those interested in working SQL in Oracle or other relational database products, including application developers, programmers, database administrators and managers. No previous data base experience is required.

Course Contents

  • Introduction to Database Concepts
  • Starting SQL* Plus
  • Querying databases
  • Joining tables and sub-queries
  • DDL commands
  • Other database objects
  • SQL* reports
  • Creating partitioned tables
  • Large objects
  • PL/SQL
  • Cursors and Exception handling
  • Subprogram in PL/SQL
  • Abstract data type
  • Nested tables and arrays
  • Tuning SQL
  • Introduction to Oracle DBA
  • Oracle 9i