Oracle 12c New Features
Duration
12
hours
Location
Online
Language
English
Code
DB-022
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
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