Complete Oracle Database Administration course (19C,21C)
Oracle Database Administration course /Multitenancy/ Oracle Database Backup&Recovery/Data Guard/Patching & Upgrade
Created by Oleksiy Gusarov | 9.5 hours on-demand video course
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.
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
- Guard configuration
- Applying the latest Database Patch
- Database Upgrade from 19c to 21c
Recommended Course