Section 1 : Introduction

Lecture 1 What is a Database 00:03:28 Duration
Lecture 2 Role of a DBA!!! 00:05:17 Duration
Lecture 3 OLTP vs OLAP Databases 00:04:14 Duration
Lecture 4 What is Oracle 11g 00:04:58 Duration
Lecture 5 What is Oracle 12c 00:05:28 Duration
Lecture 6 Database abc's 00:04:42 Duration
Lecture 7 Undo vs Redo Data 00:05:41 Duration
Lecture 8 Oracle Instance vs Database 00:03:43 Duration

Section 2 : Oracle Process Architecture

Lecture 1 Process Architecture 00:02:25 Duration
Lecture 2 Database Writer Process 00:04:06 Duration
Lecture 3 Log writer Process 00:01:15 Duration
Lecture 4 Checkpoint Process
Lecture 5 SMON Process 00:01:18 Duration
Lecture 6 PMON Process 00:02:25 Duration
Lecture 7 RECO Process 00:01:58 Duration
Lecture 8 Archiver Process 00:01:33 Duration

Section 3 : Oracle Memory Architecture

Lecture 1 Memory Architecture 00:02:34 Duration
Lecture 2 Database Buffer Cache 00:03:17 Duration
Lecture 3 Shared Pool 00:07:21 Duration
Lecture 4 REDO log buffer 00:01:03 Duration
Lecture 5 Large Pool
Lecture 6 Java Pool and Streams Pool 00:00:58 Duration
Lecture 7 Keep Buffer Pool 00:03:00 Duration
Lecture 8 Recycle Buffer Pool 00:01:49 Duration
Lecture 9 About Certification
Lecture 10 Program Global Area (PGA) 00:02:36 Duration
Lecture 11 Dedicated vs Shared Databases 00:04:44 Duration
Lecture 12 PGA in a Shared Envrionment 00:00:40 Duration

Section 4 : Architecture Recap

Lecture 1 Architecture Full Picture!!!! 00:04:27 Duration

Section 5 : Software Installation

Lecture 1 Software Download.
Lecture 2 Virtual Machine Installation 00:02:21 Duration
Lecture 3 Linux Installation 00:16:51 Duration
Lecture 4 Oracle Software Installation 00:15:00 Duration
Lecture 5 Oracle Parameter Files 00:05:55 Duration
Lecture 6 Oracle 12c Upgrade 00:19:14 Duration

Section 6 : Tablespace Management

Lecture 1 How data is stored in a Database 00:06:21 Duration
Lecture 2 Table space Concepts 00:04:19 Duration
Lecture 3 Online and Offline Table spaces 00:01:12 Duration
Lecture 4 Let's create a Tablespace. 00:02:00 Duration
Lecture 5 Let's add more space to the Database.. 00:02:10 Duration
Lecture 6 Table space Demo 1 00:19:35 Duration
Lecture 7 Table space Demo 2 00:06:10 Duration
Lecture 8 Tablespaces with different block sizes 00:04:39 Duration
Lecture 9 Temporary Tablespace Management 00:06:19 Duration
Lecture 10 Temporary Tablespace Groups 00:06:18 Duration
Lecture 11 Extent Management (Local vs Dictionary managed) 00:08:38 Duration

Section 7 : UNDO Management

Lecture 1 UNDO Concepts 00:05:32 Duration
Lecture 2 Read Consistency
Lecture 3 ORA-01555 snapshot too old error 00:02:35 Duration
Lecture 4 Automatic Undo Management 00:02:41 Duration
Lecture 5 UNDO Management 00:09:51 Duration
Lecture 6 Configuring Undo Retention Period 00:04:26 Duration
Lecture 7 Retention Guarantee!! 00:05:27 Duration

Section 8 : REDO Management

Lecture 1 REDO Concepts 00:07:13 Duration
Lecture 2 REDO Logfile Management Demo1 00:06:02 Duration
Lecture 3 REDO Logfile Management Demo2 00:03:32 Duration
Lecture 4 Archival Concepts 00:03:01 Duration
Lecture 5 Archival Log Mode Demo 00:03:09 Duration

Section 9 : User Management

