4.49 out of 5
240 reviews on Udemy

Complete Oracle Database Administration course (19C,21C)

Oracle Database Administration course /Multitenancy/ Oracle Database Backup&Recovery/Data Guard/Patching & Upgrade
Oleksiy Gusarov
1,793 students enrolled
English [Auto]
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

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.

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.5 out of 5
240 Ratings

Detailed Rating

Stars 5
Stars 4
Stars 3
Stars 2
Stars 1
30-Day Money-Back Guarantee


9 hours on-demand video
7 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion


Working hours

Monday 9:30 am - 6.00 pm
Tuesday 9:30 am - 6.00 pm
Wednesday 9:30 am - 6.00 pm
Thursday 9:30 am - 6.00 pm
Friday 9:30 am - 5.00 pm
Saturday Closed
Sunday Closed