Oracle 11g & 12c Bundle

Oracle 11g Course Outline

• Module 1: Database Administration
• Module 2: Oracle Architecture
• Module 3: Database Schema
• Module 4: Recovery Manager
• Module 5: Introduction to SQL
• Module 6: Filtering and Sorting Data
• Module 7: Function
• Module 8: SET Operators and Subqueries
• Module 9: Regular Expressions and SQL*Loader

Oracle 12c Course Outline

• Oracle 12c OCP 1Z0-061: SQL Fundamentals

Course Syllabus

Module 1 Introduction To Oracle 12c SQL Fundamentals

• 1.1 Introduction To Course
• 1.2 Intro To Oracle 12c SQL Fundamentals
• 1.3 Structure Of SQL
• 1.4 Basic Select Statements
• 1.5 Basic Select Statements Demo

Module 2 Retrieving Data

• 2.1 Modifying Reported Output
• 2.2 The Where Clause
• 2.3 The Order By Clause
• 2.4 Left And Right Outer Joins
• 2.5 The Where Clause Demo
• 2.6 Multi­Table Selection Demo

Module 3 SQL Functions

• 3.1 Single Row Functions
• 3.2 Aggregate Functions
• 3.3 Single­Row Functions Demo
• 3.4 Multi­Row Functions Demo
• 3.5 Group By
• 3.6 Grouping Demo
• 3.7 Conversion Functions
• 3.8 Conversion Functions Demo
• 3.9 Date­time Functions
• 3.10 Date­time Functions Demo

Module 4 Subqueries

• 4.1 Single­Row Subqueries
• 4.2 Single­Row Subqueries Demo
• 4.3 Multi­Row Subqueries
• 4.4 Multi­Row Subqueries Demo
• 4.5 Other Subquery Types
• 4.6 Other Subquery Types Demo

Module 5 Data Manipulation Language

• 5.1 Adding Data
• 5.2 Changing Data
• 5.3 Deleting Data
• 5.4 DML Demo

Module 6 Data Control Language

• 6.1 Security
• 6.2 Object Privileges
• 6.3 DCL Demo

Module 7 Data Definition Language

• 7.1 Creating Objects In The Database
• 7.2 Creating Objects In The Database Demo
• 7.3 Sequences
• 7.4 Sequenced Demo
• 7.5 Indexes
• 7.6 Views

Module 8 Combining Queries

• 8.1 Combining Queries

Module 9 Oracle 12C SQL Fundamentals

• 9.1 Oracle 12c SQL Fundamentals Review-
• Part 1
• 9.2 Oracle 12c SQL Fundamentals Review-
• Part 2
• 9.3 Oracle 12c SQL Fundamentals Review-
• Part 3
• 9.4 Conclusion

Oracle 12c OCP 1Z0-062: Installation and Administration Course Syllabus

Module 1 Database Concepts And Tools

• 1.1 Instructor And Course Introduction
• 1.2 Database Concepts And Tools­ Part 1
• 1.3 Database Concepts And Tools­ Part 2

Module 2 Memory Structure

• 2.1 Memory Structure­ Part 1
• 2.2 Memory Structure ­Part 2

Module 3 Tables

• 3.1 Tables ­Part 1
• 3.2 Tables ­Part 2

Module 4 Indexes

• 4.1 Indexes ­Part 1
• 4.2 Indexes­ Part 2

Module 5 Constraints And Triggers

• 5.1 Constraints And Triggers ­Part 1
• 5.2 Constraints And Triggers ­Part 2

Module 6 Users

• 6.1 Users
• 6.2 Profiles
• 6.3 Privileges
• 6.4 Roles

Module 7 Internal Structures

• 7.1 Storage Structures­ Part 1
• 7.2 Storage Structures ­Part 2
• 7.3 Internal Memory Structures ­Part 1
• 7.4 Internal Memory Structures ­Part 2
• 7.5 Background Processes ­Part 1
• 7.6 Background Processes ­Part 2

Module 8 Starting Up and Shutting Down Database

• 8.1 Starting And Stopping Data Base ­Part 1
• 8.2 Starting And Stopping Data Base­ Part 2

Module 9 Critical Storage Files

• 9.1 Critical Storage Files­ Part 1
• 9.2 Critical Storage Files­ Part 2

Module 10 Data Manipulation Language

• 10.1 DML Atomicity­ Part 1
• 10.2 DML Atomicity­ Part 2
• 10.3 DML Insert
• 10.4 DML Update ­Part 1
• 10.5 DML Update ­Part 2
• 10.6 DML Delete And Review Of DML Statements ­Part 1
• 10.7 DML Delete And Review Of DML Statements ­Part 2

Module 11 Data Concurrency

• 11.1 Data Concurrency ­Part 1
• 11.2 Data Concurrency­ Part 2

Module 12 BackUp And Recovery

• 12.1 BackUp­ Part 1
• 12.2 BackUp ­Part 2
• 12.3 BackUp ­Part 3
• 12.4 RMAN Catalog
• 12.5 RMAN BackUps ­Part 1
• 12.6 RMAN BackUps­ Part 2
• 12.7 Disaster Preparedness
• 12.8 Recovery
• 12.9 Flashback Recovery

Module 13 Installation

• 13.1 Installation ­Part 1
• 13.2 Installation­ Part 2

Module 14 Course Review

• 14.1 Course Review­ Part 1
• 14.2 Course Review­ Part 2
• 14.3 Course Review­ Part 3
• 14.4 Course Review­ Part 4
• 14.5 Course REview ­Part 5
• 14.6 Course Outro