Lecture 1 User Management Concepts 00:09:23 Duration
Lecture 2 User Management Demo 1 00:09:43 Duration
Lecture 3 User Management Demo 2 00:03:53 Duration
Lecture 4 User Creation Exercise
Lecture 5 Privileges 00:05:49 Duration
Lecture 6 System Privileges Demo 00:07:51 Duration
Lecture 7 Object Privileges Demo 00:05:38 Duration
Lecture 8 Revoking User Privileges 00:03:06 Duration
Lecture 9 Revoking System Privileges 00:02:14 Duration
Lecture 10 Revoking Object Privileges 00:02:19 Duration
Lecture 11 Let's practice what we learnt so far.. 00:02:23 Duration
Lecture 12 Role Management Concepts 00:04:10 Duration
Lecture 13 Role Management Demo 00:04:10 Duration
Lecture 14 User Profiles 00:05:34 Duration
Lecture 15 User Profile Demo 00:05:21 Duration
Lecture 16 Managing Passwords using Profiles 00:02:13 Duration

Section 10 : Oracle Networking

Lecture 1 Networking Concepts 00:10:00 Duration
Lecture 2 Listener Configuration Demo 00:09:00 Duration
Lecture 3 TNSNAMES Configuration Demo 00:07:35 Duration
Lecture 4 Database Link Concepts 00:03:32 Duration
Lecture 5 Public Database Link 00:05:09 Duration
Lecture 6 Private Database Link 00:02:49 Duration

Section 11 : Data Dictionary

Lecture 1 What is Data Dictionary 00:05:49 Duration
Lecture 2 Static Data Dictionary Views 00:09:24 Duration
Lecture 3 Dynamic Data Dictionary Views 00:03:46 Duration
Lecture 4 Miscellaneous Data Dictionary Views
Lecture 5 Data Dictionary Demo 00:13:29 Duration

Section 12 : Diagnostic Data

Lecture 1 What is Diagnostic Data 00:04:57 Duration
Lecture 2 Automatic Diagnostic Repository (ADR) 00:05:57 Duration
Lecture 3 Manually navigating through the Diagnostic Data 00:10:07 Duration
Lecture 4 Automatic Diagnostic Repository Command Interprete 00:01:00 Duration
Lecture 5 Using ADRCI to navigate through Diagnostic Data 00:08:22 Duration
Lecture 6 Creating an Incident Package for Oracle Support 00:05:12 Duration

Section 13 : Backup and Recovery (User Managed)

Lecture 1 Backup and Recovery Concepts 00:05:52 Duration
Lecture 2 Backup and Recovery Concepts 2 00:07:37 Duration
Lecture 3 Backup Types 00:04:05 Duration
Lecture 4 Performing a Cold Backup manually 00:09:46 Duration
Lecture 5 Hot Backup Steps 00:03:47 Duration
Lecture 6 Hot Backup Demo 00:09:10 Duration
Lecture 7 Recover a Control file from media failure 00:07:56 Duration
Lecture 8 Recover a System Data file from media failure 00:04:43 Duration
Lecture 9 Recover a non-system data file from media failure 00:06:28 Duration

Section 14 : Backup and Recovery (RMAN Backup)

Lecture 1 RMAN Backup Types 00:04:25 Duration
Lecture 2 Incremental Backup 00:04:25 Duration
Lecture 3 Recovery Manager (RMAN) Terminology
Lecture 4 Image Copies VS Backup sets 00:02:30 Duration
Lecture 5 Why RMAN 00:03:27 Duration
Lecture 6 RMAN Commands 00:03:55 Duration

Section 15 : Database Objects - Materialized Views

Lecture 1 Materialized Views Introduction 00:03:26 Duration
Lecture 2 Materialized Views creation Options 00:03:26 Duration
Lecture 3 Materialized Views with ON COMMIT option 00:05:38 Duration
Lecture 4 Materialized Views with ON DEMAND option 00:04:06 Duration
Lecture 5 Materialized Views with REFRESH FAST option 00:06:16 Duration
Lecture 6 Timing the refresh 00:03:50 Duration
Lecture 7 Query Rewrite functionality 00:05:41 Duration
Lecture 8 Materialized Views

Section 16 : Table Partitioning

Lecture 1 Table Partitioning Introduction 00:04:46 Duration
Lecture 2 Range Partition based on range of values 00:09:38 Duration
Lecture 3 List Partition based on list of values 00:06:09 Duration
Lecture 4 Hash Partition based on the hash key 00:05:41 Duration
Lecture 5 Composite Partitioning by mixing things up!! 00:04:38 Duration
Lecture 6 Interval Partition for automatic partition creati 00:07:13 Duration
Lecture 7 1 Partition Addition and Drop
Lecture 8 1 Table Partitioning