Oracle 12c Release 1 – New Features for Administrators Training

 

 

Oracle 12c Release 1 – New Features for Administrators – 3 Days

Course Description – Oracle 12c Release 1, New Features for Administrators

This Oracle 12c Release 1 – New Features for Administrators course provides a complete, hands-on introduction to the newest release of Oracle Enterprise Edition. Key features of the product are discussed and demonstrated with a reduced emphasis on multitenant architecture.

Intended Audience

This course is appropriate for anyone needing to learn key new features of Oracle12c. That would include end users, business analysts, application developers, database administrators and IT management.

Prerequisites

A thorough knowledge of Oracle11g database administration is required. It is also highly desirable participants be well versed in Oracle11g PL/SQL.

Outline

  • SQL Enhancements
    • Major Enhancements
      • Top N and Bottom N Queries
      • Using Extended Datatypes
      • Concurrent UNION / UNION ALL Execution
      • Sequences with DEFAULT Values
      • Sequences with Global Temporary Tables
      • IDENTITY Columns
      • New Sequence Functionality for Oracle Replay
      • Invisible Columns
      • Temporal Validity
      • Pattern Matching
    • Miscellaneous New SQL Features
    • Data Model Review
    • Lab One – SQL Enhancements
    • Lab One Solutions – SQL Enhancements

 

  • PL/SQL Enhancements
    • White Lists
    • The WITH Clause for Functions
    • Pragma UDF
    • New Inquiry Directives
    • New DBMS_SQL Functionality
    • Enhanced Language Interface Features
    • Miscellaneous New PL/SQL Features for Oracle12c
    • Lab Two – PL/SQL Enhancements
    • Lab Two Solutions – PL/SQL Enhancements

 

  • Installation / Upgrading
    • Overview of Database Creation
    • The Oracle Universal Installer
    • Prerequisite Tasks
      • Memory Requirements
      • Hardware Requirements
      • Software Requirements
      • Package Requirements
      • What About Windows?
    • Running the Installer
    • Post Installation
    • Using the Database Configuration Assistant
    • Using the Database Configuration Assistant – Short Form
    • Database Templates
    • Upgrading the Database
    • Removing Oracle Software
    • Lab Three – Installation / Upgrading
    • Lab Three Solutions – Installation / Upgrading

 

  • Enterprise Manager Enhancements
    • Database Management Using EMDE
    • Environmental Variables
    • Accessing Enterprise Manager Database Express
      • Modified Functionality with EMDE Changing Parameters
      • Modification of Physical Structures
    • Deleted Functionality In EMDE
    • Database Administration with Other Tools
    • EMDE Access for Non-DBA Users
    • EMDE Access to Pluggable Databases
    • Lab Four – Enterprise Manager Enhancements
    • Lab Four Solutions – Enterprise Manager Enhancements

  • SQL Developer / SQL*PLUS
    • SQL Developer
    • Multitenant Connection Considerations
    • Using SQL Developer
    • SQL*PLUS for Oracle12c
      • Invisible Columns
      • New SHOW Commands
      • Last Login Time
      • Support for The New Administrative Privileges
      • Support for Pluggable Databases
    • Lab Five – SQL Developer / SQL*PLUS
    • Lab Five SOLUTIONS – SQL Developer / SQL*PLUS

 

  • Multitenant Databases
    • The Impact of Multitenant Architecture
    • Major Benefits of Multitenant Architecture
    • The Bird’s Eye View
    • Walking the Directories Of A Container Database
    • Who? What? When? Where? How?
    • Impacts of Multitenant Architecture
    • Tools for Use With Multitenant Architecture
      • SQL*Plus
      • DBCA
      • Oracle Enterprise Manager Cloud Control
      • SQL Developer
      • Server Control (SRVCTL)
    • Lab Six – Multitenant Databases
    • Lab Six Solutions – Multitenant Databases

 

  • Multitenant Basics
    • Creating CDBS
    • Features Unsupported for Multitenant Architecture
    • The Create Database Command
    • Seed Data Files
    • Configuring Enterprise Manager Database Express for CDBS
    • Using SQL Developer with CDBS as a Dba
    • Lab Seven – Multitenant Basics
    • Lab Seven Solutions – Multitenant Basics

 

  • Intermediate Multitenant
    • Options Available
    • The Create Pluggable Database Statement
      • The STORAGE Clause
      • File Locations Clause
      • TEMPFILE Clause
    • Preparing to Create PDBS
    • Creating PDBS Using the CDB Seed
      • Specifics Using SQL*Plus
    • Cloning an Existing Local PDB
      • Specific Cloning Steps
    • Cloning an Existing Remote PDB
      • Specific Cloning Steps
      • Effects of Cloning a Remote PDB
    • Unplugging a PDB
    • Creating a PDB By Plugging-In an Unplugged PDB
    • Creating a PDB From A NON-CDB Database
      • Using DBMS_PDB
    • New Trigger Types For PDBS
      • The BEFORE UNPLUG Trigger
      • The AFTER CLONE Trigger
    • Lab Eight – Intermediate Multitenant
    • Lab Eight Solutions – Intermediate Multitenant

 

  • Automatic Data Optimization
    • Storage and Compression Tiering
    • The Heat Map
    • Automatic Data Optimization
    • Compression Levels

 

  • In-Database Archiving
    • To Keep or Not To Keep
    • The Row Archival Clause
    • ORA_ARCHIVE_STATE
    • Row Archival Visibility
    • Lab Nine – In-Database Archiving
    • Lab Nine Solutions – In-Database Archiving

 

  • Auditing Enhancements
    • Unified Auditing
    • Enabling Unified Auditing
    • Disabling Unified Auditing
    • Handling Earlier Audit Records
    • Creating A SEC_ADMIN Account
    • Creating A Unified Audit Policy
    • Automatic Audits with Unified Auditing
    • Disabling / Dropping Audit Policies
    • Immediate-Write vs. Queued-Write Mode
    • Audit Data Cleanup
    • Lab 10 – Auditing Enhancements
    • Lab 10 Solutions – Auditing Enhancements

 

  • Privilege Enhancements
    • Considerations Regarding Password Case Sensitivity
    • Profiles and Password Policies
    • Roles in Oracle12c
    • Separation of Duty
    • Inherit [ ANY ] Privileges
    • Permission Control Within Views
    • Database Privilege Analysis
      • Restrictions on Privilege Analysis
      • Potential Benefits of Privilege Analysis
      • Privilege Analysis in Container Databases
      • Privilege Analysis Policies
      • Disabling A Privilege Analysis Policy
      • Generating A Privilege Analysis Report
      • Dropping A Privilege Analysis Policy
    • Significant Changes to Roles and Privileges
    • Lab 11 – Privilege Enhancements
    • Lab 11 Solutions – Privilege Enhancements

 

  • Data Redaction
    • Overview of Data Redaction
    • Exemption from Redaction Policies
    • How and When Redaction Occurs
    • Redaction Examples
    • FUNCTION_PARAMETERS for Partial Redaction
    • Using Regular Expressions
    • Using Random Values in Redaction
    • The Expression Parameter
    • ENABLE / DISABLE / DROP Redaction Policies
    • Using RES for Partial VARCHAR2 Redactions
    • REDACTION_POLICIES / REDACTION_COLUMNS
    • Lab 12 – Data Redaction
    • Lab 12 Solutions – Data Redaction

 

  • RMAN / FDA Enhancements
    • New Backup Super User
    • RMAN Connections
    • Select and Describe from within RMAN
    • Simpler SQL Commands
    • Duplicate with NOOPEN
    • Cross-Platform Backup and Restore
    • Recovery Over a Network
    • Storage Snapshot Technology
    • Table and Partition Recovery
    • Multi-Section Backups on Very Large Files
    • Active Database Duplication Enhancements
    • Tablespace Transports Across Platforms and Endianness
      • Convert at Source
      • Restore from Converted at Source
      • Convert at Target
      • Restore from Converted at Target
    • Standby Database Updating
    • Data Guard Enhancements
    • Oracle Scheduler Script Jobs
    • Lab 13 – RMAN / FDA Enhancements
    • Lab 13 Solutions – RMAN / FDA Enhancements

 

  • DB Operations
    • Database Operations
    • Do Monitoring Use Cases
    • Enabling Database Operations Monitoring
    • Db Operations Monitoring Architecture Overview
    • Do Attributes
    • Using DBMS_SQL_MONITOR
      • BEGIN_OPERATION Function
      • END_OPERATION Procedure
      • REPORT_SQL_MONITOR Function
    • Simple Database Operations Monitoring Example
    • The Active Report Type
    • New Optimizer Hints
    • Lab 14 – DB Operations
    • Lab 14 Solutions – DB Operations

 

  • Schema and Data Changes
    • Database Changes
    • Change Management Capabilities
    • The DBMS_COMPARISON Package
    • The Create Comparison Procedure
    • The Compare Function
    • Discovering Differences
    • The Converge Procedure
    • The Recheck Function
    • The DBA_COMPARISON_COLUMNS View
    • Lab 15 – Schema and Data Changes
    • Lab 15 Solutions – Schema and Data Changes

 

  • SQL Tuning
    • Adaptive Execution Plans
    • DBMS_XPLAN And Adaptive Execution Plans
    • SQL Plan Directives / Extended Statistics
    • Enhanced Statistics Gathering
    • Histogram Enhancements
    • Lab 16 – SQL Tuning
    • Lab 16 Solutions – SQL Tuning

 

  • Real-Time ADDM / Performance
    • The Automatic Database Diagnostic Monitor
    • Real-Time ADDM
    • Emergency Monitoring / Current ADDM Findings
    • Monitoring the Database with EMDE
    • Using the Performance Hub
      • The Summary Tab
      • The RAC Tab
      • The Activity Tab
      • The Workload Tab
      • The Monitored SQL Tab
      • The ADDM Tab
      • The Current ADDM Findings Tab
      • The Database Time Tab
      • The Resources Tab
      • The System Statistics Tab
      • Workload Repository Reports
      • Modifying Automatic Snapshot Settings
    • Using Other Advisors
      • SQL Tuning Advisor Details
      • The Automatic SQL Tuning Advisor
      • SQL Access Advisor
    • Database Replay
    • Workload Intelligence Overview
    • Workload Dimensions
    • Reports
    • SECUREFILES
    • PGA_AGGREGATE_LIMIT
    • Real Application Testing
    • Patch Inventory Package
    • Statistics Enhancements
      • Automatic Column Group Detection
      • Concurrent Statistics Gathering
      • Incremental Statistics Enhancements
      • Global Temporary Tables Session-Private Statistics
      • Reporting Mode
      • Past Statistics Collection Reports
    • Lab 17 – Real-Time ADDM / Performance
    • Lab 17 Solutions – Real-Time ADDM / Performance

 

  • Table / Index Enhancements
    • Creating Multiple Indexes on Columns
    • Advanced Row Compression
    • Online Redefinition Enhancements
    • DML_LOCK_TIMEOUT
    • Editioning Enhancements

 

  • ADR / Network Enhancements
    • ADR Directory Structure
    • ADR Command Interpreter Enhancements
    • Advanced Network Compression
    • Multiprocess / Multithreaded Architecture
    • Very Large Network Buffers

 

  • Data Loading Enhancements
    • Data Pump Enhancements
      • Data Pump VIEWS_AS_TABLES
      • Transform Clause Enhancements
      • New Parameters
    • Log Miner Enhancements
    • Full Transportable Export / Import
    • SQL*LOADER Enhancements
      • SQL*Loader Express Mode
      • SQL*Loader Enhancements
      • SQL*Loader / External Table Common Enhancements
    • Partitioning Enhancements
      • Moving Partitions Online
      • Interval-Reference Partitioning
      • Enhanced Cascade Functionality
      • Operating on Multiple Partitions
      • Partial Indexes
      • Global Index Maintenance
      • Controlling Statistics Gathering for Partitions

 

  • New Features In 12.1.0.2 – Time Permitting
    • About 12.1.0.2
    • Advanced Index Compression
    • APPROX_COUNT_DISTINCT
    • Attribute Clustering
    • Big Table Caching
    • Flashback Data Archive Support for CDBS
    • Full Database Caching
    • In-Memory Aggregation
    • In-Memory Column Store
      • Working with Tables
      • Working with Columns
      • Working with Tablespaces
      • Working with Materialized Views
      • Data Pump and INMEMORY
    • Support for JSON
    • Fips 140 Encryption Parameter
    • PDB Containers Clause in Queries
    • OMF File Replacement for PDBS
    • The PDB Logging Clause
    • PDB Metadata Clones
    • PDB Remote Clones
    • Platform Support for PDB Snapshot Cloning
    • The PDB Standbys Clause
    • State Management for PDBS Across PDB Restart
    • PDB Subset Cloning
    • Rapid Home Provisioning
    • Zone Maps

 

  • Deprecations and Desupports – Time Permitting
    • Deprecated Features
    • Desupported Features
    • Deprecated Parameters
      • Networking
      • Database
    • Deprecated Views

Other courses to explore:

Oracle 12c Release 1 DBA I – Onsite, Custom, Lowest Price

Data Modeling: Logical Database Design – Onsite, Custom

Oracle 12c Release 1 PL/SQL Development – Onsite, Custom

Don’t forget to check out our monthly specials to save – Monthly Specials

MndIQ.com

Print Friendly, PDF & Email