About the course

The Oracle Database 12c is the first high-performance, an enterprise-class database for the cloud. Oracle Database 12c has added 500 new features to the database under pluggable databases and multitenant architecture.

You will learn

  • Oracle 12c architecture, installation & configuration
  • Administrating multi-tenancy (CDB & PDB)
  • Converting and closing multitenant databases
  • Managing users
  • Upgrade, backup & recovery of multitenant databases
  • Managing tablespace
  • Migration to CDB & PDB
  • Troubleshooting & administration

Audience and Requirements

  • Anyone who is interested to be Oracle database administrator on cloud
  • Requires database and database design concept, and SQL

Training Highlights

  • Mentorship will be available through training and after training
  • You will practice on interview questions starting from day one

Curriculum


Module 1: Oracle Database 12c Architecture

  • 1.1  Overview of Oracle 12c and Architecture
  • 1.2   Instance Configurations
  • 1.3   Connecting to the Oracle Database Instance
  • 1.4   Memory Structures and Process Architecture
  • 1.5   Storage Architecture
  • 1.6   Pluggable Databases and Container Databases
  • 1.7   Oracle Database 11g vs 12c

Module 2: Software Installation & Database Creation

  • 2.1  Planning for Installation
  • 2.2   Hardware and OS Prerequisites
  • 2.3   Database Creation
  • 2.4   Oracle Services Overview

Module 3: Multitenant Database Administration

  • 3.1  About and Purpose of Multitenant
  • 3.2   Creating a Pluggable Database(PDB) from the seed PDB
  • 3.3   Connect to a Container Database(CDB) and to a PDB
  • 3.4   Managing CDBs and PDBs
  • 3.5   Startup/shutdown a CDB and Open/Close PDBs
  • 3.6   Pluggable Database Storage Management
  • 3.7   Pluggable Database Memory Management
  • 3.8   Work on 12c Dictionary Views
  • 3.9   Securities on Pluggable Databases
  • 3.10   Guidelines for Managing Tablespaces

Module 4: Creating Tablespaces

  • 4.1  Creating Tablespaces
  • 4.2   Specifying Nonstandard Block Sizes for Tablespaces
  • 4.3   Controlling the Writing of Redo Records
  • 4.4   Altering Tablespace Availability
  • 4.5   Using Read-Only Tablespaces
  • 4.6   Renaming Tablespaces
  • 4.7   Dropping Tablespaces
  • 4.8   Managing the SYSAUX Tablespace
  • 4.9   Diagnosing and Repairing Locally Managed Tablespace Problems
  • 4.10   Migrating the SYSTEM Tablespace to a Locally Managed Tablespace
  • 4.11   Transporting Tablespaces Between Databases
  • 4.12   Viewing Tablespace Information

Module 5: Converting and Cloning Multitenant Database

  • 5.1  Convert a Non-CDB to a PDB
  • 5.2   Unplugging and Plugging Multitenant Databases
  • 5.3   Remote cloning of Non-CDB
  • 5.4   Cloning Pluggable Databases
  • 5.5   PDB Snapshot Clone
  • 5.6   Cloning Alternatives

Module 6: Backup & Recovery in Multitenant Databases

  • 6.1  Backup and Recovery Concept
  • 6.2   Recovery Manager (REMAN) for Backuping
  • 6.3   Handling Redo Log Failures
  • 6.4   Recovery Use Cases
  • 6.5   Point In Time Recovery

Module 7: Database Upgrade

  • 7.1  Upgrade Methodology
  • 7.2   Routine Patching: OPatch
  • 7.3   Ensuring Plan Stability Post Upgrade
  • 7.4   Testing the Upgrade
  • 7.5   Introduction to EM Express to Manage 12c Databases

Module 8: Tuning Performance

  • 8.1  Indexing Concept to Boost Select Performance
  • 8.2   Understanding SQL Server Database Statistics and Profiler
  • 8.3   Using Views to Improve Performance
Request a detailed syllabus.

Get Answers (Answering their questions)

What kind of learning does ITlearn360.com provide?

ITlearn360.com offers instructor-led online live sessions and classroom-based corporate trainings and bootcamps for various courses and certifications to the learners.

Who are the instructors @ITlearn360.com?

@ITlearn360.com, we have an instructor community of industry professionals who are working in leading organizations and are veterans in their respective fields. These experts belong to various industries and are willing to share their talent with learners like you.

Are classes @ITlearn360.com conducted through online video streaming?

Yes, the classes @ITlearn360.com are conducted through online video streaming where there is two-way communication between users and instructors. The users can speak by using a microphone, chat by sending a message through a chat window and share their screens with an instructor. For better understanding, users also get recorded video of the class.

Sign for next demo class