Oracle Database 12c New Features Seminar

Oracle Database 12c New Features Seminar

1 day @ £425.00 exc. VAT 

Course Code: O12CN

25 Years - The IT Training specialist

Upcoming Scheduled Events - next 12 months

Location Start Date Spaces Book
London 02 Feb 2018 Spaces StayAhead - Course Running Book
London 27 Apr 2018 Spaces StayAhead - Course Running Book
London 06 Jul 2018 Spaces StayAhead - Course Running Book
London 28 Aug 2018 Spaces StayAhead - Course Running Book
View Further Dates

Location Start Date Spaces Book
London 23 Nov 2018 Spaces StayAhead - Course Running Book

S5

Oracle Database 12c New Features Seminar Course Overview

This Oracle Database 12c New Features Seminar is designed to give delegates an appreciation of the new features available in Oracle Database 12c and of how these features may affect current Oracle installations.

The delegate will learn and acquire skills as follows:

  • Oracle Database 12c Architecture
  • Multitenant Architecture
  • Container and Pluggable Databases
  • Enterprise Manager Cloud Control and Express
  • Installation changes
  • Upgrade issues
  • New management features
  • Database security enhancements
  • New schema management functionality
  • New SQL features
  • New PL/SQL features
  • Performance tuning new features
  • Data Pump and SQL Loader new features
  • RMAN new features
  • Standby Database improvements
  • ASM changes and new features
  • Grid Infrastructure and RAC new features

Who will the Seminar Benefit?

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

Seminar Objectives

By the end of this seminar, the delegate will have gained an appreciation of the new features available in Oracle Database 12c and how these can be implemented.

Requirements

Delegates should have an appreciation of the features available in an Oracle Database 11gR2 database.

Note

There is no practical content within this Oracle Database 12c New Features Seminar.

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


Oracle Database 12c New Features Seminar Training Course

Course Introduction

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

Session 1: OVERVIEW OF ORACLE DATABASE 12c ARCHITECTURE

  • Oracle Database 12c Architecture
  • An Overview of Multitenant Architecture
  • The Benefits of Multitenant Architecture
  • Container Databases
  • Pluggable Databases
  • CDB_xxx Views

Session 2: INSTALL AND UPGRADE TO ORACLE DATABASE 12c

  • Install Oracle Database 12c using OUI
  • Create a Database using dbca
  • Configuration and Creation of a Container Database (CDB)
  • Creation of a New Pluggable Database (PDB)
  • Plug in an Unplugged PDB
  • Upgrade to Oracle Database 12c
  • Pre-Upgrade Script
  • Parallel Upgrade Utility
  • Deprecated Features
  • Deprecated Parameters

Session 3: NEW MANAGEMENT FEATURES

  • Enterprise Manager Cloud Control
  • Enterprise Manager Express
  • SQL Developer New Functionality
  • Restricting PGA Size
  • Extended Data Types
  • Temporary Undo
  • DDL Logging
  • Online Rename and Relocation of an Active Datafile
  • Table Partition Maintenance Enhancements

Session 4: DATABASE SECURITY ENHANCEMENTS

  • Limitations to RESOURCE and SELECT ANY DICTIONARY Privileges
  • Separation of Duties
  • Privilege Analysis
  • Enhanced Audit Trail Security
  • Code Based Access Control
  • Invoker's Rights
  • Data Redaction
  • Encryption Enhancements

Session 5: SCHEMA MANAGEMENT NEW FEATURES

  • Identity Columns
  • Invisible Columns
  • Default Values for Table Columns
  • In Database Row Archiving
  • Truncate Table Cascade
  • Session Level Sequences
  • New PL/SQL Commands

Session 6: SQL AND PL/SQL NEW FEATURES

  • SQL*Plus Enhancements
  • Last Login Time
  • Pluggable Database Support
  • Row Limiting for Top-N Result Queries
  • PL/SQL Enhancements
  • Implicit Results on SQL*Plus
  • WITH Clause Enhancements

Session 7: PERFORMANCE TUNING NEW FEATURES

  • Adaptive Optimizer
  • Adaptive Execution Plans
  • Gather Statistics Concurrently on Multiple Tables
  • Enhanced Statistics
  • Multiple Indexes on the Same Column
  • Real Time ADDM Analysis

Session 8: DATA PUMP AND SQL*LOADER ENHANCEMENTS AND NEW FEATURES

  • Turn of Logging During Data Pump Import
  • Convert a View into a Table During Data Pump Export
  • SQL Loader Express

Session 9: RECOVERY MANAGER ENHANCEMENTS

  • The sysbackup Privilege
  • Execute SQL Statements in RMAN
  • Table or Partition Recovery in RMAN
  • Restore and Recover Data Files across the Network
  • Cross Platform Backup and Restore

Session 10: STANDBY DATABASE ENHANCEMENTS

  • Active Data Guard Far Sync
  • Active Data Guard Real Time Cascading
  • Data Guard Fast Sync
  • Rolling Upgrade with Data Guard
  • DML on Global Temporary Tables
  • Unique Sequences
  • Validate Role Change Readiness

Session 11: ASM CHANGES AND NEW FEATURES

  • Flex ASM
  • Increased ASM Storage Hard Limits
  • Tune ASM Rebalance Operations
  • ASM Disk Scrubbing
  • Active Session History for ASM

Session 12: GRID INFRASTRUCTURE AND RAC CHANGES AND NEW FEATURES

  • Flex Clusters
  • Backup the OCR to an ASM Disk Group
  • IPV6 Support
  • Additions to the svrctl Command
  • What-if Command Evaluation with crsctl and srvctl
Home Let Us Call You Enquiry

Place A booking





Print Friendly



Course Reviews

Very useful course and perfect for what I required.

Craig - Director - IT


Excellent course and very knowledgeable and friendly instructor. Concepts explained very clearly and how they could be useful in a real-world environment. I would definitely recommend the course and StayAhead training to others.

Matt - Managing Director - IT




StayAhead Promo 2


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