Oracle 12c New Features for Administrators

Oracle 12c New Features for Administrators

5 days @ £1,945.00 exc. VAT 

Course Code: O12C11

25 Years - The IT Training specialist

Upcoming Scheduled Events - next 12 months

Location Start Date Spaces Book
London 12 Feb 2018 Spaces StayAhead - Course Running Book
Edinburgh 19 Mar 2018 Spaces StayAhead - Course Running Book
London 16 Apr 2018 Spaces StayAhead - Course Running Book
London 25 Jun 2018 Spaces StayAhead - Course Running Book
View Further Dates

Location Start Date Spaces Book
London 03 Sep 2018 Spaces StayAhead - Course Running Book
London 05 Nov 2018 Spaces StayAhead - Course Running Book

S9

Oracle 12c New Features for Administrators Course Overview

This Oracle 12c New Features for Administrators course is designed to give Oracle Database Administrators practical experience in using the new features available in Oracle Database 12c. Delegates will gain an appreciation of how these features may implemented at their own sites.

The delegate will learn and acquire skills as follows:

  • Creating an Oracle Database 12c Database
  • Upgrading a database to Oracle Database 12c Database
  • Managing Container and Pluggable databases
  • Using new database management features
  • Configuring a heat map
  • Using Temporal history and validity
  • Implementing Unified Auditing
  • Implementing and using Administrative privileges
  • Privilege Analysis
  • Using schema and data management new features
  • Using SQL and PL*SQL new features
  • Using backup and recovery enhancements
  • Using Data Redaction
  • Using performance tuning new features
  • Using Adaptive Execution Plans
  • Using SQL Plan Directives
  • Using Real-Time ADDM
  • Compare Period ADDM
  • Using new Data Pump and SQL*Loader features
  • Using Partitioning enhancements

Who will the Course Benefit?

This Oracle 12c New Features for Administrators course is designed for Oracle professionals who need to gain an understanding of and implement the new features and functionality introduced in Oracle Database 12c.

Course Objectives

This Oracle 12c New Features for Administrators course is designed to give existing Oracle 11g Database Administrators the knowledge and skills needed to implement the new features of 12c database. The Oracle Database 12c administrator will gain practical experience in administering and monitoring an Oracle 12c database.

Examinations

The course covers the major topics of the "New Features of Oracle Database 12c" elements required for the Oracle examination 1Z0-060: Upgrade to Oracle Database 12c. Note that this course covers only the "New Features of Oracle Database 12c" and does not cover the "Key DBA Skills" elements of this exam.

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.

Requirements

Delegates who wish to attend this Oracle 12c New Features for Administrators course should have good understanding of Oracle Database 11g administration. Knowledge of using PL/SQL packages is strongly recommended.

Note

This course is run on a Linux operating system and therefore a good working knowledge of UNIX is required.

NOTE: Course technical content is subject to change without notice.


Oracle 12c New Features for Administrators Training Course

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: CHANGES TO DATABASE MANAGEMENT TOOLS

  • Enterprise Manager Cloud Control Home Page
  • Enterprise Manager Express Home Page
  • SQL Developer new functionality
  • Changes to the OUI and the DBCA

Session 2: ORACLE DATABASE 12c ARCHITECTURE

  • Overview of the Oracle database architecture
  • An overview of a Container Database (CDB)
  • The benefits of Multitenant Architecture
  • The root container and Pluggable Database containers
  • The structure of the Root Container
  • The structure of a Pluggable Database (PDB)
  • CDB_xxx and DBA_xxx Views
  • Plan an installation
  • System requirements and operating system prerequisites
  • Install the Oracle Database software with the OUI
  • The Oracle Inventory
  • Silent mode installation
  • Database software de-install

