Oracle Database 12cR2 Administration
Overview
This Oracle Database 12cR2 Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle 12c database.
A database administrator will gain an understanding of the architecture and processes of the Oracle database server. The delegate will learn how to ensure the integrity and availability of a company's data within the Oracle environment. The delegate will also learn how to monitor the performance of a database, allocate resources with the Resource Manager and schedule jobs with the Oracle Job scheduler.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Objectives
The delegate will learn and acquire skills as follows:
- Administering an Oracle Database Instance
- Monitoring an Oracle Database
- Configuring the Oracle Network Environment
- Creating and Managing Database Storage Structures
- Managing Users, Profiles, Privileges and Roles
- Managing Undo Data and Temporary Segments
- Monitoring and Resolving Lock Conflicts
- Maintaining Database Security
- Implementing Database Auditing
- Monitoring the Performance of the Database
- Loading and Unloading Data
- Using the Job Scheduler
- Configuring a Database for Backup and Recovery
Target Audience
This Oracle Database 12cR2 Administration course is for anyone who needs to administer, monitor and support an Oracle 12c database.
Additional Information
- Course technical content is subject to change without notice.
- Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.
Training Partners
We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.
Modules
Prerequisites
Delegates who wish to attend the Oracle Database 12cR2 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.
This course is run on a Linux operating system, a basic knowledge of UNIX/Linux is recommended but is not essential.
Additional Learning
The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor .
-
PL/SQL
A 2-day Training Course on PL/SQL; Designed for those who need to write program scripts using Oracle's Procedure Language; corresponds to exam 1Z0-001
-
Oracle SQL
The SQL training course is designed for anyone who needs to access and work with an Oracle Database
Relevant Certifications
Scheduled Dates
Please select from the dates below to make an enquiry or booking.
Pricing
Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.