IIRF Online > Office Productivity > Oracle > Oracle Database > Complete Oracle Database Administration course (19C,21C)
Complete Oracle Database Administration course (19C,21C) by Udemy
Oracle Database Administration course /Multitenancy/ Oracle Database Backup& Recovery/Data Guard/Patching & Upgrade
Course Highlights
- 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
Skills you will learn!
Curriculum
1 Topic
Introduction
3 Topics
Oracle Database Server Architecture. Basics.
Physical files of the Database review
Possible Oracle Server Configurations
5 Topics
Important Message
Create and configure Virtual machine in VirtualBox Manager
Download and Install Oracle Linux on VM
SOFTWARE SILENT INSTALLATION
License Warning
4 Topics
Memory Structures
Memory Management
Background processes
Multitenant Architecture
4 Topics
SQL*Plus
Oracle SQL Developer
SQLcl
OEM
5 Topics
Initialization Parameters
Starting DB Instance
Diagnostic Repository
Data Dictionary
Shutting Down an DB Instance
6 Topics
Creating PDBs from SEED
Cloning PDBs
Refreshable Clone
Unplugging and Plugging PDBs
Unplug/Plug PDB using an archive file
Dropping PDBs
2 Topics
Part 1
Part 2
6 Topics
Creating Users
Privileges & Roles
Show Privileges
Revoke privilege Drop roles and users
Authentication
Limit Resources
1 Topic
TDE
4 Topics
General Information
Create Tablespaces
Alter Tablespace
OMF
5 Topics
What is UNDO?
UNDO vs REDO
Read-consistent queries
Flashback queries
UNDO Management
27 Topics
What can go wrong?
What should you configure in DB?
RMAN
Backup Types
Backup pieces sets and image copies
RMAN configuration
Create a Full DB backup
Create an Incremental DB backup
Backup Strategies
Backup Scripts
Schedule Backup Scripts
Viewing Backups
Remove RMAN Backups
Manage Archived Redo Logs with RMAN
Detect Data Corruption with RMAN
Recovery Decision
Restore lost Control File
Recover from the lost Redo Log File
Understand Complete and Incomplete Recovery
High Level Procedure for the Recovery with RMAN
Recover PDB
PDB PITR
Recover CDB
CDB PITR
Checkpoint
Instance Recovery
Instance MTTR
6 Topics
General Procedure
Checking Installed Patches
Download Patch
Upgrade OPatch tools
Preparation steps
Apply Patch
6 Topics
Monitoring Script ( part 1 )
Monitoring Script ( part 2 )
EM: Connection
EM: Create Load
EM: Analyze Data
Create AWR report
3 Topics
Upgrade Overview
Upgrade PDB with UNPLUG/PLUG
Upgrade PDB using Refreshable Clone method
9 Topics
Introduction
Architecture
DG configuration: Steps on the Primary DB
DG configuration: STBY server configuration
DG configuration: Network
DG configuration: Create Standby Database
DG configuration: Broker
Switchover
Failover
6 Topics
Data Pump (part I)
Data Pump (part II)
Load records from a CSV file by using Linux commands
Load Data from a CSV file by using External Tables (part1)
Load Data from a CSV file by using External Tables (part2)
Load Data From a CSV file by using SQL Loader
7 Topics
Automate Startup of the Oracle Database
Discovere if a System Parameter has been changed
Rebuild or Coalesce?
Recover a Corrupted Block
Restore RMAN backup on the New Server
TDE Rekey Operation
Investigate TNS-01159/TNS-12540 Listener errors
4 Topics
1Z0-082 topics
1Z0-082 - part 1
1Z0-082 - part 2
1Z0-082 - part 3
3 Topics
Create an Always Free Cloud Account
Create ATP database
Connect to ATP ( SQL Developer )
2 Topics
Important announcement
Installing Sample Schemas
Complete Oracle Database Administration course (19C,21C)
Related Oracle Database Courses
Thank You!
Your review has been submitted successfully.