Skip to content

Oracle Multitenant DBA

Self-paced videos, Lifetime access, Study material, Certification prep, Technical support, Course Completion Certificate


Uplatz

Summary

Price
£14 inc VAT
Study method
Online, On Demand What's this?
Duration
7.4 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Certificate of completion - Free
  • Reed courses certificate of completion - Free

1 student purchased this course

Add to basket or enquire

Overview

Uplatz offers this comprehensive course on Oracle Multitenant DBA. It is a self-paced course with video lectures. You will be awarded Course Completion Certificate at the end of the course.

Oracle Multitenant is a new option for Oracle database, It consists of database and at least one instance. A CDB includes zero, one, or many customer-created pluggable databases (PDBs). All Oracle databases before Oracle Database 12c were non-CDBs. Oracle Multitenant enables an Oracle Database to function as a container database (CDB).

Oracle Multitenant DBA course by Uplatz will take you all the away from creating an Oracle multitenant capabilities. This is a good opportunity for the students, not only the course will demonstrate the concepts for you, you will also gain practical experience on implementing them.

This Oracle Multitenant DBA course will help you to:

  • Understand and use best practices in order to move to the Multitenant architecture
  • Practice new DBA tasks on a CDB (creation, clones, plug-in, backup, monitoring)
  • Discover the new functionalities brought by the PDB (pluggable database)

Certificates

Certificate of completion

Digital certificate - Included

Course Completion Certificate by Uplatz

Reed courses certificate of completion

Digital certificate - Included

Will be downloadable when all lectures have been completed

Curriculum

1
section
16
lectures
7h 24m
total
    • 1: Overview of Oracle Multitenant Architecture 21:36
    • 2: Installing Oracle Linux 7.8 in Oracle Virtual Box 21:59
    • 3: Installing Oracle Database 19c Software 20:38
    • 4: Creating CDB and non-CDB databases 23:30
    • 5: Creating PDBs from the Seed 26:11
    • 6: Performing Basic CDB Administration Tasks 35:16
    • 7: Creating a PDB by Cloning from Local and Remote PDBs 16:57
    • 8: Creating PDB by Plugging in an Unplugged PDB 21:11
    • 9: Creating a PDB from non-CDB 40:18
    • 10: Creating a PDB by Relocating a PDB 24:18
    • 11: Managing Common and Local Users 40:06
    • 12: Backup and Recovery in CDB and PDBs 32:00
    • 13: Flashback and Point-in-time Recovery 38:17
    • 14: Using Resource Manager with CDB and PDBs 25:24
    • 15: Using Data Pump Utility with PDBs 17:03
    • 16: Managing Applications and Application Containers 38:49

Course media

Description

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

Oracle database, since its inception, has always used a very specific and unique architecture which served it very well. In earlier forms of this architecture, all components of the database were meant to work in a one-to-one mapping with each other. But from version 12c onwards, a completely new architecture has been introduced – Oracle Multitenant.

In Oracle Database, there are two macro categories of components – one at the hard disk level and another at RAM level. A hard drive contains nothing except stored files, and this is also the case for Oracle Database. There are various types of files that make an Oracle database function, for example data files, control files, online redo logs etc. Besides these files, a memory component exists on the operating system RAM which is a combination of several memory structures and various background processes. This memory portion works as a bridge between the user and the physical files that exist over the disk and is known as an instance.

A CDB consolidates multiple pluggable databases (PDB), a portable collection of schemas, schema objects, and non-schema objects. Oracle multitenant databases were developed to help companies take advantage of all these technologies and cost savings. Create a pluggable database by using different methods:

  • Creating a PDB from the seed
  • Cloning PDBs from local or remote PDBs including the refreshable PDBs
  • Plugging in an Unplugged PDB
  • Relocating a PDB
  • Creating a PDB from a non-CDB database
  • Creating Proxy PDBs

Who is this course for?

Everyone

Requirements

Passion and determination to achieve your goals!

Career path

  • Oracle DBA
  • Oracle Multitenant Database Administrator
  • Principal Consultant Migration Specialist Oracle DBA
  • IT Programmer Manager
  • Associate (OCA) – Oracle Certified Associate
  • Professional (OCP) – Oracle Certified Professional
  • Master (OCM) – Oracle Certified Master
  • Specialist (OCE) –Oracle Certified Expert
  • Expert (OCS) – Oracle Certified Specialist
  • Oracle Database Administration Application Developer

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2024. All rights reserved.