Oracle 12c DBA

The Oracle Database 12c Learning path is designed to provide an effective curriculum plan for database administrators, system administrators and developers who are either new to their role or want to gain additional skills. By enrolling in these courses and following this educational path, you’ll develop an understanding of new Oracle Database 12c features, while building the skills needed to install, configure and maintain the database. Once you learn the essentials of administering a database, you can develop advanced knowledge in any of the focus areas.

Whether you attend recommended courses for a focus area, select advanced DBA topics from multiple focus areas or plan to pursue an Oracle Database 12c Certification, Oracle University curriculum for Oracle Database 12c is created to meet today’s DBA challenges. Review our recommended courses and select the courses that are right for you.

Oracle 12c Database: SQL workshop I

  • Introduction
  • Retrieving data using SQL SELECT statement
  • Restricting and Sorting data
  • Using Single-row Functions to customize output
  • Using conversion functions and conditional expressions
  • Reporting aggregated Data using the Group Functions
  • Displaying data from multiple tables using joins
  • Using subqueries to Solve Queries
  • Using the Set Operators
  • Managing Tables Using DML statements
  • Introduction to Data Definition Language

Oracle Database 12c: Admin, Install and Upgrade Accelerated

  • Introduction
  • Exploring the Oracle database Architecture
  • Oracle Software Installation Basics
  • Installing Oracle Database Software
  • Creating an Oracle database by using DBCA
  • Oracle Database Management Tools
  • Managing the Database Instance
  • Configuring the Oracle Network Environment
  • Administering User Security
  • Managing Database Storage Structures
  • Managing space
  • Managing Undo data
  • Managing data Concurrency
  • Implementing Oracle database Auditing
  • Backup and Recovery: Concepts
  • Backup and Recovery Configuration
  • Performing database Backups
  • Performing database Recovery
  • Moving data
  • Performing Database Maintenance

Oracle Database 12c: Backup and Recovery Workshop

  • Introduction
  • Getting started
  • Configuring for Recoverability
  • Using the RMAN recovery catalog
  • Backup strategies and Terminologies
  • Performing backups
  • Improving your backups
  • Using RMAN-Encrypted backups
  • Diagnosing failure
  • Restore and Recovery concepts
  • Perform Recovery I
  • Perform Recovery II
  • RMAN and Oracle Secure Backup
  • Using Flashback Technologies
  • Flashback Database
  • Transporting data
  • Performing Point-In-Time Recovery
  • Duplicating a database
  • RMAN troubleshooting and Tuning
  • Workshop Overview

Oracle 12c Database: Managing Multitenant Architecture

  • Introduction
  • Basics of Multitenant Container Database and Pluggable database
  • Creating a Multitenant Container database and Pluggable Databases.
  • Managing a Multitenant Container database and Pluggable Databases.
  • Managing Table spaces in CDB and PDBs
  • Managing Security
  • Backup, Recovery, Flashback CDB and PDBs.
  • Performance
  • Miscellaneous

OCA

Oracle 12c Database: SQL workshop I

Exam Number: 1Z0 - 061

Oracle Database 12c: Installation and Administration

Exam Number: 1Z0 - 062

OCP

Oracle Advanced Administration

Exam Number: 1Z0 – 063

Coming Soon.

We are looking forward to hear from you


Name:
Phone:
Email:
Experience:
Current Location:
Preferred Location:
Course Interested in:
Comments:

Enter this code here

You can also reach us directly:


Chennai
Ms. Praveena
Phone: +91 98942 66663
Email: praveena.m@mazenetsolution.com


Services