Oracle Database 12c New Features Seminar

Focus on Training

Course

In London-City

£ 395 + VAT

The best Oracle courses

See all

See all

Description

  • Type

    Course

  • Location

    London-city

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. This Seminar is designed for Oracle professionals who need an understanding of the new features and functionality introduced in Oracle Database 12c. Learning Objectives The delegate will gain an understanding of: Oracle Database 12c ArchitectureMultitenant ArchitectureContainer and Pluggable DatabasesEnterprise Manager Cloud Control and ExpressInstallation changesUpgrade issuesNew management featuresDatabase security enhancementsNew schema management functionalityNew SQL featuresNew PL/SQL featuresPerformance tuning new featuresData Pump and SQL Loader new featuresRMAN new featuresStandby Database improvementsASM changes and new featuresGrid Infrastructure and RAC new features

Facilities

Location

Start date

London-City ((select))
EC3V 9LJ

Start date

On request

About this course

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Database training
  • PL/SQL
  • SQL
  • Database

Course programme

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

See related categories

Oracle Database 12c New Features Seminar

£ 395 + VAT

The best Oracle courses

See all

See all