Oracle Database 10g – SQL Fundamentals
– Introduction
– Retrieving Data Using the SQL SELECT Statement
– Restricting and Sorting Data
– Using Single-Row Functions to Customize Output
– Using Conversion Functions and Conditional Expressions
– Reporting Aggregated Data Using the Group Functions
– Displaying Data From Multiple Tables
– Using Sub-queries to Solve Queries
– Using the SET Operators
– Manipulating Data
– Using DDL Statements to Create and Manage Tables
– Creating Other Schema Objects

Oracle Database 11g: Administration Workshop I

– Exploring the Oracle Database Architecture
– Preparing the Database Environment
– Creating an Oracle Database
– Managing the Oracle Instance
– Configuring the Oracle Network Environment
– Managing Database Storage Structures
– Administering User Security
– Managing Schema Objects
– Managing Data and Concurrency
– Managing Undo Data
– Implementing Oracle Database Security
– Database Maintenance
– Performance Management
– Backup and Recovery Concepts
– Performing Database Backups
– Performing Database Recovery
– Moving Data
– Enhancing Database Capabilities

Oracle Database 11g: Develop PL/SQL Program Units

– Introduction
– Creating Stored Procedures
– Creating Stored Functions
– Creating Packages
– Working With Packages
– Using Oracle-Supplied Packages in Application Development
– Using Dynamic SQL
– Design Considerations for PL/SQL Code
– Creating Triggers
– Creating Compound, DDL, and Event Database Triggers
– Using the PL/SQL Compiler
– Managing PL/SQL Code
– Managing Dependencie

Data Warehousing Fundamentals

This course will help you understand the basic concepts of administering a data warehouse. You’ll learn to use various Oracle Database features to improve performance and manageability in a data warehouse.
– Implement partitioning.
– Use parallel operations to reduce response time.
– Extract, transform and load data.
– Create, use and refresh materialized views to improve data warehouse performance.
– Use query rewrite to quickly answer business queries using materialized views.