Oracle 12c New Features

This training covers the new features in Oracle versions 12.1.0.1, 12.1.0.2 that are useful for developers: pluggable databases and containers, partitioning, indexing, flashback enhancements, new SQL and PL/SQL features.
  • duration 12 hours
  • Language English
  • format Online
duration
12 hours
location
Online
Language
English
Code
DB-022
price
€ 240 *
Available sessions

To be determined

Training for 7-8 or more people?
Customize trainings for your specific needs

Description

This training covers the new features in Oracle versions 12.1.0.1, 12.1.0.2 that are useful for developers: pluggable databases and containers, partitioning, indexing, flashback enhancements, new SQL and PL/SQL features.
After completing the course, a certificate is issued on the Luxoft Training form

Objectives

  • Learn new tools and features provided by new Oracle version
  • Try using new features with practical exercises
  • Consider pitfalls related to new functionality

Target Audience

  • Database Administrators
  • Developers
  • System Analysts
  • Database Architects

Roadmap

  • Multitenant Architecture
  • Online data file maintenance
  • Partitioning maintenance improvements
  • Statistics improvements
  • Invisible columns
  • Indexes improvements
  • Data Reduction
  • PL/SQL support in WITH clause, pragma UDF
  • SQL Text Expansion
  • New package UTL_CALL_STACK
  • Implicit Statement result
  • Native DDL logging
  • Identity and sequences in Default
  • SQL Enhancements
  • Row limiting clause
  • PL/SQL enhancements (result cache, accessible by, datatypes, etc.)
  • Temporary tables, temp segment
  • Pattern Matching
  • Flashback Data Archive (11gR2 and 12.1.0.1 new features)
  • 12.1.0.2 patch fixes and new features

Discover more about professional growth and skills development

contact us