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 |