Examine the use of SQL, PL/SQL, and SQL*Plus, filter and sort data, use built-in SQL functions, create and modify tables and constraints, create and use database objects, use PL/SQL control structures, process cursors in PL/SQL, develop procedures and functions with runtime exceptions, develop Oracle packages, create Oracle triggers, and work with collections of data.

Examine the basic Oracle concepts and how they relate to database administrators and developers, identify and apply the techniques of logical database design to design a basic entity-relationship diagram, examine the purpose of denormalization, identify the advantages and disadvantages of iSQL*Plus, write SQL statements to retrieve and manipulate data, create and execute a simple PL/SQL program, list the purpose and syntax of packages, procedures, triggers, and functions, list the objects in an Oracle database, and examine the overall architecture of the Oracle Relational Database Management System (RDBMS).

Describe the basic Oracle9i architecture and how objects are stored in the database. This course will also enable you to manage several aspects such as an Oracle instance, datafiles, tables, and users. You can maintain the online redo log and the control files. You will also be able to describe globalization support.

Describe and configure the Oracle Network Environment. This course will describe the basic concepts of database backup and recovery in Oracle9i. This course will help you perform user managed backup and recovery of a database. It will also help you use the RMAN utility to perform backups as well as complete and incomplete recoveries of the database. You will be able to move data around quickly and easily using the utilities provided by Oracle.

Get the concepts to properly tune the Oracle9i Database for optimal performance. You will examine the tools used to monitor, analyze, measure, and tune a database. This course also helps you to prepare for the Oracle9i Database: Performance Tuning (1Z0-033) exam.