- Duration: 10 weeks
Categories: Oracle
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
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
Oracle Cloud Overview
- Introduction to Oracle Cloud & Oracle Cloud Services
- Cloud Deployment Models
- Evolving from On-premises to Exadata Express
- What is in Exadata Express?
- Exadata Express for Users & Developers
- Oracle Exadata Express Cloud Service
- Getting Started with Exadata Express
- Service Console & Web Access through Service Console
Leave feedback about this
You must be logged in to post a comment.