Oracle9i OCP课程大纲

　　
　　Introduction to Oracle9i: SQL
　　Introduction
　　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
　　15 Using SET Operators
　　16 Oracle9i Datetime Functions
　　17 Enhancements to the GROUP BY Clause
　　18 Advanced Subqueries
　　19 Hierarchical Retrieval
　　20 Oracle9i Extensions to DML and DDL Statements
　　
　　Oracle9i Database Administration Fundamentals I
　　Introduction
　　1 Oracle Architectural Components
　　2 Getting Started with the Oracle Server
　　3 Managing an Oracle Instance
　　4 Creating a Database
　　5 Using Data Dictionary and Dynamic Performance Views
　　6 Maintaining the Control File
　　7 Maintaining Online 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 Auditing
　　19 Loading Data into a Database
　　20 Using Globalization Support
　　
　　Oracle9i Database administration Fundamentals II
　　1 Networking Overview
　　2 Oracle Net Architecture
　　3 Basic Oracle Net Server Side Configuration
　　4 Naming Method 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 Export and Import Utilities
　　19 Workshop
　　
　　Oracle9i Database Performance Tuning
　　1 Overview of Oracle9i Database Performance Tuning
　　2 Diagnostic and Tuning Tools
　　3 Database Configuration and I/O Issues
　　4 Sizing the Shared Pool
　　5 Sizing the Buffer Cache
　　6 Dynamic Instance Resizing
　　7 Sizing Other SGA Structures
　　8 Tuning the Oracle Shared Server
　　9 Optimizing Sort Operations
　　10 Tuning Undo Segments
　　11 SQL Statement Tuning
　　12 Managing Statistics
　　13 Using Oracle Blocks Efficiently
　　14 Using Oracle Data Storage Structures Efficiently
　　15 Application Tuning
　　16 Using Materialized Views
　　17 Monitoring and Detecting Lock Contention
　　18 Using Resource Manager
　　19 Tuning the Operating System
　　20 Workshop Overview