Oracle Database 11g Certified Associate (OCA) (Fundamentals 1Z0-051 and Admin 1z0-052)

Module 1: Database Admininstration

• 1.0 Intro to Oracle
• 1.1 Database Administration
• 1.2 Installing Oracle Part 1
• 1.3 Installing Oracle Part 2
• 1.4 Post Setup Overview Part 1
• 1.5 Post Setup Overview Part 2
• 1.6 SQLplus Part 1
• 1.7 SQLplus Part 2
• 1.8 SQLplus Demo part 1
• 1.9 SQLplus Demo part 2
• 1.10 SQLplus Demo part 3
• 1.11 Startup and Shutdown part 1
• 1.12 Startup and Shutdown part 2

Module 2: Oracle Architecture

• 2.0 Oracle Architecture
• 2.1 Schema Objects
• 2.2 Data Access
• 2.3 Architecture

Module 3: Database Schema

• 3.0 Database Schema
• 3.1 Create Table & Tablespace part 1
• 3.2 Create Table & Tablespace part 2
• 3.3 Create View
• 3.4 Create Index
• 3.5 Create Sequence

Module 4: Recovery Manager

• 4.0 Recovery Manager
• 4.1 What is RMAN
• 4.2 RMAN Demo
• 4.3 Restore Part 1
• 4.4 Restore Part 2

Module 5: Introduction to SQL

• 5.0 SQL part 1
• 5.1 SQL part 2
• 5.2 Parts of SQL Statement
• 5.3 Select Statement

Module 6: Filtering and Sorting Data

• 6.0 Build ERD part 1
• 6.1 Build ERD part 2
• 6.2 Build ERD part 3

Module 7: Functions

• 7.0 Functions
• 7.1 More Functions
• 7.2 Group Functions
• 7.3 Custom Functions

Module 8: SET Operators and Subqueries

• 8.0 SET Operations
• 8.1 Subqueries

Module 9: Regular Expressions and SQL Loader

• 9.0 Regular Expressions
• 9.1 SQL Loade