*Friday CLOSED

Timings 10.00 am - 08.00 pm

Call : 021-3455-6664, 0312-216-9325 DHA 021-35344-600, 03333808376, ISB 03333808376

Oracle Database 19c Managing Multitenant Architecture


Be the first to rate Oracle DBA 19c
Or log in to access your purchased courses
by fatima
Price:  120,000
2 Months
0 Lessons

 

Oracle Database Managing Multitenant Architecture

Oracle Database 19c Managing Multitenant Architecture

The multitenant architecture enables you to have many pluggable databases inside a single Oracle Database instance. Through a blend of hands-on labs and interactive lectures, you will explore the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs).

This course will help you to learn why and how to create and manage a multitenant container database and its regular and application pluggable databases, with storage structures appropriate for business applications.


Learning Objectives:

After completing this Oracle Certification Course, you will be able to:

  • Core concepts of regular PDBs
  • Creating a CDB, and then using different methods to create PDBs.
  • How to start and shut down a CDB and how to open and close a PDB.
  • Security aspects in CDBs and PDBs in various areas like privileges and roles, lockdown profiles, auditing, Database Vault, and encryption.
  • Availability through the backup, duplicate, recovery, and flashback topics and then performance, monitoring, and resource allocation management in CDBs and PDBs.
  • How you can move data from a non-CDB environment to a PDB.
  • How to move data between PDBs by using utilities such as the export and import features of Oracle Data Pump, SQL*Loader, external tables, and Oracle Recovery Manager.

Course Content: 

Module 1: Introduction to Oracle Database

  • Overview of the Oracle Database
  • Overview of the Oracle Cloud
  • Relational Database Concepts
  • Database Administration Tasks

Module 2: Oracle Database Architecture

  • Overview of the Oracle Database Architecture
  • The Oracle Database Instance
  • Oracle Database Memory Structures
  • Process Architecture and Structures
  • Server and Client Processes
  • Oracle Database Storage Architecture
  • Connect to the Oracle Database Instance

Module 3;Multitenant Architecture

  • CDB Basics
  • CDB and Regular PDBs
  • Application PDBs and Application Installation

Module 4: PDB Creation

  • PDB Creation
  • CDB and PDB Management
  • Storage

 Module 5: Security

  • Security
  • Backup and Duplicate
  • Recovery and Flashback
  • Performance
  • Resources Allocation

Module 6: Data Movement

  • Data Movement
  • Upgrade Methods
  • Miscellaneous

Course Prerequisites
  • Working knowledge of tools like SQL*Plus or Enterprise Manager Cloud Control
  • Knowledge of non-CDB configuration and management
  • Working knowledge of SQL and use of PL/SQL packages
  • Oracle Database 19c: Administration Workshop
  • Oracle Database 19c: Backup and Recovery
  • Basic knowledge of Linux operating system

KEY FEATURES

Flexible Classes Schedule

Online Classes for out of city / country students

Unlimited Learning - FREE Workshops

FREE Practice Exam

Internships Available

Free Course Recordings Videos

Register Now


Print Friendly, PDF & Email

Lessons

Or log in to access your purchased courses
ABOUT US

OMNI ACADEMY & CONSULTING is one of the most prestigious Training & Consulting firm, founded in 2010, under MHSG Consulting Group aim to help our customers in transforming their people and business - be more engage with customers through digital transformation. Helping People to Get Valuable Skills and Get Jobs.

Read More

Contact Us

Get your self enrolled for unlimited learning 1000+ Courses, Corporate Group Training, Instructor led Class-Room and ONLINE learning options. Join Now!
  • Head Office: A-2/3 Westland Trade Centre, Shahra-e-Faisal PECHS Karachi 75350 Pakistan Call 0213-455-6664 WhatsApp 0334-318-2845, 0336-7222-191, +92 312 2169325
  • Gulshan Branch: A-242, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, Karachi-75300, Call/WhatsApp 0213-498-6664, 0331-3929-217, 0334-1757-521, 0312-2169325
  • ONLINE INQUIRY: Call/WhatsApp +92 312 2169325, 0334-318-2845, Lahore 0333-3808376, Islamabad 0331-3929217, Saudi Arabia 050 2283468
  • DHA Branch: 14-C, Saher Commercial Area, Phase VII, Defence Housing Authority, Karachi-75500 Pakistan. 0213-5344600, 0337-7222-191, 0333-3808-376
  • info@omni-academy.com
  • FREE Support | WhatsApp/Chat/Call : +92 312 2169325
WORKING HOURS

  • Monday10.00am - 7.00pm
  • Tuesday10.00am - 7.00pm
  • Wednesday10.00am - 7.00pm
  • Thursday10.00am - 7.00pm
  • FridayClosed
  • Saturday10.00am - 7.00pm
  • Sunday10.00am - 7.00pm
Select your currency
PKR Pakistani rupee
WhatsApp Us