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.

12 hours
English
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

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

Related courses

This advanced course dives into the extended capabilities of Oracle PL/SQL for database interaction, optimized code, and secure application design. It covers dynamic SQL, PL/SQL collections, fine-grained access control, and performance tuning. Oracle SQL Developer will be used for hands-on development.