Oracle 12c: SQL & PL/SQL New Features

Course Fees: $2044.00 excl. GST
Printed Manual: $45.00 excl. GST
Course Duration: 2 days
Course Manual

Sorry, no course dates found

The Oracle Database 12c: SQL and PL/SQL New Features training introduces you to the new features available in Oracle Database 12c. Expert Oracle University instructors will help you explore the latest features available in SQL language and feature enhancements in PL/SQL, data types, language performance and data warehousing. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service.

Learn To:

  • Understand the FETCH clause to limit the rows returned by a SQL query.
  • Take advantage of the invisible and hidden columns.
  • Make use of the IDENTITY column to automatically generate the number column.
  • Utilize the ACCESSIBLE BY clause to create a white list of PL/SQL units.
  • Grant roles to PL/SQL packages and standalone stored procedures.
  • Understand Synchronous Materialized Views.
  • Identify ways to improve query performance against OLAP cubes.
  • Gain an understanding of the Oracle Database Exadata Express Cloud Service.

Benefits to You

When you walk away from this course, you will have gained a better understanding of the data warehousing new features available in Oracle Database 12c. This includes maintaining multiple partitions and SQL for pattern matching.

  • Application Developers
  • Database Administrators
  • Database Administrators
  • System Analysts
  • System Analysts
  • System Analysts
  • Project Manager
  • Project Manager
Knowledge of Oracle Database, Structured Query Language(SQL), Basic programming concepts such as IF-THEN statements, loops, procedures, and functions
12cR2: Admin Workshop
  • Create Invisible and Hidden columns in a table
  • Understand enhanced DDL capabilities using ONLINE keyword
  • Identify additional new features available in SQL Language
  • Identify the increased length limits of data types
  • Configure database for extended data type
  • Understand SQL IDENTITY column
  • Identify SQL Column enhancements defaulting on explicit NULL and using a sequence
  • Identify additional feature available in Data Types such as ANYDATA, and GATEWAY
  • Understand fine grained access controls for packaged procedures
  • Define invoker's rights function that can be result cached
  • Implement ACCESSIBLE BY clause
  • Grant roles to PL/SQL packages and standalone stored subprograms
  • Identify PL/SQL functions that can run faster in SQL
  • Maintain Multiple Partitions
  • Use FETCH clause in SQL queries
  • Gain an understanding of the Oracle Database Exadata Express Cloud Service

Course Introduction

  • Course Agenda
  • Review the Oracle Database 12c SQL and PL/SQL documentation and additional resources
  • Overview of SQL Developer 4.0
  • Course Objectives
  • Schemes used in this course
  • Classroom account information

SQL Language Enhancements

  • SQL Row Limiting Clause
  • Enhanced DDL capabilities using ONLINE keyword
  • Invisible and Hidden Columns
  • Additional features in SQL Language

Data Types Enhancements

  • Using SQL IDENTITY Column
  • Increased Length Limits of Data Types
  • ANYDATA type Enhancements
  • SQL Column enhancements
  • GATEWAY Enhancements

PL/SQL Enhancements

  • Additional PL/SQL Enhancements
  • What is a White List?
  • PL/SQL functions that run faster in SQL
  • Granting Roles to PL/SQL packages and standalone stored subprograms
  • Understanding Invoker's right and Definer's right

Data Warehousing Enhancements

  • Multi partition maintenance operations
  • Improving Query Performance Against OLAP Cubes
  • Review of partitioned indexes
  • Overview of Synchronous Materialized View Refresh
  • SQL for Pattern Matching

Oracle Cloud Overview

  • What is in Exadata Express?
  • Evolving from On-premises to Exadata Express
  • Cloud Deployment Models
  • Oracle Exadata Express Cloud Service
  • Introduction to Oracle Cloud & Oracle Cloud Services
  • Exadata Express for Users & Developers
  • Getting Started with Exadata Express
  • Service Console & Web Access through Service Console