
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
LRU Algorithm
15m
User Connection
26m
Install Oracle 12c
22m
Deinstall Oracle
2m
Oracle Architecture
SQL Parsing
38m
DML & DDL Processing
27m
Oracle Silent Install
19m
Oracle Background Process
18m
Database Files
8m
Memory Management
9m
Create Oracle Database
DBCA Create Database
36m
DBCA Silent Mode
8m
Startup & Shutdown Modes
13m
Oracle Metadata
48m
Archivelog Mode
13m
Tablespace Administration
Storage Structures
15m
Manage Tablespaces
41m
Capacity Planning
9m
User Administration
User Namespace
16m
Database Users
25m
Roles and Permissions
19m
User Profile
42m
Networking and Utilities
Listener & TNS
20m
Data Pump Architecture
11m
Data Pump Performance
07m
RMAN Full Backup
RMAN Backups Overview
12m
RMAN Recovery Overview
14m
FULL Database Recovery
45m
RMAN Incremental Backup
Understanding L0 & L1
22m
Incremental Recovery
28m
RMAN PITR
7m
Automating RMAN backups
29m
Oracle Locking Mechanism
Database Locks
34m
Deadlocks in Oracle
8m
Oracle Performance Tuning
Performance Tuning Goals
10m
Performance Tuning Steps
24m
Performance Tuning Tools
11m
Oracle SQL Optimizer
4m
SQL Execution Plan
16m
Oracle Indexes
9m
Full Table VS Index Scan
4m
Oracle SQL Tuning Advisor
16m
Read AWR Report in Oracle
38m
Oracle Cloud Infrastructure (OCI)
Oracle Cloud Overview
19m
Generate SSH key pair
12m
Oracle Multi-Tenant Architecture
Standalone Database Issues
14m
Container VS Pluggable DB
18m
Multi-Tenant File Structure
10m
Create CDB & PDB
28m
Oracle Multi-Tenant Administration
Navigating Inside PDB
9m
Clone PDB from Another PDB
3m
Multi-Tenant Networking
6m
Plugging & Unplugging PDBs
7m
Oracle Migration Methods
6m

Notification Message!