Oracle database 12C SQL, PL/SQL New Features Certification Training

Course Information

The Oracle Database 12c: SQL and PL/SQL New Features training has been designed for database administrators that provides a detailed understanding of the new features available in Oracle Database 12c.

This certification course will help you explore the latest features that can be deployed in SQL language and also the feature enhancements in PL/SQL, data types, language performance and data warehousing. This course will also introduce you to Oracle Database Exadata Express Cloud Service.

Completion of this training course will enable candidates in:

Understanding the FETCH clause to limit the rows returned by a SQL query.
Taking advantage of the invisible and hidden columns.
Making use of the IDENTITY column to automatically generate the number column.
Utilizing the ACCESSIBLE BY clause to create a white list of PL/SQL units.
Granting roles to PL/SQL packages and standalone stored procedures.
Understanding Synchronous Materialized Views.
Identifying ways to improve query performance against OLAP cubes.
Gaining an understanding of the Oracle Database Exadata Express Cloud Service.

Course Benefits:

Attaining certification of this course helps individuals get a better understanding of the data warehousing new features available in Oracle Database 12c. This includes maintaining multiple partitions and SQL for pattern matching.

COURSE OUTLINE

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

2. SQL Language Enhancements

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

3. Data Types Enhancements

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

4. PL/SQL Enhancements

Define a White List
Understand Invoker’s right and Definer’s right
Grant Roles to PL/SQL packages and standalone stored subprograms
PL/SQL functions that run faster in SQL
Additional PL/SQL Enhancements

5. Data Warehousing Enhancements

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

6. Oracle Cloud Overview

Introduction to Oracle Cloud & Oracle Cloud Services
Cloud Deployment Models
Explore Exadata Express
Evolving from On-premises to Exadata Express
Exadata Express for Users & Developers
Service Console & Web Access through Service Console
Oracle Exadata Express Cloud Service
Get Started with Exadata Express

Name

Code

Fee

What Our Trainees Say

very good and great coordination of Mercury Solutions staff for training.
Project Management Professional (PMP)

Sundar V A, Gurgaon

The instructor was good and generated interest in the course
Project Management Professional (PMP)

Chandrabhanoo Chakrabarti, Gurgaon

The CEH contents was good and covered complete syllabus of EC Council and the instructor was great!
CEH V10 ANSI Training

Saleem Tahiri , Gurgaon

Overall excellent and very much positive approach in all ways of professional driving through the training academy and instructor as a very much fabulous gesture to all.
Project Management Professional (PMP)

Gurushankar Thiyakarajan, India

Instructor's knowledge to deliver the training is the best one
VMware vSphere : Install, Configure, Manage [v6.5]

Ranganatha Mukunda, Live Online

The best thing about the program is - the way how the trainer explain the course it was perfect
VMware vSphere : Install, Configure, Manage [v6.5]

Charbel Ziade, Live Online

The best part about the program is Trainers friendly attitude to accommodate all my requests even when some of the requests were not in the course curriculum.
55242A: Microsoft Dynamics 365 Customization and Configuration Training Course

Kunal Waghmare, Gurgaon

The training was great and enjyable, I must recommand other to get training from this institution. The trainer was very skilled and experienced.
ECSA v9 (EC-Council Certified Security Analyst)

Em Pannah, Gurgaon

Good Course for the Security Professional
Certified Information Systems Security Professional

Shailesh Jain , Bangalore

The Training gave us all we needed
CISSP - Certified Information Systems Security Professional

Lokesh , Bangalore

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

Enquire now

-

INR 26702

USD 535

INR 28037

-

-

QUICK

INFORMATION

2 Day(s) Course

Official Courseware

Certified Trainer

Training

Customize Your Batch

1:1 Training Available on Demand

Course Information

COURSE OUTLINE

WHO SHOULD ATTEND

Pre-requisites

Exam

What Our Trainees Say