Oracle Database SQL and PL/SQL New Features Ed 1 Training

Live Online & Classroom Enterprise Certification Training

The Oracle Database 12c: SQL and PL/SQL New Features training introduces you to the new features available in Oracle Database 12c. 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.

Looking for a private batch ?

REQUEST A CALLBACK

Certified Trainer
Authorized Courseware
Completion Certificate from ATP

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is SQL and PL/SQL New Features Ed 1 Certification Training about?

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.

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.

What are the objectives of SQL and PL/SQL New Features Ed 1 Certification Training ?

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

Who is SQL and PL/SQL New Features Ed 1 Certification Training for?

Application Developers
Database Administrators
System Analysts
Project Manager

What are the prerequisites for SQL and PL/SQL New Features Ed 1 Certification Training?

Suggested Prerequisite

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

Available Training Modes

Live Online Training

11 Hours

Classroom Training

2 Days

Course Outline Expand All

Expand All

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

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

SQL and PL/SQL New Features Ed 1 Certification Training - Certification & Exam

SpringPeople is the Authorized Training Partner of Oracle.
The training fees is exclusive of exam cost.
For any queries; feel free to reach us at oracle@springpeople.com

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree