This course offers a deep dive into the Oracle Database Multitenant architecture, providing you with the necessary tools and knowledge to manage both Container Databases (CDBs) and Pluggable Databases (PDBs). You’ll begin by understanding the fundamentals of Oracle Multitenant, exploring the business challenges it addresses, and the architecture's structural components. As you progress, the course will guide you through the creation and management of CDBs and PDBs, emphasizing hands-on practice sessions that reinforce your learning.
The Oracle Database Multitenant Administration Course
Instructeur : Packt - Course Instructors
Inclus avec
Expérience recommandée
Ce que vous apprendrez
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.
Compétences que vous acquerrez
- Catégorie : Oracle Databases
- Catégorie : Database Administration
- Catégorie : PDB
- Catégorie : database administration
- Catégorie : Multitenancy
- Catégorie : Multitenant
- Catégorie : CDB
Détails à connaître
Ajouter à votre profil LinkedIn
octobre 2024
7 devoirs
Découvrez comment les employés des entreprises prestigieuses maîtrisent des compétences recherchées
Obtenez un certificat professionnel
Ajoutez cette qualification à votre profil LinkedIn ou à votre CV
Partagez-le sur les réseaux sociaux et dans votre évaluation de performance
Il y a 16 modules dans ce cours
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.
Inclus
2 vidéos1 lecture
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.
Inclus
3 vidéos
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.
Inclus
8 vidéos1 devoir
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.
Inclus
4 vidéos
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.
Inclus
9 vidéos
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.
Inclus
1 vidéo1 devoir
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.
Inclus
5 vidéos
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.
Inclus
6 vidéos
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.
Inclus
3 vidéos1 devoir
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.
Inclus
3 vidéos
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.
Inclus
5 vidéos
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.
Inclus
4 vidéos1 devoir
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.
Inclus
4 vidéos
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.
Inclus
7 vidéos1 devoir
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.
Inclus
2 vidéos
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.
Inclus
6 vidéos2 devoirs
Instructeur
Offert par
Recommandé si vous êtes intéressé(e) par Data Management
Packt
Coursera Project Network
Illinois Tech
Pour quelles raisons les étudiants sur Coursera nous choisissent-ils pour leur carrière ?
Ouvrez de nouvelles portes avec Coursera Plus
Accès illimité à 10,000+ cours de niveau international, projets pratiques et programmes de certification prêts à l'emploi - tous inclus dans votre abonnement.
Faites progresser votre carrière avec un diplôme en ligne
Obtenez un diplôme auprès d’universités de renommée mondiale - 100 % en ligne
Rejoignez plus de 3 400 entreprises mondiales qui ont choisi Coursera pour les affaires
Améliorez les compétences de vos employés pour exceller dans l’économie numérique
Foire Aux Questions
Yes, you can preview the first video and view the syllabus before you enroll. You must purchase the course to access content not included in the preview.
If you decide to enroll in the course before the session start date, you will have access to all of the lecture videos and readings for the course. You’ll be able to submit assignments once the session starts.
Once you enroll and your session begins, you will have access to all videos and other resources, including reading items and the course discussion forum. You’ll be able to view and submit practice assessments, and complete required graded assignments to earn a grade and a Course Certificate.