Introduction to 9i: 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 9i 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
【责编:admin】
--------------------next---------------------
