TRAINING

Enroll Now

We are currently offering a world class oracle database administration training program for interested students and professionals. Get trained Oracle DBA 11g/12c core architectural & database administration concepts, Enterprise Manager tools, configuring CDB & PDBs, Auditing Enhancements & SQL Tunning, User Management, RMAN, DB backup & recovery, and In-Memory Caching, etc. You will also get an exposure to industry based real-time projects in various verticals. .

ORACLE 12c DBA Training

Basics of Multitenant Container Database (CDB)

• Benefits of the multitenant architecture
• Differences between the root container and pluggable database containers
• Structure of the root
• Structure of Pluggable Database (PDB)
• CDB_xxx and DBA_xxx views

Configuring and Creating CDB and PDBs

• Tools: DBCA and SQL*Plus
• Configuration and creation of CDB
• Exploring the Structure (CDB_xxx views and EM)
• Tools used: SQL Developer, DBCA and SQL*Plus and EM Database Express
• Create a new PDB from PDB$SEED
• Create a PDB from a non-CDB
• Clone a PDB into the same CDB or into another CDB using DB links
• Plug in an unplugged PDB

Managing CDB and PDBs

• Connect to CDB as administrator
• Connect to a PDB using a service name
• Start up a CDB
• Open / Close a PDB (SQL*Plus, srvctl, EM)
• Open / Close all PDBs
• Shut down a CDB
• Preserve or discard the PDBs open mode when the CDB restarts
• Change PDB state

Managing Tablespaces, Common and Local Users, Privileges & Roles

• Create permanent tablespaces in the root and PDBs
• Manage common and local schemas and users in the root and PDBs
• Manage system and object privileges to common and local grantees granted "commonly" or "locally"
• Manage common and local roles granted "commonly" or "locally

TManaging Backup / Recovery / Flashback

• Backup a whole CDB
• Backup a PDB
• Recover CDB from redo log files, control files, undo datafiles loss
• Recover PDB from PDB datafiles loss
• Flashback at CDB level
• Explain the two methods of migration

Online Datafile Move and Moving Data (DATAPUMP)

• Full Transportable Export/Import Overview
• Plugging a Non-CDB into CDB Using Data Pump
• Transporting a Database over the Network Example
• Disabling Logging for Oracle Data Pump Import Overview
• Exporting Views as Tables Overview
• Specifying the Encryption Password
• Compressing Tables during Import

Auditing Enhancements

• Overview of the Unified Audit Trail
• Enabling the Unified Audit Trail
• Creating a separate tablespace for the unified audit trail
• Granting the AUDIT_ADMIN role to a user for audit trail configuration and management
• Configuring the Unified Audit Trail to set a tolerance level for loss of audit records
• Creating audit policies

Privileges Enhancements

• Implementing Separation of Duty for Database Administration Tasks
• Using Database Privilege Analysis
• Overview of Database Privilege Analysis
• Granting the CAPTURE_ADMIN role to enable management of privilege captures
• Creating and starting/stopping privilege captures
• Viewing privilege profile data
• Querying DBA_PRIV_CAPTURES
• Explaining the purpose of the default ORA$DEPENDENCY profile
• Common and local users, roles and privileges
• New Administrative Privileges
• New Administrative Privilege SYSBACKUP
• New Administrative Privilege SYSDG
• New Administrative Privilege SYSKM
• OS Authentication and OS Groups
• Password Authentication for SYSBACKUP
• Password Authentication for SYSDG
• New System Privilege PURGE DBA_RECYCLEBIN

General RMAN New Features and FDA Enhancements

• Making Database Connections With RMAN
• Using the SYSBACKUP Privilege
• Using SQL, DESCRIBE Command, Duplication Operation with the NOOPEN option
• Backing up and Restoring Very Large Files
• Creating Multisection Backups
• Transporting Data Across Platforms
• Transporting Data: Processing steps

In-Memory Column Store

• In-Memory Database option goals and benefits
• Row format and columnar format
• New SGA component:
• IMCU synchronization
• Deployment and behaviors
• Compression ratio
• New dictionary tables and added columns

In-Memory Caching

• Setting up Full Database In-Memory Caching
• Using Full Database In-Memory Caching
• Explaining the two buffer replacement algorithms of Automatic Big Table Caching
• Configuring Automatic Big Table Caching.
• Using Automatic Big Table Caching

Resource Manager and Other Performance Enhancements

• Manage resources between PDBs
• Manage resources within a PDB
• Manage resources with CDB and PDBs plans
• Manage runaway queries
• Control the in-memory database repopulation resource consumption
• New Architecture: Multiprocess / MultiThread

Oracle Certified Professional (OCA,OCP) Certification

Students can use this training to prepare for majority of the topics required to pass the Oracle Database 12c Administration 1Z0-062 examination towards Oracle OCA certification (Oracle Certified Associate). The same training course can be used for preparation towards the Oracle Database 11g: Administration I 1Z0-052 examination as well. Additionally, students can also use this training to prepare for some topics required to pass the Oracle Database 12c: Advanced Administration 1Z0-063 exam that is required for acquiring the Oracle Certified Professional (OCP) designation.