Oracle 9i : SQL Course

Introduction to Oracle 9i : SQL
Course Content

Introduction
Writing Basic SQL SELECT Statements
Restricting and Sorting Data
Single- Row Functions
Displaying Data from Multiple Tables
Aggregating Data Using Group Functions
Subqueries
Producing Readable Output with iSQL *Plus
Manipulating Data
Creating and Managing Tables
Including Constraints
Creating Views
Other Database Objects
Controlling User Access
SQL Workshop
Using SET Operators
Oracle 9i Datetime Functions
Enhancements to the GROUP BY Clause
Advanced Subqueries
Hierarchical Retrival
Oracle 9i Extensions to DML and DDL Statements


Oracle 9i : Database Administration Fundamentals - I
Course Content

Oracle Architectural Components
Getting Started with Oracle Server
Managing an Oracle Instance
Creating a Database
Using Data Dictionary and Dynamic Performance Views
Maintaining the Control File
Maintaining Online Redo Log File
Managing Tablespaces and Data Files
Storage Structure and Relationships
Managing Undo Data
Managing Tables
Managing Indexes
Maintaining Data Integrity
Managing Password Security and Resources
Managing Users
Managing Privileges
Managing Roles
Auditing
Loading Data into a Database
Using Globalisation Support

Oracle 9i : Database Administration Fundamentals - II
Course Content

Networking Overview
Oracle Net Architecture
Basic Oracle Net Server Side Configuration
Naming Method Configuration
Usage and Configuration of the Oracle Shared Server
Backup and Recovery Overview
Instance and Media Recovery Structures
Configuring the Database Archiving Mode
Oracle Recovery Manager Overview and Configuration
User - Managed Backups
RMAN Backups
User-Managed Complete Recovery
RMAN Complete Recovery
User - Managed Incomplete Recovery
RMAN Incomplete Recovery
RMAN Maintenance
Recovery Catalog Creation and Maintenance
Export and Import Utilities
Workshop

Oracle 9i Database Performance Tuning
Course Content

Overview of Oracle9i Database Performance Tuning
Diagnostic and Tuning Tools
Database Configuration and I/O Issues
Tuning the Shared Pool
Tuning the Buffer Cache
Dynamic Instance Resizing
Sizing Other SGA Structures
Tuning the Oracle Shared Server
Optimizing Sort Options
Using Resource Manager
SQL Statement Tuning
Managing Statistics
Using Oracle Blocks Efficiently
Using Oracle Data Storage Structures Efficiently
Application Tuning
Using Materialised Views
Monitoring and Detecting Lock Contention
Tuning the Operating System
Workshop Overview