Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle Database 12c : Manage The Multitenant Architecture
Oracle Training Overview

The single most important new capability introduced with the Oracle 12c release of the database is the multitenant database feature. With this technology, the Oracle database can be a full participant in a cloud computing-based application architecture. Even a traditional on-premise systems architecture can be dynamically and dramatically transformed as a result of this feature. Many traditional and new database features are enhanced or introduced when a multitenant database configuration is used.

Oracle Training Audience

The target audience for this course are:
  • Database administrators
  • Application designers and developers
  • Web server administrators
  • System administrators
  • Implementation specialists
  • Data center support engineers
  • Chief Information Officers (CIO) and other information technology (IT) management professionals
Oracle Training Prerequisites

The entire Oracle database administrator curriculum, including this textbook that you are now reading, has these prerequisites from our Series For Oracle Database Developers. Senior developers reading this text will also need these prerequisites, or equivalent experience.
  • Oracle Database 12c: SQL Fundamentals (Levels I & II)
  • Oracle Database 12c: PL/SQL Fundamentals (Levels I & II)
With regard to this text and its position within Series For Oracle Administrators these are the required prerequisites, or equivalent experience:
  • Oracle Database 12c: Install & Upgrade Workshop
  • Oracle Database 12c: Administration Workshop
  • Oracle Database 12c: Backup & Recovery Workshop
  • Oracle Database 12c: Architecture & Internals
  • Oracle Database 12c: Resource Manager & Scheduler
Oracle Training Certification

This course considers subjects helpful for certification as an Oracle Database 12c Administrator Certified Professional (OCP) for "Exam: 1Z0-060: Upgrade to Oracle Database 12c" and for "Exam: 1Z0- 063: Oracle Database 12c: Advanced Administration".

Oracle Training Objectives

The objectives for this course are as follows:
  • Understanding the multitenant database architecture.
  • Review the business challenges, needs and objectives that are addressed with multitenant database technology.
  • Creating and connecting to Oracle container databases (cDBs) and pluggable databases (pDBs).
  • Managing common and local users along with multiple container management of security objects.
  • Creating container databases, provisioning pluggable databases, perform unplug and plug-in and administering multiple database tenants.
  • Migrating traditional single tenant databases to pluggable databases.
  • Managing temporary and permanent storage within container and pluggable databases.
  • Multitenant backup and recovery strategies, including complete and incomplete recovery at either the container or the pluggable database level, Flashback Database and other sophisticated recovery operations.
  • Using SQL, RMAN, DBCA and Enterprise Manager Cloud Control for the administration of multiple database tenants.
  • Resource management and container caging.
Course duration

2-3 Days

Oracle Training Course outline

Fundamentals: The Multitenant Database Architecture
  • Cloud Computing Principles
  • Peering Into The Architecture
  • Multitenant Database Instance
  • Multitenant Storage Architecture
  • Multitenant Data Dictionary
  • Benefits Of The Architecture
  • Challenges Of The Architecture
Fundamentals: Creating & Connecting To Multitenant Databases
  • About cDB Capacity Planning
  • cDB & pDB Creation
  • Using Oracle Installer
  • Using DBCA
  • cDB & pDB Connections
  • Using SQL*Plus
  • EM Cloud Control
Fundamentals: Multitenant Database Security Management
  • Multitenant Security Model
  • Multitenant Privileges & Roles
  • Common Users
  • Local Users
  • Common & Local Roles & Privileges
  • Commonly & Locally Defined
  • Commonly & Locally Granted
  • Common & Local Profiles
  • Common & Local Dictionary Access
  • Multitenant Unified Auditing
  • Local Audit Policies
  • Querying The Unified Audit Trail
  • Common Audit Policies
  • Auditing Management With EM CC
Provisioning: Provisioning pDBs From pdb$seed
  • Provision & Decommission pDBs
  • EM CC Provisioning Prerequisites
  • pDB File Location Prerequisites
  • Provision A pDB From pdb$seed
  • Provision Using SQL
  • Provision Using EM CC
  • Post Provisioning Checklist
  • Drop A pDB
  • Querying cDB & pDB Metadata
Provisioning: Additional pDB Provisioning
  • Clone A pDB
  • Unplug & Plug-In A pDB
  • Migrate A Non-cDB To A pDB
  • pDB Provisioning Using EM CC
  • pDB Provisioning Using DBCA
Administration: Administering Multitenant Databases
  • About Multitenant Administration
  • cDB Administration
  • cdb$root Administration
  • pDB Administration
Administration: Multitenant Storage Management
  • Manage Permanent Tablespaces
  • Manage Temporary Tablespaces
Administration: Multitenant Backup & Recovery
  • Devising Multitenant Recovery Plan
  • RMAN Multitenant Usage
  • RMAN Multitenant Backup
  • EM CC Multitenant Backup
  • RMAN Multitenant Recovery
  • Complete Recovery
  • Incomplete cDB / pDB Point-in-time Recovery (PITR)
  • Incomplete Table Point-in-time Recovery (PITR)
  • Multitenant Flashback Database
  • EM CC Multitenant Recovery
  • Multitenant Database Duplication
  • cDB Duplication
  • pDB Duplication
Administration: Multitenant Resource Management
  • About Resource Management
  • cDB Resource Plans & Directives
  • pDB Resource Plans & Directives

 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy