Oracle Database 12c R2: Administration Workshop Ed 3 Training

Live Online & Classroom Enterprise Certification Training

The Oracle Database 12c Administration course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course, you'll learn about the Oracle Database architecture and how to effectively manage an Oracle Database.

Looking for a private batch ?

REQUEST A CALLBACK

Certified Trainer
Authorized Courseware
Completion Certificate from ATP

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is Oracle Database 12c Administration Certification Training about?

Through our Oracle 12c administration certification training, you will be exposed to detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course.

To provide an acceptable response time to users and manage resources effectively, you will further learn how to monitor your database and manage performance.

What are the objectives of Oracle Database 12c Administration Certification Training ?

After the successful, completion of this course, you will be able to:

Back up, restore, and patch DBCS database deployments
Describe the DBaaS and on-premises Oracle Database architectures
Manage database instances
Manage UNDO data
Move data between databases
Implement basic backup and recovery procedures
Monitor and tune database performance
Tune SQL to improve performance
Manage resources with Oracle Database Resource Manager
Create pluggable databases (PDBs)
Configure the Oracle network environment
Administer user security and implement auditing
Create and manage tablespaces
Manage storage space
Create and manage Database as a Cloud Service (DBCS) database deployments
Register databases and manage performance with Enterprise Manager Cloud Control

Who is Oracle Database 12c Administration Certification Training for?

Database Administrators
Database Designers
Support Engineer
Technical Administrator
Data Warehouse Administrator

What are the prerequisites for Oracle Database 12c Administration Certification Training?

Suggested Prerequisite

A working knowledge of SQL and PL/SQL packages is very helpful in the course.
Basic knowledge of Linux operating system

Available Training Modes

Live Online Training

40 Hours

Classroom Training

5 Days

Course Outline Expand All

Expand All

Getting Started

Course Objectives

Exploring Oracle Database Architecture

Querying the Oracle Data Dictionary

Oracle Database Tools

Oracle-Supplied User Accounts

Oracle Database Server Architecture

Oracle SQL and PL/SQL

Connecting to Oracle Databases

Introducing Oracle Database

Relation Database Models

Managing Database Instances

Initialization Parameter Files

Opening and Closing PDBs

Starting Up Oracle Databases

Shutting Down Oracle Databases

Querying Dynamic Performance Views

Working with the Automatic Diagnostic Repository (ADR)

Creating PDBs

Methods and Tools to Create PDBs

Dropping PDBs with SQL*Plus

Unplugging and Pluggin In PDBs with SQL*Plus

Cloning PDBs with SQL*Plus

Creating PDBs from Seed with SQL*Plus

Configuring the Oracle Network Environment

Configuring Listeners for Static Service Registration

Dedicated Versus Shared Server Configurations

How Listeners Work

Testing Oracle Net Connectivity with tnsping

Configuring Listeners for Dynamic Service Registration

Oracle Net Services

Configuring Local Naming for Connections

Configuring Communication Between Databases

Administering User Security

Authenticating Users

Assigning Quotas to Users

Creating Users

Granting Privileges

Creating and Granting Roles

Creating and Assigning Profiles

Applying the Principal of Least Privilege

Revoking Privileges and Roles

Creating and Managing Tablespaces

Implementing Oracle Managed Files

Creating Tablespaces in SQL*Plus

Moving and Renaming Online Data Files in SQL*Plus

Viewing Tablespace Information in SQL*Plus

How Table Data is Stored

Altering and Dropping Tablespaces in SQL*Plus

Managing Storage Space

Block Space Management

Allocating Extents

Free Space Management Within Segments

Row Chaining and Migration

Space-Saving Features

Types of Segments

Oracle Database Space Management Features

Understanding Deferred Segment Creation

Managing UNDO Data

Local Undo Mode Versus Shared Undo Mode

Comparing Undo Data and Redo Data

Undo Data: Overview

Configuring Undo Retension

Categories of Undo

Storing Undo Information

Transactions and Undo Data

Managing Undo

Moving Data

Oracle Data Pump: Benefits

Data Pump Export and Import Clients

SQL*Loader Overview

Data Pump Utility: Interfaces and Modes

Loading Methods

Oracle Data Pump: Overview

Data Pump Import: Transformations

Moving Data: General Architecture

Backup and Recovery Concepts

Categories of Failure

Understanding Types of Backups

Understanding Instance Recovery

Flashback Technology

DBA Responsibilities

Oracle Data Protection Solutions

Comparing Complete and Incomplete Recovery

Monitoring and Tuning Database Performance

Database Maintenance

Automatic Database Diagnostic Monitor

Automatic Workload Repository (AWR)

Database Server Statistics and Metrics

Performance Tuning Methodology

Performance Planning Considerations

Managing Performance Activities

Performance Monitoring

SQL Tuning

Oracle Optimizer

SQL Access Advisor

SQL Plan Directives

SQL Tuning Advisor

SQL Tuning Process

Optimizer Statistics

Adaptive Execution Plans

SQL Performance Analyzer

Oracle Database Resource Manager

Resource Manager Elements

Limiting CPU Utilization at the Database Level

Using the Active Session Pool Feature

Creating a Complex Resource Plan

Oracle Database Resource Manager: Overview

Limiting CPU Utilization at the Server Level

Creating a Simple Resource Plan

Using Resource Manager to Allocate Resources

Enterprise Manager Cloud Control

Controlling the Enterprise Manager Cloud Control Framework

Starting the Enterprise Manager Cloud Control Framework

Stopping the Enterprise Manager Cloud Control Framework

Introduction to Oracle Database Cloud Service

DBCS Architecture

Oracle Cloud: Overview

Additional Database Configuration Options

Features and Tooling

Database Cloud Service Offerings

Creating DBCS Database Deployments

Creating a Database Deployment

Automated Database Provisioning

Creating an SSH Key Pair

How SSH Key Pairs are Used

Storage Used for Database Files

Managing DBCS Database Deployments

Managing Network Access to DBCS

Cloud Tooling

Accessing Tools and Features from the DBCS Console

Enabling Access to a Compute Node Port

Scaling a Database Deployment

Managing the Compute Node Associated With a Database Deployment

Backing Up and Restoring DBCS Database Deployments

Backing Up and Recovering Databases on DBCS

Creating an On-Demand Backup

Performing Recovery by Using the Console

Performing Recovery by Using the dbaascli Utility

Backup Configuration

Customizing the Backup Configuration

Backup Destination Choices

Patching DBCS Database Deployments

Using the dbaascli Utility to Manage Patches

Using the DBCS Console to Manage Patches

Patching DBCS

Creating Master Encryption Keys for PDBs

Creating and Activating an Encryption Key

Determining Whether You Need to Create and Activate and Encryption Key for a PDB

CDB and PDB Master Encryption Keys

Tablespace Encryption by Default

Using TDE

Defining the Keystore Location

Transparent Data Encryption (TDE) Overview

Managing the Software Keystore and Master Encryption Key

Managing the Keystore in CDBs and PDBs

Components of TDE

Tablespace Encryption by Default in DBCS

Controlling Tablespace Encryption by Default

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

Oracle Database 12c Administration Certification Training - Certification & Exam

SpringPeople is the Authorized Training Partner of Oracle.
This Oracle 12c Administration training is aligned to Oracle Database 12c: Installation and Administration (1Z0-062) certification exam
The training fees is exclusive of exam cost.
For any queries; feel free to reach us at oracle@springpeople.com

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree