LIVE Instructor-Led Courses
Dismiss

Oracle 12c New Features training course

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

JBI training course London UK

"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

Public Courses

22/04/24 - 5 days
£1995 +VAT
03/06/24 - 5 days
£1995 +VAT
15/07/24 - 5 days
£1995 +VAT

Customised Courses

* Train a team
* Tailor content
* Flex dates
From £1200 / day
EDF logo Capita logo Sky logo NHS logo RBS logo BBC logo CISCO logo
JBI training course London UK

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.

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

 

JBI training course London UK

This course is designed for Oracle DBAs and other support staff

5 star

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

 

 

JBI training course London UK

Newsletter

 

Sign up for the JBI Training newsletter to stay updated with world-class technology training opportunities, including Analytics, AI, ML, DevOps, Web, Backend and Security. Our Power BI Training Course is especially popular.  Gain new skills, useful tips, and validate your expertise with an industry-leading organisation, all tailored to your schedule and learning preferences.



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.

CONTACT
+44 (0)20 8446 7555

[email protected]

SHARE

 

Copyright © 2023 JBI Training. All Rights Reserved.
JB International Training Ltd  -  Company Registration Number: 08458005
Registered Address: Wohl Enterprise Hub, 2B Redbourne Avenue, London, N3 2BS

Modern Slavery Statement & Corporate Policies | Terms & Conditions | Contact Us

POPULAR

Rust training course                                                                          React training course

Threat modelling training course   Python for data analysts training course

Power BI training course                                   Machine Learning training course

Spring Boot Microservices training course              Terraform training course

Kubernetes training course                                                            C++ training course

Power Automate training course                               Clean Code training course