Loader

TRAINING

Enroll Now oracle-dba-training

Online TrainingOnline Training

Corporate TrainingCorporate Training

Course On DemandClassroom

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.

United Global Soft Key Features

Expert Instructors

Practical Implementation

Real- time Case Studies

Certification Guidance

Resume Preparation

Placement Assistance

Copyright 2018 © www.unitedglobalsoft.com . All right reserved | Sitemap | Privacy Policy | Terms Of Services