Complete Oracle Database Administration course 19C21C

Oracle Database Administration course /Multitenancy/ Oracle Database Backup&Recovery/Data Guard/Patching & Upgrade
Complete Oracle Database Administration course 19C21C
File Size :
4.38 GB
Total length :
9h 48m



Oleksiy Gusarov


Last update




Complete Oracle Database Administration course 19C21C

What you’ll learn

Oracle Database Administration
Oracle Database Architecture, Physical files of the DB, Memory Structures, Memory Management, Background Processes
How to install Oracle Database Software on the server without GUI
How to access Oracle Database via sqlplus, sqlcl and SQL Developer
Managing Database Instance: Starting and Shutting down DB, working with initialization parameters, Diagnosing problems, working with Data Dictionary
Oracle Net Services
Administering User Access, Privileges & Roles, Resource Limitation
Multitenancy: Creating PDBs from SEED, Clonning PDBs, creating Refreshable Clones, Unplug/Plug PDBs
Transparent Data Encryption (TDE)
Creating and Managing Tablespaces
Managing UNDO Data
Practicing different Backup and Recovery scenarious via RMAN
Moving Data: Data Pump, SQL Loader
Data Guard configuration
Applying the latest Database Patch
Database Upgrade from 19c to 21c

Complete Oracle Database Administration course 19C21C


Basic Linux Knowledge
understand what is a process in linux
Basic SQL Knowledge


After completing this Complete Oracle Database Administration course (19C,21C) course you will become a confident Database Administrator and will be ready to jump start your career.You get hands-on experience in the most common administration tasks. You will create and configure Oracle Database Server for the real world production scenario ( in 99% there is no GUI on production servers ). We will go the extra mile and implement different backup strategies, perform numerous restore operations in the Oracle Database Backup&Recovery section of the course. We don’t forget about Patching operations. Because these operations are required to comply with information security policies. And we will have many more interesting assignments.According to the U.S. BUREAU OF LABOR STATISTICS employment of database administrators is projected to grow 15 percent from 2019 to 2029, much faster than the average for all occupations. Growth in this occupation will be driven by the increased data needs of companies across the economy. After the pandemic the demand doubles.There is a lack of DBAs even in the Oracle itself! Follow my Instagram page – @it.rockstars, where I post new opening positions on a regular basis.The long-term support Oracle Database 19c version was chosen for this course to teach you the database administration skills. It provides the highest level of release stability and longest duration of support and bug fixes, giving you the most stable platform for your applications.At the end of the course we will learn different ways to Upgrade from the 19c to 21c version. Upgrades are crucial to satisfy business high growing demands for the new features released in the new product versions. All operation manuals provided for the 19c version still work on 21c.


Section 1: Introduction

Lecture 1 Introduction

Section 2: Oracle Database Architecture ( part 1 )

Lecture 2 Oracle Database Server Architecture. Basics.

Lecture 3 Physical files of the Database review

Lecture 4 Possible Oracle Server Configurations

Section 3: Oracle Database Installation

Lecture 5 Important Message

Lecture 6 Create and configure Virtual machine in VirtualBox Manager

Lecture 7 Download and Install Oracle Linux on VM


Lecture 9 License Warning

Section 4: Oracle Database Architecture ( part 2 )

Lecture 10 Memory Structures

Lecture 11 Memory Management

Lecture 12 Background processes

Lecture 13 Multitenant Architecture

Section 5: Accessing an Oracle Database

Lecture 14 SQL*Plus

Lecture 15 Oracle SQL Developer

Lecture 16 SQLcl

Lecture 17 OEM

Section 6: Manage Database Instance

Lecture 18 Initialization Parameters

Lecture 19 Starting DB Instance

Lecture 20 Diagnostic Repository

Lecture 21 Data Dictionary

Lecture 22 Shutting Down an DB Instance

Section 7: Creating PDBs

Lecture 23 Creating PDBs from SEED

Lecture 24 Cloning PDBs

Lecture 25 Refreshable Clone

Lecture 26 Unplugging and Plugging PDBs

Lecture 27 Unplug/Plug PDB using an archive file

Lecture 28 Dropping PDBs

Section 8: Oracle Net Services

Lecture 29 Part 1

Lecture 30 Part 2

Section 9: Users

Lecture 31 Creating Users

Lecture 32 Privileges & Roles

Lecture 33 Show Privileges

Lecture 34 Revoke privilege, Drop roles and users

Lecture 35 Authentication

Lecture 36 Limit Resources

Section 10: TDE

Lecture 37 TDE

Section 11: Tablespaces

Lecture 38 General Information

Lecture 39 Create Tablespaces

Lecture 40 Alter Tablespace

Lecture 41 OMF

Section 12: UNDO

Lecture 42 What is UNDO?

Lecture 43 UNDO vs REDO

Lecture 44 Read-consistent queries

Lecture 45 Flashback queries

Lecture 46 UNDO Management

Section 13: Backup & Recovery

Lecture 47 What can go wrong?

Lecture 48 What should you configure in DB?

Lecture 49 RMAN

Lecture 50 Backup Types

Lecture 51 Backup pieces, sets and image copies

Lecture 52 RMAN configuration

Lecture 53 Create a Full DB backup

Lecture 54 Create an Incremental DB backup

Lecture 55 Backup Strategies

Lecture 56 Backup Scripts

Lecture 57 Schedule Backup Scripts

Lecture 58 Viewing Backups

Lecture 59 Remove RMAN Backups

Lecture 60 Manage Archived Redo Logs with RMAN

Lecture 61 Detect Data Corruption with RMAN

Lecture 62 Recovery Decision

Lecture 63 Restore lost Control File

Lecture 64 Recover from the lost Redo Log File

Lecture 65 Understand Complete and Incomplete Recovery

Lecture 66 High Level Procedure for the Recovery with RMAN

Lecture 67 Recover PDB

Lecture 68 PDB PITR

Lecture 69 Recover CDB

Lecture 70 CDB PITR

Lecture 71 Checkpoint

Lecture 72 Instance Recovery

Lecture 73 Instance MTTR

Section 14: Patch DB

Lecture 74 General Procedure

Lecture 75 Checking Installed Patches

Lecture 76 Download Patch

Lecture 77 Upgrade OPatch tools

Lecture 78 Preparation steps

Lecture 79 Apply Patch

Section 15: Monitoring

Lecture 80 Monitoring Script ( part 1 )

Lecture 81 Monitoring Script ( part 2 )

Lecture 82 EM: Connection

Lecture 83 EM: Create Load

Lecture 84 EM: Analyze Data

Lecture 85 Create AWR report

Section 16: Oracle Database Upgrade from 19c to 21c

Lecture 86 Upgrade Overview

Lecture 87 Upgrade PDB with UNPLUG/PLUG

Lecture 88 Upgrade PDB using Refreshable Clone method

Section 17: Data Guard

Lecture 89 Introduction

Lecture 90 Architecture

Lecture 91 DG configuration: Steps on the Primary DB

Lecture 92 DG configuration: STBY server configuration

Lecture 93 DG configuration: Network

Lecture 94 DG configuration: Create Standby Database

Lecture 95 DG configuration: Broker

Lecture 96 Switchover

Lecture 97 Failover

Section 18: Moving Data

Lecture 98 Data Pump (part I)

Lecture 99 Data Pump (part II)

Lecture 100 Load records from a CSV file by using Linux commands

Lecture 101 Load Data from a CSV file by using External Tables (part1)

Lecture 102 Load Data from a CSV file by using External Tables (part2)

Lecture 103 Load Data From a CSV file by using SQL Loader

Section 19: Production Challenges

Lecture 104 Automate Startup of the Oracle Database

Lecture 105 Discovere if a System Parameter has been changed

Lecture 106 Rebuild or Coalesce?

Lecture 107 Recover a Corrupted Block

Lecture 108 Restore RMAN backup on the New Server

Lecture 109 TDE Rekey Operation

Section 20: BONUS: 1Z0-082 Exam Examples ( Database Administration Part )

Lecture 110 1Z0-082 topics

Section 21: BONUS: ATP ( Database in the Oracle Cloud )

Lecture 111 Create an Always Free Cloud Account

Lecture 112 Create ATP database

Lecture 113 Connect to ATP ( SQL Developer )

Section 22: BONUS: Practice SQL skills

Lecture 114 Important announcement

Lecture 115 Installing Sample Schemas

Students looking for a job in IT industry,IT specialists willing to improve their database knowledge,Retraining for DBA who worked with other Database Management Systems,Oracle Database Beginners willing to advance

Course Information:

Udemy | English | 9h 48m | 4.38 GB
Created by: Oleksiy Gusarov

You Can See More Courses in the IT & Software >> Greetings from

New Courses

Scroll to Top