This course is designed to fully certify an individual in Oracle 9i. Students will learn about the new features in PL/SQL, the Oracle features that support SQL99, and all features of the Oracle 9i database. The students will be provided with course materials, sample tests, and be able to take all tests associated with Oracle 9i certification. The tests include:

• 1Z0-007 -- Oracle 9i PL/SQL
• 1Z0-031 -- Oracle 9i Fundamentals I
• 1Z0-032 -- Oracle 9i Fundamentals II
• 1Z0-033 -- Oracle 9i Tuning

I: Oracle 9i PL/SQL (1Z0-007)

• Writing basic SQL SELECT statements
• Restricting and sorting data
• Displaying data from multiple tables
• Outer Joins
• Single Row Functions
• Aggregating data using group functions
• Producing readable output with iSQL*Plus
• Subqueries
• Creating and managing tables
• Altering Table
• Creating Database Objects
• Manipulating Data
• Creating Views
• Controlling user access

II: Oracle 9i Database Fundamentals I (1Z0-031)

• Basics of the Oracle Database Architecture
• Oracle Server Architecture
• Shared Memory Areas
• Universal Installer
• Managing an Oracle Instance
• Oracle Managed Files
• Server Side Parameter File
• Oracle Data Dictionary
• Control Files
• Redo Log Files
• Managing the Physical Database Structure
• Managing Tablespaces and Datafiles
• Temporary Segments
• Storage Structures and Undo Data
• Block Utilization
• Undo Space Management
• Managing Database Objects
• Indexes
• Integrity Constraints
• Managing Database Users
• System Privileges
• Object Privileges
• Roles
• National Language Support

III: Oracle 9i Database Fundamentals II (1Z0-032)

• Networking Features
• Simple Network
• Network Configurations
• Server Side Configuration
• Client Side Configuration
• Oracle Net
• Oracle Names
• Oracle Net Features
• Listener Configuration
• External Names
• Connection Manager
• Shared Server
• Network Security
• Trouble Shooting the Network.
• Backup and Recovery Features
• Types of Failures
• Instance and Media Failures
• Database Files
• Redo Log Files
• Archivelog Mode
• Recovery Methods
• Hot Backups
• Cold Backups
• Incomplete Recovery
• Complete Recovery
• Oracle Data Guard
• RMAN Features
• Recovery Catalog
• Logical Backups
• SQL*LOADER
• Flashback Query
• LogMiner Enhancements
• Skipping Redo Log Corruption
• Fast Start Time Recovery
• Block Media Recovery

IV: Oracle 9i Database Tuning: (1Z0-033)

• Tuning Methodology
• Tuning Tools
• Cached Executable Plans
• Dynamic Performance Views.
• Statspack
• Analyze Command
• Optimizer Improvements
• SGA Structures
• Sort Operations
• I/O Structures
• Common SQL Parser
• Undo Segments
• Latch Contention
• Application Tuning
• SQL Statement Tuning
• Oracle Blocks
• Resource Manager
• Bitmap Join Indexes
• Index Skip Scanning
• Cache Fusion Architecture
• HA Features