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

Memory Structure – Part 1

Memory Structure – Part 2

Tables – Part 1

Tables – Part 2

Indexes – Part 1

Indexes – Part 2

Constraints And Triggers – Part 1

Constraints And Triggers – Part 2

Users

Profiles

Privileges

Roles

Storage Structures – Part 1

Storage Structures – Part 2

Internal Memory Structures – Part 1

Internal Memory Structures – Part 2

Background Processes – Part 1

Background Processes – Part 2

Starting And Stopping DataBase – Part 1

Starting And Stopping DataBase – Part 2

Critical Storage Files – Part 1

Critical Storage Files – Part 2

DML Atomicity – Part 1

DML Atomicity – Part 2

DML Insert

DML Update – Part 1

DML Update – Part 2

DML Delete And Review Of DML Statements – Part 1

DML Delete And Review Of DML Statements – Part 2

Data Concurrency – Part 1

Data Concurrency – Part 2

Back Up – Part 1

Back Up – Part 2

Back Up – Part 3

RMAN Catalog

RMAN BackUps – Part 1

RMAN BackUps – Part 2

Disaster Preparedness

Recovery

Flashback Recovery

Installation – Part 1

Installation – Part 2

Course Review – Part 1

Course Review – Part 2

Course Review – Part 3

Course Review – Part 4

Course Review – Part 5

Course Outro

Modifying Reported Output

The Where Clause

The Order By Clause

Left And Right Outer Joins

The Where Clause Demo

Multi-Table Selection Demo

Single Row Functions

Aggregate Functions

Single Row Functions Demo

Muiltrow Functions Demo

Group By

Grouping Demo

Conversion Functions

Conversion Functions Demo

Datetime Functions

Datetime Functions Demo

Single-Row Subqueries

Single-Row Subqueries Demo

Multi-Row Subqueries

Multi-Row Subqueries Demo

Other Subquery Types

Other Subquery Types Demo

Adding Data

Changing Data

Deleting Data

DML Data

Security

Object Privileges

DCL Demo

Creating Objects In The Database

Creating Objects In The Database Demo

Sequences

Sequenced Demo

Indexes

Views

Combining Queries

Oracle 12c SQL Fundamentals Review – Part 1

Oracle 12c SQL Fundamentals Review – Part 2

Oracle 12c SQL Fundamentals Review – Part 3

Conclusion

Oracle Architecture

Schema Objects

Data Access

Architecture

Database Schema

Create Table & Tablespace – Part 1

Create Table & Tablespace – Part 2

Create View

Create Index

Create Sequence

Recovery Manager

What is RMAN

RMAN Demo

Restore – Part 1

Restore – Part 2

SQL – Part 1

SQL – Part 2

Parts of SQL Statement

Select Statement

Build ERD – Part 1

Build ERD – Part 2

Build ERD – Part 3

Functions

More Functions

Group Functions

Custom Functions

SET Operations

Subqueries

Regular Expressions

SQL Loader