Oracle Database 12c Administration — A 5 day course

contact usEnquire about this course

Synopsis

This Oracle Database 12c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle 12c database.

Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database, allocate resources with the Resource Manager and Schedule jobs.

Objectives

This Oracle Database 12c Administration course is designed to give database administrators the knowledge and skills needed to maintain successful and efficient day-to-day operations of an Oracle 12c database.

The Oracle Database 12c administrator will gain practical experience in administering and monitoring an Oracle 12c database.

The delegate will practise:

Suitable For

This Oracle Database 12c Administration course course is for anyone who needs to administer, monitor and support an Oracle 12c database.

Follow-On Course

Prerequisites

Delegates who wish to attend the Oracle Database 12c Administration course should have an understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. Knowledge of the usage of PL/SQL packages is highly recommended.

Examination

Together with the Oracle Database 12c Installation and Upgrade course, the Oracle Database 12c Administration course is suitable for delegates intending to sit the #1Z0-062 - Oracle Database 12c: Installation and Administration examination.

Before taking any exam, ensure you have the recommended experience. The Oracle website lists all exam requirements and these are updated regularly.

Exams are not included as part of the course, nor included in the course fee.

Publicly scheduled dates, locations, and prices

Select a date to enquire about availability of places. For dates after 30 January 2017, please call 0333 210 0140 or use our contact form to enquire about places and availability.

London — £1945 (+VAT)


Contents

Introduction to Oracle Database 12c

Oracle Database 12c Infrastructure

Administer a Database Instance

Configure the Oracle Network Environment

Storage Structures

Manage Users

Manage Profiles and Resources

Manage Privileges

Database Auditing

Data Concurrency and Lock Conflicts

Undo Management

Proactive Database Maintenance

Performance Management

SQL Tuning

Moving Data

Automate Tasks with the Scheduler

Managing Resources with Resource Manager

Manage Space

Back-Up and Recovery Configuration

Oracle Support