Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Oracle Multitenant Database Administration (DBA)

Learn complete Oracle Multitenant Database Administration. Create CDB and PDBs. Use Resource Manager & Data Pump Utility
(2 reviews)
31 students
Created by


CourseMarks Score®







Platform: Udemy
Video: 7h 23m
Language: English
Next start: On Demand

Top Data Architecture courses:

Detailed Analysis

CourseMarks Score®

6.9 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness Score

8.2 / 10
This course was last updated on 11/2020.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Student Feedback

3.8 / 10
We analyzed factors such as the rating (2.2/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Content Score

8.1 / 10
Video Score: 8.7 / 10
The course includes 7h 23m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
The average video length is 4 hours 35 minutes of 2 Data Architecture courses on Udemy.
Detail Score: 10.0 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 5.5 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

0 article.
0 resource.
0 exercise.
0 test.

Table of contents


A warm welcome to the Oracle Multitenant DBA course by Uplatz.

Post Oracle 12c, Oracle came up with new architecture called Multitenant Architecture.
In previous versions of Oracle database versions, there was a major problem – if the user starts a new instance there are particular background processes for each instance and each of these process wasted a lot of memory and resources thus affecting the system performance badly. Hence, Oracle came up with a new idea to connect different databases into one database technique. That idea is called “Multitenant Architecture.”
That one main database is called CDB (Container Database) and other databases which are used to connect the main database are called PDB (Pluggable Database). A pluggable database is fully compatible with a non-CDB. In fact, Oracle has something called the PDB/non-CDB compatibility guarantee, which states that anything you would do in a non-CDB would also work in a PDB. This compatibility guarantee is important when it comes to certifying things like third-party vendor products to work in a multitenant architecture.

How to create a multitenant database environment in Oracle 12c
When creating a database, you must designate it as a CDB or non-CDB for it to be able to support the multitenant architecture. The next set of examples walks you through the steps to create a container database with the DBCA. There is only one step that differentiates a CDB from a non-CDB when using the DBCA.
The multitenant architecture enables you to have many pluggable databases inside a single Oracle Database instance. The Oracle Multitenant Database Architecture is designed to host multiple “PLUGGABLE DATABASE” PDB databases within a single CDB “CONTAINER DATABASE” container instance. The architecture of the CDB instance maintains more PDBs within it, using the same set of processes and the same SGA (System Global Area).

Main components of Multitenant Architecture
1) CDB – Container Database – this is the mother container (main container). Control files and Redo log files are the main files of the CDB.
2) CDB$Root – Root Container – every CDB has one root container (CDB$Root). All Pluggable databases (PDBs) control and manage by root container. All PDBs belong to root container. Root container does not store user data.
3) PDB – Pluggable Database. There can be connect one or more PDBs to the container database. This is a separate database that creates by a user or creates for a user to store particular data. We can store data in PDBs that can support particular applications.
4. PDB$SEED – Seed Container. This is a system-supplied template that is used to create new PDBs. We cannot add or modify objects in Seed Container (PDB$SEED).

Benefits of Multitenant Architecture
•Can combine many databases at once
•Patches and upgrades can apply easily to CDB
•PDBs can unplug from one CDB and can connect to another CDB
•Can manage many databases at once

The Multitenant architecture facilitates the following:
•High consolidation density: Many databases can share memory and background processes.
•Provisioning: A database can be unplugged from one environment and plugged into another or cloned with SQL commands in just a few seconds. They can even be plugged across operating systems and chipsets.
•Patching and upgrades: You can patch a database simply by unplugging from one unpatched container and plugging it into another patched container.
•Manage many databases concurrently: You can do tasks such as backing up and patching on the primary container database instead of the individual pluggable databases.
•Resource management: The Oracle Resource Manager feature can work at the pluggable database level for you to manage resource competition among the databases in your environment.

This Oracle Multitenant DBA course by Uplatz will help you learn the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs). You will understand the process of installing Oracle Database 19c followed by the creation of CDB and non-CDB databases. Oracle Database 19c Multitenant Architecture course explores the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs). In this Oracle Multitenant Database Administration course, you will be creating a PDB through different methods, managing users, understanding the back-up and recovery processes in CDB and PDBs. You will also gain knowledge of the various utilities used for e.g. resource manager, data pump utility, and so on. Overall, you’ll become a professional Oracle Multitenant DBA with end-to-end skills on managing applications and application containers.

Oracle Multitenant DBA – Course Syllabus

•Overview of Oracle Multitenant DBA
•Installing Oracle Linux 7.8 in Oracle Virtual Box
•Installing Oracle Database 19c Software
•Creating CDB and non-CDB databases
•Creating PDBs from the Seed
•Performing Basic CDB Administration Tasks
•Creating a PDB by Cloning from Local and Remote PDBs
•Creating PDB by Plugging in an Unplugged PDB
•Creating a PDB from non-CDB
•Creating a PDB by Relocating a PDB
•Managing Common and Local Users
•Backup and Recovery in CDB and PDBs
•Flashback and Point-in-time Recovery
•Using Resource Manager with CDB and PDBs
•Using Data Pump Utility with PDBs
•Managing Applications and Application Containers

You will learn

✓ End-to-end knowledge of Oracle Multitenant Database Administration
✓ Become a top Oracle DBA
✓ Learn Oracle Multitenant Database Administration & Management
✓ Manage Oracle Database Multitenant Architecture
✓ Overview of Oracle Multitenant DBA
✓ Installing Oracle Linux 7.8 in Oracle Virtual Box
✓ Installing Oracle Database 19c Software
✓ Creating CDB and non-CDB databases
✓ Creating PDBs from the Seed
✓ Performing Basic CDB Administration Tasks
✓ Creating a PDB by Cloning from Local and Remote PDBs
✓ Creating PDB by Plugging in an Unplugged PDB
✓ Creating a PDB from non-CDB
✓ Creating a PDB by Relocating a PDB
✓ Managing Common and Local Users
✓ Backup and Recovery in CDB and PDBs
✓ Flashback and Point-in-time Recovery
✓ Using Resource Manager with CDB and PDBs
✓ Using Data Pump Utility with PDBs
✓ Managing Applications and Application Containers


• Enthusiasm and determination to make your mark on the world!

This course is for

• Oracle Database Administrators (DBAs) and Senior DBAs
• Oracle Database Consultants
• Individuals aspiring for a career in Oracle Database Administration
• Database Security Analysts
• Application Developers
• Database Architects and Technical Architects
• Lead Developers
• Solution Architects
• Oracle Cloud Administrators
• System & Database Analysts
• Anyone interested in learning Oracle Multitenant Database Management
• ETL Developers
• Oracle Database Tuning Specialists

How much does the Oracle Multitenant Database Administration (DBA) course cost? Is it worth it?

The course costs $14.99. And currently there is a 82% discount on the original price of the course, which was $84.99. So you save $70 if you enroll the course now.
The average price is $15.0 of 2 Data Architecture courses. So this course is 0% cheaper than the average Data Architecture course on Udemy.

Does the Oracle Multitenant Database Administration (DBA) course have a money back guarantee or refund policy?

YES, Oracle Multitenant Database Administration (DBA) has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any SCHOLARSHIPS for this course?

Currently we could not find a scholarship for the Oracle Multitenant Database Administration (DBA) course, but there is a $70 discount from the original price ($84.99). So the current price is just $14.99.

Who is the instructor? Is Uplatz Training a SCAM or a TRUSTED instructor?

Uplatz Training has created 147 courses that got 10,562 reviews which are generally positive. Uplatz Training has taught 374,529 students and received a 3.7 average review out of 10,562 reviews. Depending on the information available, Uplatz Training is a TRUSTED instructor.
Fastest growing Global IT Training Provider
Uplatz is UK-based leading IT Training provider serving students across the globe. Our uniqueness comes from the fact that we provide online training courses at a fraction of the average cost of these courses in the market.
Over a short span of 3 years, Uplatz has grown massively to become a truly global IT training provider with a wide range of career-oriented courses on cutting-edge technologies and software programming.
Our specialization includes Data Science, Data Engineering, SAP, Oracle, Salesforce, AWS, Microsoft Azure, Google Cloud, IBM Cloud, SAS, Python, R, JavaScript, Java, Full Stack Web Development, Mobile App Development, BI & Visualization, Tableau, Power BI, Spotfire, Data warehousing, ETL tools, Informatica, IBM Data Stage, Digital Marketing, Agile, DevOps, and more.
Founded in March 2017, Uplatz has seen phenomenal rise in the training industry starting with an online course on SAP FICO and now providing training on 5000+ courses across 103 countries having served 300,000 students in a period of just 3 years.
Uplatz’s training courses are highly structured, subject-focused, and job-oriented with strong emphasis on practice and assignments. Our courses are designed and taught by more than a thousand highly skilled and experienced tutors who have strong expertise in their areas whether it be AWS, Azure, Adobe, SAP, Oracle, or any other technology or in-demand software.
Browse all courses by on Coursemarks.


CourseMarks Score®







Platform: Udemy
Video: 7h 23m
Language: English
Next start: On Demand

Students are also interested in

Review widget (for course creators):

Oracle Multitenant Database Administration (DBA) rating
Code for the widget (just copy and paste it to your site):
<a href="https://coursemarks.com/course/oracle-multitenant-database-administration-complete-training/" target="_blank" title="Oracle Multitenant Database Administration (DBA) on Coursemarks.com"><img border="0" src="https://coursemarks.com/widget/cmrated.svg" width="200px" alt="Oracle Multitenant Database Administration (DBA) rating"/></a>