Introduction to Oraclei: SQL
Introduction
Writing Basic SQL SELECT Statements
Restricting and Sorting Data
SingleRow 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
Oraclei Datetime Functions
Enhancements to the GROUP BY Clause
Advanced Subqueries
Hierarchical Retrieval
Oraclei Extensions to DML and DDL Statements
Oraclei Database Administration Fundamentals I
Introduction
Oracle Architectural Components
Getting Started with the Oracle Server
Managing an Oracle Instance
Creating a Database
Using Data Dictionary and Dynamic Performance Views
Maintaining the Control File
Maintaining Online Redo Log Files
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 Globalization Support
Oraclei Database administration Fundamentals II
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
UserManaged Backups
RMAN Backups
UserManaged Complete Recovery
RMAN Complete Recovery
UserManaged Incomplete Recovery
RMAN Incomplete Recovery
RMAN Maintenance
Recovery Catalog Creation and Maintenance
Export and Import Utilities
Workshop
Oraclei Database Performance Tuning
Overview of Oraclei Database Performance Tuning
Diagnostic and Tuning Tools
Database Configuration and I/O Issues
Sizing the Shared Pool
Sizing the Buffer Cache
Dynamic Instance Resizing
Sizing Other SGA Structures
Tuning the Oracle Shared Server
Optimizing Sort Operations
Tuning Undo Segments
SQL Statement Tuning
Managing Statistics
Using Oracle Blocks Efficiently
Using Oracle Data Storage Structures Efficiently
Application Tuning
Using Materialized Views
Monitoring and Detecting Lock Contention
Using Resource Manager
Tuning the Operating System
Workshop Overview
