> > > D90165GC10 Detailed outline

Oracle Database 12c: SQL and PL/SQL New Features Ed 1 (D90165GC10)

Course Description Schedule Course Outline

Detailed Course Outline

Course Introduction
  • Course Objectives
  • Course Agenda
  • Schemes used in this course
  • Classroom account information
  • Overview of SQL Developer 4.0
  • Review the Oracle Database 12c SQL and PL/SQL documentation and additional resources
SQL Language Enhancements
  • SQL Row Limiting Clause
  • Invisible and Hidden Columns
  • Enhanced DDL capabilities using ONLINE keyword
  • Additional features in SQL Language
Data Types Enhancements
  • Increased Length Limits of Data Types
  • Using SQL IDENTITY Column
  • SQL Column enhancements
  • ANYDATA type Enhancements
  • GATEWAY Enhancements
PL/SQL Enhancements
  • What is a White List?
  • Understanding Invoker's right and Definer's right
  • Granting Roles to PL/SQL packages and standalone stored subprograms
  • PL/SQL functions that run faster in SQL
  • Additional PL/SQL Enhancements
Data Warehousing Enhancements
  • Multi partition maintenance operations
  • Review of partitioned indexes
  • SQL for Pattern Matching
  • Overview of Synchronous Materialized View Refresh
  • Improving Query Performance Against OLAP Cubes