Oracle Database (12c) Administration
Hundreds of Companies are looking for Oracle DBAs, Are you Ready?
Consolidation is an important business strategy to reduce the costs of infrastructure and operational expenses. In many production database servers, a big portion of CPU cycles go unused. By consolidating many databases into fewer database servers, both the hardware and operational staff can be more effectively utilized.
Oracle’s new pluggable database feature introduced in database 12c reduces the risk of consolidation because the DBA can easily plug or unplug an existing database to or from a container database. There is no need to change any code in the application.
Among all the IT/computer best jobs in a recent CNN.com Best Jobs in America report, Database Administrator job has the highest job growth forecast (30% increase) for the next 10 years until 2023. www.cnn.com also published an article recently that Database Administrators stand # 98 out of 100 BEST AMERICA JOBS
They need you…..
Have A Question? Interested? Contact Us!
COURSE BREAKDOWN
Module 1 : Architecture
Lesson 1 – Overview of Oracle Database 12c
Lesson 2 – Oracle Database Architecture: Overview
Lesson 3 – Oracle Database Instance Configurations
Lesson 4 – Connecting to the Oracle Database Instance
Lesson 5 – Oracle Database Memory Structures and Process Architecture
Lesson 6 – Database Storage Architecture
Lesson 7 – Pluggable databases and container databases
Lesson 8 – Difference between 11g and 12c
Module 3 : Multitenant database administration I
Lesson 1 -Create a PDB from the seed PDB
Lesson 2 – Connect to a CDB and to a PDB
Lesson 3 – Manage CDBs and PDBs
Lesson 4 – Start up and shutdown a CDB
Lesson 5 – Open and Close PDBs
Lesson 6 – Pluggable Database Storage Management
Lesson 7 – Pluggable Database Memory Management
Lesson 8 – Understanding 12c dictionary views
Lesson 9 – Security concepts in Pluggable Databases
Lesson 10 – Oracle Database 12.1.0.2 New Features
Module 5 : Backup & Recovery in Multitenant Databases
Lesson 1 – Backups
Lesson 2 – Recovery
Lesson 3 – Recovery Basics revisited
Lesson 4 – Handling redo log failures
Lesson 5 – Recovery use cases
Lesson 6 – Point In Time Recovery
Module 2 : Software Installation & Database Creation
Lesson 1 – Planning
Lesson 2 – Hardware and OS pre-requisites
Lesson 3 – Database creation: CLI & DBCA
Lesson 4 – Understanding Oracle Services
Module 4 : Multitenant database administration II
Lesson 1 – Convert a Non-CDB to a PDB
Lesson 2 – Unplugging and Plugging Multitenant Databases
Lesson 3 – Remote cloning of Non-CDB
Lesson 4 – Cloning Pluggable Databases
Lesson 5 – PDB Snapshot Clone
Lesson 6 – Cloning Alternatives
Module 6: Database Upgrade
Lesson 1 – Upgrade Methodology
Lesson 2 – Routine Patching: OPatch
Lesson 3 – Ensuring Plan Stability Post Upgrade
Lesson 4 – Testing the Upgrade
Lesson 5 – Introduction to EM Express to manage 12c Databases
Frequently Asked Questions
Real Application Clusters (RAC) FAQ
A non-RAC database is only available on a single system. If that system fails, the database service will be down (single point of failure).
See FAQs here …………..
Data Guard FAQ
See FAQs here …………..
Oracle GoldenGate FAQ
See FAQs here …………..
Oracle Apps DBA EBS (E-Business Suite) RDBMS Interview Questions/FAQs & Answers
See FAQs here …………..
Oracle database Security FAQ
Data is any company’s greatest asset and the only “safe” database is one that has nothing in it. A lot of people think that hackers are all outside the firewall which is false. The greatest threat to your database is the person in the cube next to you who has access to it. For this reason, databases should be secured to ensure its data is properly protected.
See FAQs here …………..
Goldengate Interview Questions & Answers - FAQ
See FAQs here …………..
