Oracle Grid Infrastructure 11g: Clusterware Workshop (ORA6)

Databases, Oracle

Location, current course term

Contact us

Custom Customized Training (date, location, content, duration)

The course:

Hide detail
  • SQL Row Limiting Clause
  • Invisible and Hidden Columns
  • Enhanced DDL capabilities using ONLINE keyword
  • Additional features in SQL Language
  • Increased Length Limits of Data Types
  • Using SQL IDENTITY Column
  • SQL Column enhancements
  • ANYDATA type Enhancements
  • GATEWAY Enhancements
  • What is a White List?
  • Granting Roles to PL/SQL packages and standalone stored subprograms
  • PL/SQL functions that run faster in SQL
  • Additional PL/SQL 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
Recommended previous course:
Oracle Database - Programming in PL/SQL (ORA5)
Schedule:
2 days (9:00 AM - 5:00 PM )
Language: