Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Oracle 12c Database Administration
Welcome to the course!
Welcome to the course (37:57)
Course overview (45:07)
How to get help
Introduction to Oracle Database
LRU Algorithm (19:49)
Oracle user connectivity (31:57)
Database vs instance (4:30)
Install Oracle Software
How to access cloud server? (10:26)
Oracle database pre-requisites (23:22)
Install Oracle 12c on Linux (9:58)
Set Linux bash_profile (8:30)
Deinstall Oracle software (3:50)
Assignment (18:23)
Oracle Database Architecture
Student interaction (15:55)
Phases of SQL execution (9:46)
Select statement processing (29:46)
Latch vs cursor (19:58)
Hard parsing vs soft parsing (11:27)
DML statement processing (39:14)
DDL statement processing (11:22)
Oracle silent installation (39:25)
Assignment time
Oracle Advance Architecture
Oracle architecture components
Oracle background process (21:09)
Understanding database files (9:58)
Oracle memory management (10:49)
Create Database
DBCA database creation (31:19)
DBCA database deletion (20:02)
DBCA silent mode (9:37)
Database startup & shutdown (15:34)
Identify database files (32:23)
Oracle metadata (22:22)
Database archivelog mode (16:03)
Assignment time (6:35)
Manual db creation
Tablespace Administration
Database storage structures (23:28)
Manage Database Tablespaces (32:41)
Tablespace Utilization (15:28)
Drop tablespace (6:34)
User Administration
User namespace (17:46)
Manage database users (27:45)
User roles and permissions (22:53)
User profile management (53:38)
Oracle Networking
Configure oracle listener (15:26)
Create TNS entries (30:20)
Assignment time
Must Read
Oracle database utilities
Oracle Database Utilities
Datapump DIRECT=Y parameter (8:22)
Oracle external tables (18:32)
Oracle datapump architecture (29:47)
Datapump over network (7:41)
Assignment time
Oracle Backup & Recovery
Oracle RMAN Database Backups
Introduction to Oracle backup (17:56)
RMAN recovery overview (33:59)
RMAN recover database (live scenario) (136:00)
Consistent vs inconsistent backup (4:00)
RMAN Incremental Backup & Recovery
Incremental L1 vs archive logs (18:50)
Incremental backup benefits (5:11)
Cummulative vs differential backup (35:09)
Incremental backup & recovery (54:31)
Advance RMAN concepts
RMAN PITR (25:45)
RMAN cold backup (9:59)
Automating RMAN backups (84:15)
RMAN recovery catalog (24:25)
Oracle scheduler (77:50)
Oracle Space Management
Database capacity planning (21:25)
Oracle segment advisor (39:26)
Oracle table compression (3:28)
Oracle Locking Mechanism
Database locks (85:13)
Deadlocks in oracle (16:10)
Oracle Performance Tuning
Performance tuning goals (17:17)
Performance tuning steps (33:18)
Performance tuning tools (16:54)
Oracle SQL optimizer (8:03)
SQL execution plan (24:52)
Oracle indexes (14:45)
Full table scan vs index scan (7:24)
Oracle SQL tuning advisor (26:05)
Read AWR report in Oracle (70:26)
Oracle Cloud Infrastructure (OCI)
What is cloud? (7:36)
Oracle cloud overview (20:56)
Generate Oracle cloud SSH key pair (23:48)
Oracle Multi-tenant Architecture
Standalone database issues (19:10)
Oracle multi-tenant overview (8:55)
Container vs pluggable database (13:44)
Undo tablespace in multi-tenant (5:38)
Multi-tenant file structure (6:19)
Playing with CDB and PDB
Create CDB in 12cR2 (17:12)
Navigating inside CDB (8:17)
Create PDB from PDB$SEED (17:39)
Oracle Multi-tenant Administration
Navigating inside PDB (12:48)
Enable archivelog mode in CDB (1:56)
Clone PDB from another PDB (6:18)
Proxy PDB overview (1:33)
Multi-tenant Networking (5:25)
Connecting specific PDB (5:43)
Plugging & unplugging PDBs (12:47)
Assignment time (8:35)
Course Summary
Oracle database upgrade
Oracle migration methods (10:58)
12c DBA Interview Questions
Oracle 12c Certification Dumps
Goodbye for now! (12:28)
Final Assignment
RMAN cold backup
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock