Certified Ghana offers a course on Oracle 12c DBA OCA leading to the international certification. The Oracle 12c DBA training equips the students with a deep understanding of the most important responsibilities a DBA has: performing backup and recovery. Below is the course outline:

Introduction to Oracle Database 12c Administration

Your responsibilities as an Oracle 12c DBA

• Configuring the instance and database

• Balancing user requirements and resources

• Ensuring database availability

The Oracle 12c architecture

• Processing transactions with the server

• Identifying types of processes and memory structures

• Determining database file structure

• Sizing the Result Cache for optimizing repeated queries

Building an Oracle 12c Database Creating the database

• Simplifying memory allocation with memory targets

• Establishing network connectivity

• Converting from text-based to server parameter files

• Configuring control files and redo log files Starting and stopping the database

• Mounting and opening the database with SQL*Plus

• Authenticating connections having SYSDBA privilege

• Closing the database and shutting down the instance

Automating Database Management The Oracle Enterprise Manager architecture

• Navigating the graphical interface

• Comparing command-line and graphical techniques Administering with Database Control

• Equipping Database Control to manage additional databases

• Setting thresholds and generating alerts

• Verifying changes in the data dictionary

• Performing privilege management Performing Flashback Operations Managing space for rollback and read

consistency

• Configuring UNDO tablespaces

• Monitoring expansion of rollback segments

• Swapping to an alternative UNDO tablespace

Resetting data to recent points in time with Flashback

• Tracking changes to data values with row history

• Obtaining transaction history with Flashback Transaction

• Performing recovery of data with Flashback Table

• Retrieving dropped tables and dependent objects from the recycle bin Securing the Database Establishing user accounts

• Authenticating users with password checking

• Allocating space quotas for user schemas

• Limiting resource usage through profiles Enforcing security

• Granting and revoking system and object privileges

• Simplifying privilege management with roles

• Preventing changes to read-only tables

Controlling Database Storage Defining logical and physical structures

• Creating, altering and dropping tablespaces

• Handling sort data with temporary tablespaces

Configuring storage patterns for database objects

• Structuring data and index segments

• Eliminating rowmigration with PCTFREE and Data Pump

• Compressing table data to conserve storage

• Shrinking tables and indexes online to regain space

Partitioning for Administration and Availability

Creating table partitions and subpartitions



• Selecting partitioning methods: range, list, hash, interval

• Referencing the partitioning method in child tables

• Administering partitions with merge, split, add and drop Maintaining index partitions

• Maximizing performance with local and global indexes

You Will Learn How To

• Create, maintain and support Oracle 12c databases and instances

• Automate database administration tasks with Oracle Enterprise Manager 12c Database Control

• Provide transaction support and flashback capability

• Control access and database security through privileges and roles

• Partition large tables and indexes to improve performance

Who Should Attend

Database administrators, developers with data management responsibilities and others involved in the

management or deployment of Oracle 12c databases who have experience with Oracle 12c, “Oracle

Database 12c Introduction.”

Hands-On Experience

Includes:

• Building an Oracle 12c database

• Implementing the graphical DBA tools

• Maintaining UNDO tablespaces and retention periods in order to enable and perform flashback operations

• Securing data by controlling user access with privileges

• Monitoring and optimizing space usage