Section 1 : Introduction

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

Section 2 : Oracle Process Architecture

lecture 9 Process Architecture 2:25
lecture 10 Database Writer Process 4:6
lecture 11 Log writer Process 1:15
lecture 12 Checkpoint Process
lecture 13 SMON Process 1:18
lecture 14 PMON Process 2:25
lecture 15 RECO Process 1:58
lecture 16 Archiver Process 1:33

Section 3 : Oracle Memory Architecture

lecture 17 Memory Architecture 2:34
lecture 18 Database Buffer Cache 3:17
lecture 19 Shared Pool 7:21
lecture 20 REDO log buffer 1:3
lecture 21 Large Pool
lecture 22 Java Pool and Streams Pool 0:58
lecture 23 Keep Buffer Pool 3:0
lecture 24 Recycle Buffer Pool 1:49
lecture 25 About Certification Pdf
lecture 26 Program Global Area (PGA) 2:36
lecture 27 Dedicated vs Shared Databases 4:44
lecture 28 PGA in a Shared Envrionment 0:40

Section 4 : Architecture Recap

lecture 29 Architecture Full Picture!!!! 4:27

Section 5 : Software Installation

lecture 30 Software Download. Text
lecture 31 Virtual Machine Installation 2:21
lecture 32 Linux Installation 16:51
lecture 33 Oracle Software Installation 15:0
lecture 34 Oracle Parameter Files 5:55
lecture 40 Oracle 12c Upgrade 19:14

Section 6 : Tablespace Management

lecture 41 How data is stored in a Database 6:21
lecture 42 Table space Concepts 4:19
lecture 43 Online and Offline Table spaces 1:12
lecture 44 Let's create a Tablespace. 2:0
lecture 45 Let's add more space to the Database.. 2:10
lecture 46 Table space Demo 1 19:35
lecture 47 Table space Demo 2 6:10
lecture 48 Tablespaces with different block sizes 4:39
lecture 49 Temporary Tablespace Management 6:19
lecture 50 Temporary Tablespace Groups 6:18
lecture 51 Extent Management (Local vs Dictionary managed) 8:38

Section 7 : UNDO Management

lecture 52 UNDO Concepts 5:32
lecture 53 Read Consistency
lecture 54 ORA-01555 snapshot too old error 2:35
lecture 55 Automatic Undo Management 2:41
lecture 56 UNDO Management 9:51
lecture 57 Configuring Undo Retention Period 4:26
lecture 58 Retention Guarantee!! 5:27

Section 8 : REDO Management

lecture 59 REDO Concepts 7:13
lecture 60 REDO Logfile Management Demo1 6:2
lecture 61 REDO Logfile Management Demo2 3:32
lecture 62 Archival Concepts 3:1
lecture 63 Archival Log Mode Demo 3:9

Section 9 : User Management

lecture 64 User Management Concepts 9:23
lecture 65 User Management Demo 1 9:43
lecture 66 User Management Demo 2 3:53
lecture 67 User Creation Exercise Text
lecture 68 Privileges 5:49
lecture 69 System Privileges Demo 7:51
lecture 70 Object Privileges Demo 5:38
lecture 71 Revoking User Privileges 3:6
lecture 72 Revoking System Privileges 2:14
lecture 73 Revoking Object Privileges 2:19
lecture 74 Let's practice what we learnt so far.. 2:23
lecture 75 Role Management Concepts 4:10
lecture 76 Role Management Demo 4:10
lecture 77 User Profiles 5:34
lecture 78 User Profile Demo 5:21
lecture 79 Managing Passwords using Profiles 2:13

Section 10 : Oracle Networking

lecture 80 Networking Concepts 10:0
lecture 81 Listener Configuration Demo 9:0
lecture 82 TNSNAMES Configuration Demo 7:35
lecture 83 Database Link Concepts 3:32
lecture 84 Public Database Link 5:9
lecture 85 Private Database Link 2:49

Section 11 : Data Dictionary

lecture 86 What is Data Dictionary 5:49
lecture 87 Static Data Dictionary Views 9:24
lecture 88 Dynamic Data Dictionary Views 3:46
lecture 89 Miscellaneous Data Dictionary Views
lecture 90 Data Dictionary Demo 13:29

Section 12 : Diagnostic Data

lecture 91 What is Diagnostic Data 4:57
lecture 92 Automatic Diagnostic Repository (ADR) 5:57
lecture 93 Manually navigating through the Diagnostic Data 10:7
lecture 94 Automatic Diagnostic Repository Command Interprete 1:0
lecture 95 Using ADRCI to navigate through Diagnostic Data 8:22
lecture 96 Creating an Incident Package for Oracle Support 5:12

Section 13 : Backup and Recovery (User Managed)

lecture 97 Backup and Recovery Concepts 5:52
lecture 98 Backup and Recovery Concepts 2 7:37
lecture 99 Backup Types 4:5
lecture 100 Performing a Cold Backup manually 9:46
lecture 101 Hot Backup Steps 3:47
lecture 102 Hot Backup Demo 9:10
lecture 103 Recover a Control file from media failure 7:56
lecture 104 Recover a System Data file from media failure 4:43
lecture 105 Recover a non-system data file from media failure 6:28

Section 14 : Backup and Recovery (RMAN Backup)

lecture 106 RMAN Backup Types 4:25
lecture 107 Incremental Backup 4:25
lecture 108 Recovery Manager (RMAN) Terminology
lecture 109 Image Copies VS Backup sets 2:30
lecture 110 Why RMAN 3:27
lecture 111 RMAN Commands 3:55

Section 15 : Database Objects - Materialized Views

lecture 112 Materialized Views Introduction 3:26
lecture 113 Materialized Views creation Options 3:26
lecture 114 Materialized Views with ON COMMIT option 5:38
lecture 115 Materialized Views with ON DEMAND option 4:6
lecture 116 Materialized Views with REFRESH FAST option 6:16
lecture 117 Timing the refresh 3:50
lecture 118 Query Rewrite functionality 5:41
lecture 119 Materialized Views Pdf

Section 16 : Table Partitioning

lecture 120 Table Partitioning Introduction 4:46
lecture 121 Range Partition based on range of values 9:38
lecture 122 List Partition based on list of values 6:9
lecture 123 Hash Partition based on the hash key 5:41
lecture 124 Composite Partitioning by mixing things up!! 4:38
lecture 125 Interval Partition for automatic partition creati 7:13
lecture 126 1 Partition Addition and Drop Pdf
lecture 127 1 Table Partitioning Pdf