This Oracle 12C Database Administration course is designed by Oracle Corporation (Oracle Education Wing) to prepare a trainees who has completed 11G OCA certification for handing complex database operations including SQL Queries, Administration, Backup-Recovery and Performance Tuning. If some one has aquired 11G OCA credit , then this course prepares him/her for upgrade exam 1Z0-067 that helps to get OCP 12C credit.
03 Exams 1Z0-051, 1Z0-052 and 1Z0-067 will help trainees to get OCP 12C certificate.
After Oracle 12c DBA course, The Database Professionals can move towards 12c RAC, 12C ASM, 12C Data Guard, and Golden Gate technologies also.
Benefit of learning Oracle 12C DBA Upgrade International Certification Course From Selecom Technology
Training through the At-Time-Practical
Training based on Real Time Industry requirements fulfillment
Practical on Real Time Administration Problems
Experienced Trainers From Well-Know IT-Companies
Extra Seminars for Related Advanced Technologies in Database even after completion of course
100% result in International Exams
Exam preparation for Certification (OCA, OCP)
Audio/Video Recording Of the sessions.
Facility of sending Class-room codes over the E-Mail.
Course Content
Multitenant Environment
Multitenant Container and Pluggable Database Architecture
Describe multitenant architecture
Explain pluggable database concepts
Installing Multitenant Container Databases software on GUI OS
Create and configure a CDB
Create a PDB while Installing Software
Logging on CDB s
Logging on PDBs
Managing CDBs and PDBs
Establish connections to a CDB/PDB
Start up and shut down a CDB
Open and Close a PDB
Managing Storage in a CDB and PDBs
Getting Familiar with Files in CDBs
Getting Familiar with Files in PDBs
Managing Security in a CDB and PDBs
Manage common and local users
Manage common and local privileges
Manage common and local roles
Enable common users to access data in specific PDBs
Use other products with a CDB and PDBs like switching between CDB and PDB
Database Administration
Getting Started with Oracle Database 12c
Startup a Database in different Modes
Shutting down a database
Altering session to PDB
Checking all PDBs and their Status (Mount/Read Write)
Managing Your Database with Enterprise Manager
EM Database Express
Opening EM in Browser
Configuration EM Database Express with the DBCA
Navigating EM Database Express
Dashboard
Configuration page
Storage page
Security Page
Performance page
Creating and Managing Users in PDB and CDB
Monitoring and Managing Memory using Storage Management
Create and maintain tablespaces
Concepts of Data Blocks
Understanding Segments
Understanding Extents
Creating Database while creating a Tablespace
Making tablespace autoextend
Getting Familiar With SQL Queries
Selecom Statements
Putting conditions
Order by with ASC and DESC
Using functions in select queries
Joins (getting data from multiple tables together)
Using subqueries to get TOP-N analysis
Creating a table with different Data Types
Inserting data and making it updated
Difference between char, varchar and varchar2
Managing Database Performance
Shrink Space Table wise
Shrink space with cascade
Using Resumable Session with default timeline (7200 sec)
Using Resumable Session with user defined timeline
Compiling an Schema
Backup and Recovery
Understanding threats to your Database
Instance failure
Losing files
Dropped object
Media failure
Corruption (Due to Virus or Human Error)
User error
Finding files with recovery Manager
Starting RMAN
Configuring RMAN
Connecting to target database
Backup CDB with RMAN
Shutting Down the CDB
Starting Database in Mount mode
Running command to take cold backup
Viewing Backup Information
Moving to the Fast Recovery Area
Checking if Backup files are there
Backup PDB
Difference the CBD and PDB backup
Shutting down the instance
Startup instance in Mount mode
Using command to backup the PDBs
Opening PDB with resetlogs
Flashing back
Concepts of the Datagrid
Concepts of Datagrid Location
Getting data using datagrid
Watching OLD Data of the Tables
Using As of Timestamp
Flashing your query back
Flashing your tables back
Using To Timestamp
Flashing your database
Oracle 12C Recyclebin
Concepts of Recyclebin
Show recyclebin
Getting Tables Back from recyclebin
Deleting a Table permanently
Purging a Table
Multitenant Architecture and pluggable Databases
Creating a CDB using DBCA
Creating a PDB while creating CDB using DBCA
Creating a new PDB using clone of existing PDB
Creating a PDB using SEED
Gathering Knowledge of Real Application Clusters
Exploring RAC Architecture
Hardware Consideration for RAC
Software Consideration for RAC
Concepts of RAC
Understanding Oracle Data Guard & ASM
Use Data Guard
Use of ASM
Significance of ASM and DATAGUARD in RAC environment
