Oracle 12c Database Administration
Administer Multi-Terabyte Database Easily
Count
Deploy Oracle Standalone Database on Linux Machine
Oracle Multi-tenant architecture makes its way with release 12c! Administer both pluggable and container databases along with performing database backup & recovery. Fix database performance issues by analyzing AWR report. Generate SSH key pair for your Oracle cloud infrastructure machines and start preparing for your next DBA Interview with this course.
What you will learn
Install Oracle 12c on Linux servers quickly
Trigger database backup via RMAN to withstand any database corruption
Get deep understanding of database locks and resolve deadlocks issues
Administer users, tablespaces, network, backups, instance, database and more
Setup Oracle Database
15:14
LRU Algorithm
26:57
User Connection
22:24
Install Oracle 12c
02:56
Deinstall Oracle
Oracle Architecture
38:10
SQL Parsing
27:44
DML & DDL Processing
19:33
Oracle Silent Install
18:10
Oracle Background Process
08:52
Database Files
09:15
Memory Management
Create Oracle Database
36:06
DBCA Create Database
08:48
DBCA Silent Mode
13:31
Startup & Shutdown Modes
48:26
Oracle Metadata
13:39
Archivelog Mode
Tablespace Administration
15:20
Storage Structures
41:57
Manage Tablespaces
09:01
Capacity Planning
User Administration
16:24
User Namespace
25:43
Database Users
19:56
Roles and Permissions
42:47
User Profile
Networking and Utilities
27:25
Listener & TNS
11:56
Data Pump Architecture
07:19
Data Pump Performance
RMAN Full Backup
12:36
RMAN Backups Overview
14:19
RMAN Recovery Overview
45:18
FULL Database Recovery
RMAN Incremental Backup
22:31
Understanding L0 & L1
28:26
Incremental Recovery
07:05
RMAN PITR
29:20
Automating RMAN backups
Oracle Locking Mechanism
34:49
Database Locks
08:28
Deadlocks in Oracle
Oracle Performance Tuning
10:50
Performance Tuning Goals
24:25
Performance Tuning Steps
11:22
Performance Tuning Tools
04:51
Oracle SQL Optimizer
16:25
SQL Execution Plan
09:32
Oracle Indexes
04:56
Full Table VS Index Scan
16:35
Oracle SQL Tuning Advisor
38:21
Read AWR Report in Oracle
Oracle Cloud Infrastructure (OCI)
19:06
Oracle Cloud Overview
12:04
Generate SSH key pair
Oracle Multi-Tenant Architecture
14:22
Standalone Database Issues
18:35
Container VS Pluggable DB
10:42
Multi-Tenant File Structure
28:16
Create CDB & PDB
Oracle Multi-Tenant Administration
09:01
Navigating Inside PDB
03:36
Clone PDB from Another PDB
06:34
Multi-Tenant Networking
07:50
Plugging & Unplugging PDBs
06:50
Oracle Migration Methods