Oracle Database 12c SQL and PL/SQL New Features 1.0 Training & Placements in Chennai SQL STAR

Oracle Database SQL and PL/SQL New Features Ed 1
(Course materials and Course Completion Certificates are directly delivered from Oracle University to those required for Foreign Opportunity)

(Government of India Approved Education Center)

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.
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.
• Takeadvantage of the invisible and hidden columns.
• Makeuse of the IDENTITY column to automatically generate the numbercolumn.
• Utilizethe ACCESSIBLE BY clause to create a white list of PL/SQL units.
• Grantroles to PL/SQL packages and standalone stored procedures.
• Understand Synchronous Materialized Views.
• Identifyways 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.
Prerequisites
Suggested Prerequisite

• Knowledgeof Oracle Database, Structured Query Language(SQL), Basicprogramming concepts such as IF-THEN statements, loops,procedures, and functions

Audience

• Application Developers
• Database Administrators
• Database Administrators
• System Analysts
• System Analysts
• System Analysts
• ProjectManager
• ProjectManager

Course Objectives

• CreateInvisible and Hidden columns in a table
• Understandenhanced DDL capabilities using ONLINE keyword
• Identifyadditional new features available in SQL Language
• Identifythe increased length limits of data types
• Configuredatabase for extended data type
• Understand SQL IDENTITY column
• IdentifySQL Column enhancements defaulting on explicit NULL and using asequence
• Identifyadditional feature available in Data Types such as ANYDATA, andGATEWAY
• Understandfine grained access controls for packaged procedures
• Define invoker's rights function that can be result cached
• ImplementACCESSIBLE BY clause
• Grantroles to PL/SQL packages and standalone stored subprograms
• IdentifyPL/SQL functions that can run faster in SQL
• MaintainMultiple Partitions
• UseFETCH clause in SQL queries
• Gain an understanding of the Oracle Database Exadata Express Cloud Service

Course Topics
Course Introduction

• CourseAgenda
• Reviewthe Oracle Database 12c SQL and PL/SQL document ation andadditional resources
• Overview of SQL Developer 4.0
• Course Objectives
• Schemesused in this course
• Classroomaccount information

SQL Language Enhancements

• SQLRow Limiting Clause
• EnhancedDDL capabilities using ONLINE keyword
• Invisibleand Hidden Columns
• Additionalfeatures in SQL Language

Data Types Enhancements

• Using SQL IDENTITY Column
• IncreasedLength Limits of Data Types
• ANYDATAtype Enhancements
• SQLColumn enhancements
• GATEWAYEnhancements

PL/SQL Enhancements

• AdditionalPL/SQL Enhancements
• Whatis a White List?
• PL/SQLfunctions that run faster in SQL
• Granting Roles to PL/SQL packages and standalone stored subprograms
• Understanding Invoker's right and Define r's right

Data Warehousing Enhancements

• Multipartition maintenance operations
• Improving Query Performance Against OLAP Cubes
• Review of partitioned indexes
• Overview of Synchronous Materialized View Refresh
• SQLfor Pattern Matching

Oracle Cloud Overview

• Whatis in Exadata Express?
• Evolving from On-premises to Exadata Express
• CloudDeployment Models
• OracleExadata Express Cloud Service
• Introduction to Oracle Cloud & Oracle Cloud Services
• ExadataExpress for Users & Developers
• Getting Started with Exadata Express
• ServiceConsole & Web Access through Service Console