Packt
The Oracle Database Multitenant Administration Course
Packt

The Oracle Database Multitenant Administration Course

Included with Coursera Plus

Gain insight into a topic and learn the fundamentals.
Beginner level

Recommended experience

15 hours to complete
3 weeks at 5 hours a week
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
Beginner level

Recommended experience

15 hours to complete
3 weeks at 5 hours a week
Flexible schedule
Learn at your own pace

What you'll learn

  • Identify the components and structure of Oracle Multitenant architecture.

  • Explain the differences between Container Databases (CDBs) and Pluggable Databases (PDBs).

  • Evaluate the security and resource management options within an Oracle Multitenant environment.

  • Develop and implement advanced Oracle Multitenant configurations, including PDB cloning and relocation.

Details to know

Shareable certificate

Add to your LinkedIn profile

Recently updated!

October 2024

Assessments

7 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 16 modules in this course

In this module, we will introduce you to the Oracle Database Multitenant architecture and outline the course objectives. You'll gain an understanding of the key topics that will be explored and how they relate to multitenant database administration.

What's included

2 videos1 reading

In this module, we will delve into the Oracle Database Multitenant Architecture, covering both the 12.1 and 12.2 versions. You will explore the architecture’s key components and examine the improvements and new features introduced in the 12.2 version.

What's included

3 videos

In this module, we will guide you through the process of creating Container Databases (CDBs) and Pluggable Databases (PDBs). You will engage in hands-on practice to build a CDB, starting with preparing the environment and then creating and managing CDBs and PDBs in multiple parts.

What's included

8 videos1 assignment

In this module, we will explore fundamental concepts of Oracle Database Multitenant administration and cover essential tasks such as managing CDBs and PDBs. You will also participate in practical exercises to reinforce your understanding and skills in performing basic administration tasks.

What's included

4 videos

In this module, we will explore the multiple methods available for creating Pluggable Databases (PDBs) within the Oracle Multitenant framework. You’ll gain practical experience by cloning PDBs, plugging in unplugged PDBs, converting non-CDBs, and creating proxy and refreshable PDBs using advanced techniques.

What's included

9 videos

In this module, we will focus on the management of connectivity and services within Oracle Multitenant environments. You will learn about different connectivity options, how to set up and manage services for effective communication, and techniques for troubleshooting common connectivity issues.

What's included

1 video1 assignment

In this module, we will delve into the security aspects of Oracle Multitenant databases, focusing on user management and lockdown profiles. You’ll learn how to manage both local and common users and apply PDB lockdown profiles to enhance security. Hands-on exercises will solidify your understanding of these critical security practices.

What's included

5 videos

In this module, we will cover essential strategies for managing backup, recovery, and flashback operations within Oracle Multitenant databases. You will learn how to perform backups, recover from failures, and utilize flashback and point-in-time recovery features. Hands-on practices will reinforce your ability to protect and restore both CDBs and PDBs efficiently.

What's included

6 videos

In this module, we will explore the use of Oracle Resource Manager within a multitenant database environment. You will learn how to configure and manage Resource Manager plans to ensure optimal resource distribution among CDBs and PDBs, enhancing overall database performance and efficiency.

What's included

3 videos1 assignment

In this module, we will cover a range of miscellaneous topics related to Oracle Multitenant databases, including advanced features and tools. You will engage in practical exercises to apply these topics, such as using the Data Pump utility for data export and import within PDBs, to further refine your multitenant database administration skills.

What's included

3 videos

In this module, we will focus on managing applications and application containers within Oracle Multitenant databases. You will learn how to handle application common objects, perform essential maintenance tasks, and manage applications effectively. Hands-on practices will solidify your skills in administering applications within a multitenant environment.

What's included

5 videos

In this module, we will explore the latest features introduced in Oracle Database Multitenant with versions 18c and 19c. You will learn how to prepare and configure the Oracle Database 19c environment to take full advantage of these enhancements through step-by-step practice sessions.

What's included

4 videos1 assignment

In this module, we will cover the management of a CDB fleet, focusing on how to oversee multiple Container Databases within a multitenant architecture. You will learn strategies for effective fleet management and engage in hands-on practices to administer and monitor a CDB fleet successfully.

What's included

4 videos

In this module, we will dive into the PDB Snapshot Carousel feature, which allows you to manage and maintain snapshots of Pluggable Databases (PDBs) over time. You’ll learn how to set up and configure a snapshot carousel, manage snapshots effectively, and practice restoring PDBs from these snapshots through a series of practical exercises.

What's included

7 videos1 assignment

In this module, we will explore the process of switching over a refreshable clone Pluggable Database (PDB) within Oracle Multitenant. You will learn the scenarios where this feature is beneficial, and through practical exercises, you’ll gain the skills to perform a switchover, ensuring continuous availability and data integrity.

What's included

2 videos

In this module, we will cover the process of cloning and relocating Pluggable Databases (PDBs) using the Database Configuration Assistant (DBCA). You will learn how to effectively use DBCA for these tasks, and through practical exercises, you’ll gain the skills to clone and relocate PDBs in different environments, ensuring smooth database operations.

What's included

6 videos2 assignments

Instructor

Packt - Course Instructors
Packt
375 Courses25,977 learners

Offered by

Packt

Recommended if you're interested in Data Management

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

New to Data Management? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions