Oracle 12C New Features training course

Highlights

Course Overview

Oracle12C brings many new challenges for DBAs, developers and designers. Most notable for DBAs are multi-tenant databases. These offer many new approaches to handling the multitude of smaller, but interconnected application databases that sites have grown over many years. But 12C means cloud, and the essence of cloud computing means quick-to-respond, flexible and (probably) automated response to fast arriving new business needs applied to the database. Many 12C new features are designed to meet “cloud” practicalities. For example “online” movement of datafiles, tables, partitions and indexes with minimum disruption to end users - now aligned with data management PLSQL-based policies set up to recognise exactly the moment when such moves should take place.

Course Details

Management tools new features

SQL Developer DBA connections

Database Express

Cloud Control

SQL*plus new features (not many!)

Recovery Manager new features

Datapump view as tables export/import

Transportable tablespace new features

SQL*Loader Express Mode

Multi-tenant databases:

when to adopt,

how to set up (command line (little)) dbca,

how to populate

(dbca, dbexport, command line)

(moving non-cdbs to cdb)

basic administration

(command line, Database Express, SQL Developer DBA connections, Cloud control)

backing up and recovering,

taking AWR/ASH reports from

local vs root level culture/approaches/issues

Resource Manager share management

Oracle database architecture new features

Automatic Data Repository (ADR) DDL Logging

Temporary undo management

PGA aggregate limit approach

Smart Cache management new features

New background processes

New listener options

Optional Linux/Unix multi-threaded architecture

Extended data types

Security management new features:

Unified auditing approach

SYSBACKUP, SYSDG, SYSKM

Privilege behaviour analysis

Data redaction policy approach

Data management:

New advanced compression features

Moving data inline

Information Life Cycle policies

(Using heat map and Automatic Data Optimization)

Table and index new features

SQL new features:

Same column/multi index support

Identity columns

Extended string length support

Extended inline movement support for tables,partitions, indexes

Multi-partition management (e.g. mult-partition split, merge,move )

Partition table partial index coverage

PL/SQL integration with SQL (extension to WITH)

DBMS Redefinition new features

Hybrid and Top Frequency histograms

Performance management:

Taking AWR and ASH reports

Resource Manager new features for PDB and non PDB

In-database archiving

Temporal Validity vs Temporal History

Optimizer plan management new features

(including adaptive plans (dynamic and plan reoptimization)

Working with adaptive cursor new features

Working with SQL Plan baselines new features

New graphical tool support for AWR, ASH, ADDM

Improved quality ADDM analysis

( Hybrid and Top Frequency histograms )

SQL Directives

Who should attend

This course is designed for Oracle DBAs and other support staff

Feedback

4.8 out of 5 average

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022

“JBI did a great job of customizing their syllabus to suit our business needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and the Instructor handled this particularly well - very impressive”

Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022

Certification

Every delegate will be entitled to a certificate of achievement on completion of the course.

If you are missing your certificate - please use the link below to apply - you can also use this link to sign up for the JBI Training newsletter to receive technology tips directly from our instructors - Analytics, AI, ML, DevOps, Web, Backend and Security.

More about this course

FAQs

JBI Training offers twelve Oracle database courses. These include Oracle SQL Foundation (three days), Oracle SQL Advanced (four days), Oracle PL/SQL Foundation (three days), Oracle PL/SQL and Packages (five days), Oracle DBA Part 1 (five days), Oracle DBA Part 2 (three days), Oracle Admin Essentials (three days), Oracle Performance Tuning (three days), Oracle AWR Usage (three days), Oracle Backup and Recovery Essentials (two days), Oracle GoldenGate Essentials (three days), and Oracle 12c New Features (five days). All are available in London, online, or as customised onsite programmes.

Oracle SQL Foundation is a three-day course for professionals new to Oracle SQL, covering core querying, filtering, sorting, joins, aggregations, subqueries, and DML statements for inserting, updating, and deleting data. Oracle SQL Advanced is a four-day course for those with existing Oracle SQL experience who want to go deeper — covering advanced query techniques, analytical functions, hierarchical queries, XML and JSON handling in Oracle, performance considerations for SQL queries, and advanced features of the Oracle SQL dialect. Delegates should have solid SQL Foundation-level experience before attending the Advanced course.

PL/SQL (Procedural Language/SQL) is Oracle's proprietary procedural extension to SQL, used to write stored procedures, functions, triggers, and packages that run directly within the Oracle database. JBI offers two PL/SQL courses. Oracle PL/SQL Foundation (three days) covers the PL/SQL block structure, variables and data types, control flow, cursors, exception handling, and creating stored procedures and functions. Oracle PL/SQL and Packages (five days) extends this to cover packages, triggers, dynamic SQL, collections, bulk processing, advanced exception handling, and performance optimisation of PL/SQL code. Both courses are suited to Oracle developers and database programmers.

Oracle GoldenGate is a high-performance data replication and integration platform used to capture, transform, and deliver data changes between databases in real time — supporting use cases including zero-downtime migrations, high availability, disaster recovery, and real-time data integration between Oracle and heterogeneous database environments. JBI's three-day Oracle GoldenGate Essentials course covers the GoldenGate architecture, configuring Extract and Replicat processes, managing trails and checkpoints, monitoring and troubleshooting replication, and applying GoldenGate to common enterprise scenarios. It is suited to Oracle DBAs, data engineers, and integration architects working in environments where real-time data replication is required.

The three-day Oracle Performance Tuning course covers the techniques and tools used to identify and resolve performance problems in Oracle database environments. Topics include understanding the Oracle architecture from a performance perspective, using Explain Plan and SQL trace to analyse query execution, tuning SQL queries for optimal execution plans, using Oracle's Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for performance analysis, index design and management, memory configuration tuning, and I/O optimisation. It is suited to Oracle DBAs, senior developers, and database architects who are responsible for the performance and scalability of Oracle database systems in production environments.

Oracle DBA Part 1 is a five-day comprehensive foundation for Oracle database administration, covering Oracle architecture, installation and configuration, managing tablespaces and datafiles, user management and security, backup and recovery using RMAN, network configuration, and routine DBA operational tasks. Oracle DBA Part 2 is a three-day advanced programme for DBAs who have completed Part 1 or have equivalent experience, covering more complex administration topics including advanced backup and recovery strategies, Flashback technology, resource management, performance monitoring, and managing Oracle in more complex multi-tier environments. Together the two programmes provide a thorough, practical grounding in professional Oracle database administration.

Yes. All Oracle courses at JBI can be delivered as customised onsite or online programmes for corporate Oracle database teams. Content can be tailored to the team's Oracle version, existing environment, specific performance challenges, or DBA responsibilities. For example, a team managing Oracle in a high-availability environment can receive training focused on GoldenGate, backup and recovery, and performance tuning, while a development team building Oracle-backed applications can receive an integrated SQL and PL/SQL programme. JBI has delivered Oracle database training for teams at organisations including the BBC, NHS, RBS, Sky, EDF, and Cisco.

Upgrade Your Oracle Skills to 12c- Enhance Your Database Administration & Development Productivity

Public Courses

Customised Courses

Highlights

Course Overview

Course Details

Management tools new features

Multi-tenant databases:

Oracle database architecture new features

Security management new features:

Data management:

SQL new features:

Performance management:

Who should attend

Feedback

4.8 out of 5 average

Certification

More about this course

FAQs

Highlights

Course Overview

Course Details

Management tools new features

Multi-tenant databases:

Oracle database architecture new features

Security management new features:

Data management:

SQL new features:

Performance management:

Who should attend

Feedback

4.8 out of 5 average

Certification

More about this course

FAQs

What Oracle training courses does JBI Training offer?

What is the difference between Oracle SQL Foundation and Oracle SQL Advanced?

What is PL/SQL and what do the PL/SQL courses cover?

What is Oracle GoldenGate and what does the GoldenGate Essentials course cover?

What does Oracle Performance Tuning cover and who should attend?

What is covered across the Oracle DBA Part 1 and Part 2 courses?

Can Oracle training be customised for a corporate database team?

Email this page to yourself