Oracle 9i Training Outline

Introduction to Oracle9i: SQL

1 Writing Basic SQL SELECT Statements
2 Restricting and Sorting Data
3 Single-Row Functions
4 Displaying Data from Multiple Tables
5 Aggregating Data Using Group Functions
6 Subqueries
7 Producing Readable Output with iSQL*Plus
8 Manipulating Data
9 Creating and Managing Tables
10 Including Constraints
11 Creating Views
12 Other Database Objects
13 Controlling User Access
14 SQL Workshop Workshop Overview
15 Using SET Operators
16 Oracle 9i Datetime Functions
17 Enhancements to the GROUP BY Clause
18 Advanced Subqueries
19 Hierarchical Retrieval
20 Oracle 9i Extensions to DML and DDL Statements

Oracle9i Database Administration Fundamentals I

1 Oracle Architectural Components
2 Getting Started With the Oracle Server
3 Managing an Oracle Instance
4 Creating a Database
5 Data Dictionary Contents and Usage
6 Maintaining the Control File
7 Maintaining Redo Log Files
8 Managing Tablespaces and Data files
9 Storage Structure and Relationships
10 Managing Undo Data
11 Managing Tables
12 Managing Indexes
13 Maintaining Data Integrity
14 Managing Password Security and Resources
15 Managing Users
16 Managing Privileges
17 Managing Roles
18 Using Globalization Support

Oracle9i Database Administration Fundamentals II

1 Networking Overview
2 Basic Oracle Net Architecture
3 Basic Oracle Net Server-Side Configuration
4 Basic Oracle Net Services Client-Side Configuration
5 Usage and Configuration of the Oracle Shared Server
6 Backup and Recovery Overview
7 Instance and Media Recovery Structures
8 Configuring the Database Archiving Mode
9 Oracle Recovery Manager Overview and Configuration
10 User-Managed Backups
11 RMAN Backups
12 User-Managed Complete Recovery
13 RMAN Complete Recovery
14 User-Managed Incomplete Recovery
15 RMAN Incomplete Recovery
16 RMAN Maintenance
17 Recovery Catalog Creation and Maintenance
18 Transporting Data Between Databases
19 Loading Data Into a Database
20 Workshop

Oracle9i Database Performance Tuning
1 Overview of Oracle9i Performance Tuning
2 Diagnostic and Tuning Tools
3 Sizing the Shared Pool
4 Sizing the Buffer Cache
5 Sizing Other SGA Structures
6 Database Configuration and I/O Issues
7 Optimizing Sort Operations
8 Diagnosing Contention for Latches
9 Tuning Rollback Segments
10 Monitoring and Detecting Lock Contention
11 Tuning the Oracle Shared Server
12 Application Tuning
13 Using Oracle Blocks Efficiently
14 SQL Statement Tuning
15 Tuning the Operating System and Using Resource Manager