Description

Duration

5 Days

30 CPD hours

This course is intended for

Data Warehouse Administrator
Database Administrators
Database Designers
Support Engineer
Technical Administrator

Overview

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

The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide students with a firm foundation in administration of an Oracle Database. In this course students will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner.

Exploring Oracle Database Architecture

Introducing Oracle Database

Relation Database Models

Oracle SQL and PL/SQL

Oracle Database Server Architecture

Connecting to Oracle Databases

Oracle Database Tools

Oracle-Supplied User Accounts

Querying the Oracle Data Dictionary

Managing Database Instances

Initialization Parameter Files

Starting Up Oracle Databases

Shutting Down Oracle Databases

Opening and Closing PDBs

Working with the Automatic Diagnostic Repository (ADR)

Querying Dynamic Performance Views

Creating PDBs

Methods and Tools to Create PDBs

Creating PDBs from Seed with SQL*Plus

Cloning PDBs with SQL*Plus

Unplugging and Pluggin In PDBs with SQL*Plus

Dropping PDBs with SQL*Plus

Configuring the Oracle Network Environment

Oracle Net Services

How Listeners Work

Configuring Listeners for Dynamic Service Registration

Configuring Listeners for Static Service Registration

Configuring Local Naming for Connections

Testing Oracle Net Connectivity with tnsping

Configuring Communication Between Databases

Dedicated Versus Shared Server Configurations

Administering User Security

Creating Users

Granting Privileges

Creating and Granting Roles

Revoking Privileges and Roles

Creating and Assigning Profiles

Authenticating Users

Assigning Quotas to Users

Applying the Principal of Least Privilege

Creating and Managing Tablespaces

How Table Data is Stored

Creating Tablespaces in SQL*Plus

Altering and Dropping Tablespaces in SQL*Plus

Viewing Tablespace Information in SQL*Plus

Implementing Oracle Managed Files

Moving and Renaming Online Data Files in SQL*Plus

Managing Storage Space

Oracle Database Space Management Features

Block Space Management

Row Chaining and Migration

Free Space Management Within Segments

Types of Segments

Allocating Extents

Understanding Deferred Segment Creation

Space-Saving Features

Managing UNDO Data

Undo Data: Overview

Transactions and Undo Data

Storing Undo Information

Comparing Undo Data and Redo Data

Managing Undo

Local Undo Mode Versus Shared Undo Mode

Configuring Undo Retention

Categories of Undo

Moving Data

Moving Data: General Architecture

Oracle Data Pump: Overview

Oracle Data Pump: Benefits

Data Pump Export and Import Clients

Data Pump Utility: Interfaces and Modes

Data Pump Import: Transformations

SQL*Loader Overview

Loading Methods

Backup and Recovery Concepts

DBA Responsibilities

Categories of Failure

Understanding Instance Recovery

Understanding Types of Backups

Comparing Complete and Incomplete Recovery

Oracle Data Protection Solutions

Flashback Technology

Monitoring and Tuning Database Performance

Managing Performance Activities

Performance Planning Considerations

Database Maintenance

Automatic Workload Repository (AWR)

Automatic Database Diagnostic Monitor

Performance Monitoring

Performance Tuning Methodology

Database Server Statistics and Metrics

SQL Tuning

SQL Tuning Process

Oracle Optimizer

Optimizer Statistics

SQL Plan Directives

Adaptive Execution Plans

SQL Tuning Advisor

SQL Access Advisor

SQL Performance Analyzer

Oracle Database Resource Manager

Oracle Database Resource Manager: Overview

Resource Manager Elements

Using Resource Manager to Allocate Resources

Creating a Simple Resource Plan

Creating a Complex Resource Plan

Using the Active Session Pool Feature

Limiting CPU Utilization at the Database Level

Limiting CPU Utilization at the Server Level

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

Oracle Cloud: Overview

Database Cloud Service Offerings

DBCS Architecture

Features and Tooling

Additional Database Configuration Options

Creating DBCS Database Deployments

Automated Database Provisioning

Creating a Database Deployment

How SSH Key Pairs are Used

Creating an SSH Key Pair

Storage Used for Database Files

Managing DBCS Database Deployments

Cloud Tooling

Accessing Tools and Features from the DBCS Console

Managing the Compute Node Associated With a Database Deployment

Managing Network Access to DBCS

Enabling Access to a Compute Node Port

Scaling a Database Deployment

Backing Up and Restoring DBCS Database Deployments

Backing Up and Recovering Databases on DBCS

Backup Destination Choices

Backup Configuration

Creating an On-Demand Backup

Customizing the Backup Configuration

Performing Recovery by Using the Console

Performing Recovery by Using the dbaascli Utility

Patching DBCS Database Deployments

Patching DBCS

Using the DBCS Console to Manage Patches

Using the dbaascli Utility to Manage Patches

Creating Master Encryption Keys for PDBs

CDB and PDB Master Encryption Keys

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

Creating and Activating an Encryption Key

Tablespace Encryption by Default

Tablespace Encryption by Default in DBCS

Transparent Data Encryption (TDE) Overview

Components of TDE

Using TDE

Defining the Keystore Location

Controlling Tablespace Encryption by Default

Managing the Software Keystore and Master Encryption Key

Managing the Keystore in CDBs and PDBs

Additional course details:

Nexus Humans Oracle Database 12c R2 - Administration Workshop Ed 3 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward.

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the Oracle Database 12c R2 - Administration Workshop Ed 3 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Course Images

Oracle Database 12c R2 - Administration Workshop Ed 3

By Nexus Human

Booking options

Highlights

Description

About The Provider

Tags

Reviews