Oracle Database 12c New Features Seminar

GB Direct

Course

In London

£ 425 + VAT

The best Oracle courses

See all

See all

Description

  • Type

    Course

  • Location

    London

This Oracle Database 12c New Features Seminar is designed to give delegates an appreciation of the new features available in Oracle Database 12c and of how these features may affect current Oracle installations.

Facilities

Location

Start date

London
See map
Clerks Court 18-20 Farringdon Lane Clerkenwell, EC1R 3AU

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • IT
  • Database training
  • Database

Course programme

Overview of Oracle Database 12c Architecture

  • Oracle Database 12c Architecture
  • An Overview of Multitenant Architecture
  • The Benefits of Multitenant Architecture
  • Container Databases
  • Pluggable Databases
  • CDB_xxx Views

Install and Upgrade to Oracle Database 12c

  • Install Oracle Database 12c using OUI
  • Create a Database using dbca
  • Configuration and Creation of a Container Database (CDB)
  • Creation of a New Pluggable Database (PDB)
  • Plug in an Unplugged PDB
  • Upgrade to Oracle Database 12c
  • Pre-Upgrade Script
  • Parallel Upgrade Utility
  • Deprecated Features
  • Deprecated Parameters

New Management Features

  • Enterprise Manager Cloud Control
  • Enterprise Manager Express
  • SQL Developer New Functionality
  • Restricting PGA Size
  • Extended Data Types
  • Temporary Undo
  • DDL Logging
  • Online Rename and Relocation of an Active Datafile
  • Table Partition Maintenance Enhancements

Database Security Enhancements

  • Limitations to RESOURCE and SELECT ANY DICTIONARY Privileges
  • Separation of Duties
  • Privilege Analysis
  • Enhanced Audit Trail Security
  • Code Based Access Control
  • Invoker's Rights
  • Data Redaction
  • Encryption Enhancements

Schema Management New Features

  • Identity Columns
  • Invisible Columns
  • Default Values for Table Columns
  • In Database Row Archiving
  • Truncate Table Cascade
  • Session Level Sequences
  • New PL/SQL Commands

SQL and PL/SQL New Features

  • SQL*Plus Enhancements
  • Last Login Time
  • Pluggable Database Support
  • Row Limiting for Top-N Result Queries
  • PL/SQL Enhancements
  • Implicit Results on SQL*Plus
  • WITH Clause Enhancements

See related categories

Oracle Database 12c New Features Seminar

£ 425 + VAT

The best Oracle courses

See all

See all