Session 3: CREATE A DATABASE WITH THE DATABASE CONFIGURATION ASSISTANT (DBCA

  • Select a database storage method
  • Select a CDB or non-CDB database
  • Select a database type based on workload
  • Select a character set for the database
  • Set the NLS_LANG initialization parameter
  • Create a database with the DBCA

Session 4: PREPARATION FOR UPGRADE TO ORACLE DATABASE 12c

  • Methods used to perform upgrade
  • Methods of data migration
  • Direct upgrade supported releases
  • The Database Upgrade Assistant (dbua)
  • Upgrade process overview
  • Rolling upgrade
  • Upgrade a CDB
  • Create an upgrade test plan
  • Carry out performance testing
  • Run the Pre-Upgrade Information tool
  • Backup the database
  • Install the Oracle Database 12c software
  • Create the new Oracle home

Session 5: PERFORM AN UPGRADE TO ORACLE DATABASE 12c

  • Upgrade a database with the Database Upgrade Assistant (DBUA)
  • Upgrade a database manually
  • Migrate a non-CDB to a CDB
  • Deprecated database features and parameters
  • Migrate a non-CDB database to a CDB database

Session 6: POST UPGRADE TASKS

  • Common installation errors
  • Check the /etc/oratab file
  • Check the database version
  • Enterprise Manager Express configuration
  • Carry out post upgrade tasks after a manual upgrade
  • Migrate to unified auditing

Session 7: MIGRATE DATA WITH DATA PUMP

  • Migrate data with Data Pump
  • Transport a database
  • Import data using a Data Pump network link

Oracle 12c New Features for Administrators Training Course

Session 8: CONFIGURE AND CREATE A CONTAINER DATABASE AND PLUGGABLE DATABASES

  • Create and configure a CDB using the OUI
  • Configure a Container database
  • Examine the structure of a CDB using the dbca, SQL Developer, EM Express and the CDB_xxx Views
  • Administer the database using Enterprise Manager and SQL*Plus
  • Create a new PDB from PDB$SEED
  • The PDB LOGGING and NOLOGGING clauses
  • Create a metadata only PDB
  • Clone a PDB subset
  • Create a PDB from a Non-CDB
  • Clone a PDB into the same CDB
  • Clone a PDB into the same CDB using DB links
  • Clone a remote PDB or non-CDB
  • Plug in and unplug a PDB

Session 9: MANAGE A CONTAINER DATABASE AND PLUGGABLE DATABASES

  • Connect to a CDB as an Administrator
  • Connect to a PDB using a service name
  • Connect to a pluggable container
  • Display the current container
  • Switch between containers
  • Startup and shutdown a CDB
  • Open and close a PDB Using SQL*Plus, SQL Developer and EM
  • Open and close all PDBs
  • Change the state of a PDB
  • Automatic startup of pluggable databases
  • Preserve or discard the PDBs Open Mode after a CDB Restart

Session 10: NEW TABLESPACES AND MANAGEMENT FEATURES

  • Data storage overview
  • Create permanent tablespaces in the root and PDBs
  • Online rename and relocation of an active datafile
  • Restrict PGA size
  • Implement extended data types for VARCHAR2, NVARCHAR2 and RAW data types to 32767 bytes
  • Configure instance parameters in a CDB and PDB
  • Temporary UNDO
  • DDL Logging
  • Full Database Caching mode
  • Smart Flash Cache
  • Automatic Big Table Caching
  • In-Memory Column Store

Session 11: MANAGE COMMON AND LOCAL USERS, ROLES AND PRIVILEGES

  • Manage common and local schemas and users in the Root and PDBs
  • Manage system and object privileges to common and local grantees
  • Manage common and local roles
  • Grant roles and privileges to common and local users
  • Use the PDB CONTAINERS clause with common and local users

Session 12: MANAGE BACKUP, RECOVERY AND FLASHBACK OF A CDB AND PDB

  • Container and pluggable database backups
  • Container and pluggable database recovery
  • Recover a CDB from the loss of redo log files, control files and undo datafile loss
  • Recover a PDB from the loss of datafiles
  • Container database point-in-time recovery
  • Pluggable database point-in-time recovery
  • Use Flashback at CDB Level

Session 13: ONLINE DATAFILE MOVE AND AUTOMATIC DATA OPTIMIZATION

  • Data classification in 12c
  • Configure a heat map
  • Automatic movement and compression
  • Compression levels and types

Oracle 12c New Features for Administrators Training Course

Session 14: IN DATABASE ARCHIVING

  • Enhancements to Flashback Database Archive
  • New In-database archiving solutions
  • Use the ROW ARCHIVAL clause to enable row lifecycle state for applications
  • Set the ROW ARCHIVAL VISIBILITY for session level visibility control
  • Use predicate on ORA_ARCHIVE_STATE column
  • Set a Temporal Validity: PERIOD FOR with the CREATE or ALTER TABLE clause
  • SQL temporal data type

Session 15: ENHANCEMENTS TO DATABASE AUDITING

  • Overview of database security
  • Overview of database auditing in Oracle Database 12c
  • Security compliance
  • Standard auditing
  • Unified audit trail overview
  • Create a tablespace for the Unified Audit Trail
  • Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles
  • Configure the Unified Audit Trail
  • Specify audit options
  • Configure the Unified Audit Trail to set a tolerance level for lost of audit records
  • Create audit policies for privilege, action and component auditing

Session 16: ENHANCEMENTS TO PRIVILEGES AND PROFILES

  • Implement the separation of duties for Database Administration tasks
  • Changes to tablespace quotas
  • Read object privileges
  • New password verification functions
  • Database privilege analysis with Database Capture
  • Grant the CAPTURE_ADMIN role to enable management of privilege captures
  • Create, start and stop privilege captures
  • Viewing privilege profile data
  • Query the DBA_PRIV_CAPTURES view
  • The default ORA$DEPENDENCY profile
  • Execute the Invokers Rights privilege with the Inherit Privilege

Session 17: DATA REDACTION

  • Overview of Oracle Data Redaction
  • Types of data masking policies
  • Administer the EXEMPT REDACTION POLICY system privilege to enable a user to view unmasked values
  • Manage masking policies
  • Understanding the masking of statements containing nested functions and subqueries
  • Query the data dictionary to obtain information on masking policies

Session 18: NEW RMAN FEATURES

  • The SYSBACKUP privilege
  • Execute SQL statements in RMAN
  • Use the RMAN DESCRIBE Command
  • Create multi-section backups
  • Table or partition recovery
  • Restore and recover datafiles across the network
  • Run the duplicate database operation with the NOOPEN option
  • Backup and restore very large files
  • Cross platform backup and restore

SESSION 19: MONITORING DATABASE OPERATIONS

  • Overview of DB monitoring operations
  • Define a DB operation
  • Bracketing an operation
  • Monitoring the progress of operations
  • DB Operation tuning
  • DB Operation Active report

Oracle 12c New Features for Administrators Training Course

Session 20: SCHEMA AND DATA CHANGES

  • Create identity columns
  • Create a table with invisible columns
  • Set default values for table columns
  • Truncate table cascade
  • Session level sequences
  • Create multiple indexes on the same set of columns
  • Advanced Row Compression
  • The Schema Change Plan flow
  • Change requests
  • Schema synchronization
  • The Data Comparison package
  • Comparison job results

Session 21: SQL AND PL/SQL ENHANCEMENTS

  • SQL*Plus Enhancements
  • Last login time
  • Row limiting for Top-N result Queries
  • The APPROX_COUNT_DISTINCT function
  • PL/SQL Enhancements
  • Implicit results on SQL*Plus
  • WITH clause enhancements

Oracle 12c New Features for Administrators Training Course

Session 22: PERFORMANCE TUNING NEW FEATURES

  • Overview of performance tuning new features
  • The Adaptive Optimizer
  • SQL Plan Directives
  • Dynamic statistics
  • Online statistics gathering for bulk loads
  • Gather statistics concurrently for multiple tables
  • Histogram enhancements
  • Enhancements to extended statistics
  • Overview of new ADDM Analysis features
  • Emergency Monitoring
  • Real time ADDM analysis
  • Define Workload dimensions
  • Reported items
  • Root causes
  • Report requirements

Session 23: RESOURCE MANAGER AND OTHER PERFORMANCE ENHANCEMENTS

  • Manage resources between PDBs
  • Manage resources within a PDB
  • Manage resources with CDB and PDBs plans
  • Manage runaway queries
  • Automated maintenance tasks
  • Flash Cache
  • The Multithreaded Model using Threaded Execution

SESSION 24: ADR NEW FILE TYPES AND NETWORK COMPRESSION

  • ADR file types
  • New File types
  • New File locations
  • New commands for ADRCI
  • Improve performance by using Network Compression
  • Setup Compression

SESSION 25: DATA PUMP AND SQL*LOADER ENHANCEMENTS

  • Data Pump enhancements
  • Turn off redo log generation
  • Transport view as table
  • Dumpfile compression
  • Password encryption enhancements
  • Use FULL Transportable export and import
  • SQL*Loader enhancements
  • SQL*Loader and External table common enhancements
  • SQL*Loader Express

SESSION 26: PARTITIONING ENHANCEMENTS

  • Move a partition online
  • An overview of the ALTER TABLE ... SPLIT PARTITION, ALTER TABLE ... MERGE PARTITION , ALTER TABLE...ADD PARTITION clauses
  • The split partition operation enhancement
  • The merge partition operation
  • The Add and drop partition operations
Home Let Us Call You Enquiry

Place A booking





Print Friendly



Course Reviews

The course was excellent as was the trainer. Very attentive and obviously well skilled at the subject matter. Would happily recommend.

Howard - Oracle Database Administrator - Professional Services - June 2017


Very good course with excellent instructor.

Kusal - Operational Oracle DBA - NHS


Course provided the necessary update to my knowledge and skills.

Sean - Academic


More Course Reviews....

Enjoyed the course and the Trainer was excellent at explaining everything.

Kevin - DBA - Insurance




StayAhead Promo 7


Oracle User Group - Membership Benefits

Oracle User Group - Membership Benefits

Course Certification

Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.

Programming, Java, Web Dev, SQL, NoSQL, MySQL & MariaDB

Linux, Red Hat, Oracle Linux, SUSE & LPI

UNIX, Solaris, AIX & HP-UX

UNIX 
AIX 
HP-UX 

GDPR, Business Analysis, ITIL & Prince2

See what our clients say . . .

Extremely happy with the course. The material are all well presented and tutor is just great, very knowledgeable and no questions left unanswered.

Zak - System Administrator - Professional Services - November 2017

More Reviews

+44 (0)20 7600 6116
Cookies Policy
Copyright © 2017 StayAhead Training Ltd
sales@stayahead.com