Oracle Database 12c R2 Administration Workshop Ed 3.x

Duration: 
5 days
Codes: 
12C,OC12CDBAW
Versions: 
3.X,R2

Overview

This course offers you an introduction to Oracle Database 12c database technology. You will learn the concepts of relational databases and the powerful SQL programming language. Discover essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables and create database objects.

Learn To:

  • Understand SQL statements, as well as the Oracle Relational Database.
  • Use SQL Developer.
  • Write reports using SQL statements.
  • Manipulate data in relational tables and save the data.
  • Understand the concepts of relational databases and the powerful SQL programming language.
  • Write reports using SQL Statements

Benefits to You:

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Use Single Row Functions:

This Oracle Database course will also teach you how to use single row functions to customize output. Explore using conversion functions and conditional expressions, along with use group functions to report aggregated data.

Reinforce Your Knowledge through Hands-On Exercises:

Demonstrations and hands-on practice reinforce the fundamental concepts you'll delve into in this course. You will discover and use Oracle SQL Developer as the main environment tool for writing SQL. SQL*Plus is also introduced as an optional tool

Audience

This course is designed for professionals whose work involves the administration of an Oracle 12c database, as well as anyone involved in working with databases who may be tasked with administering Oracle databases. Experience equivalent to Course 2226, "Oracle Database 12c Introduction," is assumed.

Skills Gained

At the end of this course you will be able to:

  • Describe the components of ASM
  • Explain and apply Automatic Storage Management (ASM) initialization parameters
  • Manage ASM instances and associated processes
  • Monitor ASM using the V$ASM dynamic performance views
  • Understand Flex ASM architecture and components
  • Understand ASM Deployment Alternatives
  • Install and configure Flex ASM
  • Manage Flex ASM
  • Employ ASM space management techniques
  • Create and delete Automatic Storage Management (ASM) disk groups
  • Set the attributes of an existing ASM disk group
  • Perform ongoing maintenance tasks on ASM disk groups
  • Explain key performance and scalability considerations for ASM disk groups
  • Describe the Automatic Storage Management (ASM) architecture
  • Use different client tools to access ASM files
  • Describe the format of a fully qualified ASM file name

Prerequisites

Required:

  • Working knowledge of SQL and use of PL/SQL packages
  • Basic knowledge of Linux operating system

Those delegates who are attending via either virtual or extended classroom will be required to provide either dual monitors or single monitor plus a tablet device.

Course Outline

Getting Started

  • Course Objectives

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 Communidation 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 Retension
  • 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

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
London
London3 1500 £1500 2019-07-08
Manchester
Manchester3 1500 £1500 2019-07-08
Glasgow
Glasgow5 2550 £2550 2019-07-08
London
London5 2805 £2805 2019-07-08
London
London5 2805 £2805 2019-07-08
Manchester
Manchester3 1500 £1500 2019-07-08
Cheshire
Chester3 1530 £1530 2019-07-08
Online
Online3 1530 £1530 2019-07-08
London
London3 1683 £1683 2019-07-15
Glasgow
Glasgow3 1530 £1530 2019-07-15
Edinburgh
Edinburgh5 2550 £2550 2019-07-15
Glasgow
Glasgow3 1530 £1530 2019-07-15
Manchester
Manchester3 1500 £1500 2019-07-15
Cheshire
Chester3 1530 £1530 2019-07-15
Manchester
Manchester3 1500 £1500 2019-07-15
London
London3 1683 £1683 2019-07-15
London
London5 2500 £2500 2019-07-15
Glasgow
Glasgow3 1530 £1530 2019-07-17
Glasgow
Glasgow2 1000 £1000 2019-07-17
Bristol
Bristol4 1750 £1750 2019-07-17
Glasgow
Glasgow3 1500 £1500 2019-07-17
London
London2 1000 £1000 2019-07-18
Virtual
Virtual5 6594 £6594 2019-07-22
Onsite
Onsite5 3500 3500 2019-07-23
Manchester
Manchester3 1530 £1530 2019-08-05
London
London3 1683 £1683 2019-08-05
Manchester
Manchester5 2500 £2500 2019-08-12
Manchester
Manchester5 2500 £2500 2019-08-12
London
London3 1683 £1683 2019-08-12
London
London3 1683 £1683 2019-08-12
London
London5 2500 £2500 2019-08-12
Bristol
Bristol5 1750 £1750 2019-08-19
Glasgow
Glasgow3 1500 £1500 2019-08-19
Glasgow
Glasgow3 1500 £1500 2019-08-19
Virtual
Virtual5 6594 £6594 2019-08-19
London
London5 2445 £2445 2019-08-19
Bristol
Bristol4 1750 £1750 2019-08-20
Bristol
Bristol3 1750 £1750 2019-08-21
Bristol
Bristol2 1750 £1750 2019-08-22
Bristol
Bristol1 1750 £1750 2019-08-23
Berkshire
Reading5 6699 £6699 2019-09-02
London
London5 6799 £6799 2019-09-02
Kent
Canterbury5 7499 £7499 2019-09-02
Yorkshire
Sheffield5 7368 £7368 2019-09-02
Kent
Canterbury5 7698 £7698 2019-09-02
Suffolk
Ipswich5 7499 £7499 2019-09-02
Middlesbrough
TBC5 7698 £7698 2019-09-02
Yorkshire
Wakefield5 7698 £7698 2019-09-02
Wiltshire
Swansea5 7698 £7698 2019-09-02
Nottinghamshire
Nottingham5 7368 £7368 2019-09-02
Surrey
Guildford5 7698 £7698 2019-09-02
Midlands
Solihull5 7698 £7698 2019-09-02
Hampshire
Portsmouth5 7698 £7698 2019-09-02
Glasgow
Glasgow5 7368 £7368 2019-09-02
Wiltshire
Swansea5 7698 £7698 2019-09-02
Kent
Chatham5 7698 £7698 2019-09-02
Manchester
Bolton5 7698 £7698 2019-09-02
Wiltshire
Swindon5 7698 £7698 2019-09-02
Derbyshire
Burton upon Trent5 7499 £7499 2019-09-02
Cumbria
Carlisle5 7499 £7499 2019-09-02
Glamorgan
Cardiff5 7199 £7199 2019-09-02
Essex
Chelmsford5 7698 £7698 2019-09-02
Midlands
Birmingham5 6928 £6928 2019-09-02
Cumbria
Carlisle5 7698 £7698 2019-09-02
Oxfordshire
Oxford5 7698 £7698 2019-09-02
Northern Ireland
Belfast5 7199 £7199 2019-09-02
Northamptonshire
Corby5 7698 £7698 2019-09-02
Hertfordshire
Watford5 7698 £7698 2019-09-02
Cambridgeshire
Peterborough5 7698 £7698 2019-09-02
Derbyshire
Burton upon Trent5 7698 £7698 2019-09-02
Cheshire
Warrington5 7698 £7698 2019-09-02
Cheshire
Chester5 7698 £7698 2019-09-02
Fife
Dunfermline5 7698 £7698 2019-09-02
Devon
Exeter5 7499 £7499 2019-09-02
Hampshire
Portsmouth5 7698 £7698 2019-09-02
Gloucestershire
Cirencester5 7499 £7499 2019-09-02