Course code: D90165« Back

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

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.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.

 DateDurationCourse priceHandbook priceCourse languageLocation 
Anytime 2 20 080 CZK included in course price Anglický jazyk On Demand
9/23/2019 2 23 230 CZK included in course price Český jazyk GOPAS Praha
12/12/2019 2 23 230 CZK included in course price Český jazyk GOPAS Praha_GTT
12/12/2019 2 23 230 CZK included in course price Český jazyk GOPAS Brno_GTT
12/12/2019 2 858,00 EUR included in course price Slovenský jazyk GOPAS Bratislava_GTT
Anytime 2 21 632 CZK included in course price Anglický jazyk Virtual Class

AffiliateDurationCatalogue priceHandbook priceITB*
No records found.

*The course price includes price of the original study materials.

*Body se vztahují pouze na kurzy realizované v prostorách Gopasu.

Who is the course for

  • Application Developers
  • Database Administrators
  • Project Manager
  • System Analysts

What we teach you

  • 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.

Course Objectives

  • 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
  • Identify the various new features and enhancements available in Oracle Database 12c - SQL Language, Data Types,
  • PL/SQL, and Data Warehousing

Required skills

Knowledge of Oracle Database, Structured Query Language(SQL), Basic programming concepts such as IF-THEN statements, loops, procedures, and functions.

Teaching methods

Expert instruction with practical examples, computer practice

Oracle Training Formats

Training on Demand, one of the most popular learning formats, allows students to learn whenever they need (24/7, 90 days). These video recorded courses are led by TOP instructors. Other learning formats are traditional in-class training, Live Virtual Class, or Self-Study Courses. Read more here.

Teaching materials

The student materials include comprehensive courseware and other necessary materials for this class. All reading materials are in English.

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 resource

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

Previous courses

Next courses

no following course
Oracle University eKit

included in course price
The prices are without VAT.