Introduction
Writing a Basic SQL Statement
Restricting and Sorting Data
Single Row Functions
Displaying Data from Multiple Tables
Aggregating Data by Using Group Functions
Writing Subqueries
Producing Readable Output with iSQL*Plus
Manipulating Data
Creating and Managing Tables
Including Constraints
Creating Views
Controlling User Access
SQL Workshop
Using Set Operators
Oracle Datetime Functions
Enhancements to the GROUP BY Clause
Advanced Subqueries
Hierarchical Retrieval
Oracle
Extensions to DML and DDL Statements
Oracle
Database Administration Fundamentals I
Oracle Architectural Components
Getting Started with the Oracle Server
Creating a database during installation
Creating a new database
Identifying database administrative users
Managing an Oracle Instance
Creating a Database
Using the Data Dictionary
Maintaining the Control File
Maintaining Redo Log Files
Managing Tablespaces and Datafiles
Establishing the difference between SYSTEM and Non-SYSTEM tablespaces
Storage Structures and Relationships
Creating and maintaining UNDO tablespaces
Managing Tables
Managing Indexes
Identifying unused indexes
Oracle
Database Administration Fundamentals II
Networking Overview
Basic Oracle Net Architecture
Basic Oracle Net Services Server-Side Configuration
Basic Oracle Net Services Client-Side Configuration
Usage and Configuration of the Oracle Shared Server
Backup and Recovery Overview
Instance and Media Recovery Structures
Configuration of the Database Archiving Mode
Oracle Recovery Manager (RMAN) Overview and Configuration
User-Managed Backups
RMAN Backups
User-Managed Complete Recovery
RMAN Complete Recovery
User-Managed Incomplete Recovery
RMAN Incomplete Recovery
RMAN Repository Maintenance
RMAN Catalog Creation and Usage
Transporting Data Between Databases
Backup
and Recovery and Networking Workshop
Oracle
Database Performance Tuning
Overview of Oracle Performance Tuning
Diagnostic and Tuning Tools
Sizing the Shared Pool
Sizing the Buffer Cache
Sizing other SGA Structures
Database Configuration and I/O Issues
Optimize Sort Operations
Diagnosing Contention For Latches
Tuning Rollback (or UNDO) Segments
Monitoring and Detecting Lock Contention
Tuning Oracle Shared Server
Application Tuning
Using Oracle Blocks Efficiently
SQL Statement Tuning
Tuning the Operating System and Using Resource Manager