EXCEPTIONAL TRAINING COURSES FOR IT PROFESSIONALS
LONDON UK | ONSITE | ONLINE


Oracle 12c New Features Training Course


Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

Oracle 12c New Features training course (code: ORAC12CNEW)

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


SEE MORE COURSES IN THIS CATEGORY

TRAINING 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.


AUDIENCE

This course is designed for Oracle DBAs and other support staff



DETAILHIGHLIGHTS

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

 

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.

Receive the latest version of this course into your inbox


See why people choose JBI

"At jbi even the sales team are technical so you are able to ask questions before the course"

Garima Aon

Call our Tech Team :  0800 028 6400  request info



PUBLIC COURSES (LONDON, UK)
 

4th Dec 2017 - 5 days £1995, 3 days for upgrade or 5 days to include Performance/Tuning
Book

see all dates


X

Show Discount for this course



PRIVATE COURSES


  Bring a JBI course to your office
  and train a whole team onsite
  0800 028 6400
or request quote


  You can customise this course to
  suit your exact needs here
  0800 028 6400 or request quote


 

 

 

 

Get in touch
0800 028 6400




 

 

view all case studies

 

 

Our inspiring and up-to-date courses gain exceptional feedback

►"great tips to help reduce build times"
► "we got access to exclusive content"
► "intensive course meant less time off"

►"what an inspiring trainer !"
► "colleagues at 2 sites joined via web"
► "I passed my exam the next day"

Newsletter ! Get exclusive news about upcoming programs, technical insights & special offers