Introduction to Oracle 9i: SQL

The program covers the concepts of both relational and object relational databases and the powerful SQL programming language. This program counts towards the Oracle 9i Database Administrator Certification.

Oracle 9i Database Administration Basic

This program is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database tasks. In this program, you'll learn how to design, create, and maintain an Oracle database.

Students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another and how to create an operational database and properly manage the various structures in an effective and efficient manner.

Oracle 9i Database Administration Advance

This program gives the Oracle database administrator (DBA) a firm foundation in Oracle Net administration and backup and recovery operations.

Students learn about transporting data between databases and the utilities used to perform these activities. Students are also introduced to networking concepts and configuration parameters, as well as how to solve some common network problems. This program also addresses backup and recovery techniques, and examines various backup, failure, restore and recovery scenarios.

Oracle 9i Database Performance Tuning

This program will introduce participants to the importance of good initial database design, and the method used to tune a production Oracle9i database. The focus is on Database and Instance tuning rather than specific operating system performance issues. Using the available Oracle tools, such as Oracle Enterprise Manager (with the Diagnostics and Tuning Packs) and STATSPACK participants also learn how to recognize, troubleshoot and resolve common performance related problems in administering an Oracle database