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