English French German Italian Portuguese Russian Spanish

logo_old

  • Database Training

    databaseInterSource offers live instructor-led courses on all important database programming technologies, including Crystal Reports, Microsoft Access, MySQL, Oracle, SQL, SQL Server, SSAS, SSIS, SSRS and Xcelsius.

    These live classes are offered both on client sites, at our Geneva training center, and via a Web interface.

  • About Database

    A database is a collection of data stored and maintained for one or more uses. Most modern databases are managed by a Database Management System (DBMS), a set of computer programs that controls the creation, maintenance, and the use of the database with computer as a platform or of an organization and its end users. It allows organizations to place control of organization-wide database development in the hands of database administrators (DBAs) and other specialists.

    The proper integration of databases can dramatically increase the functionality of all types of applications, whether or not Web-enabled.


    Read More
  • Course Details Database

    Classes are offered at client sites, at our Geneva training center, and via a live web conference. For detailed course outlines and scheduled classes, please see below.

    To book training, navigate to the course you need, then:

    • For scheduled online classes, register from the choices indicated.
    • If you need an alternative dates, time or location, or if you want a live classroom course, click on “request an offer for this course,” to complete the form.

    InterSource clients are active globally. Live web courses run during Eastern Standard Time (New York) business hours and are priced in US dollars.

    We also run live web conference classes during European business hours, which can be invoiced in local currencies. To discuss your requirements please contact us on +41 (22) 958 0114.

Oracle 12c New Features for Administrators

 PDF PrintEmail

Course duration

  • 5 Days

Course Outline

This Oracle 12c New Features for Administrators training class provides a complete, hands-on introduction to the newest release of Oracle Enterprise Edition. Key features of this product are fully discussed and demonstrated.

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.

  • Master the new features of Oracle 12c.
  • A thorough knowledge of Oracle11g database administration.
  • Familiarity with Oracle11g PL/SQL.
  1. SQL Enhancements
    1. Major Enhancements
      1. Top N and Bottom N Queries
      2. Using Extended Datatypes
      3. Concurrent UNION / UNION ALL Execution
      4. Sequences with DEFAULT Values
      5. Sequences with Global Temporary Tables
      6. Identity Columns
      7. New Sequence Functionality for Oracle Replay
      8. Invisible Columns
      9. Temporal Validity
      10. Pattern Matching
    2. Miscellaneous New SQL Features
    3. Data Model Review
    4. Lab 1: SQL Enhancements
    5. Lab 1 Solutions: SQL Enhancements
  2. PL/SQL Enhancements
    1. White Lists
    2. The WITH Clause for Functions
    3. PRAGMA UDF
    4. New Inquiry Directives
    5. New DBMS_SQL Functionality
    6. Enhanced Language Interface Features
    7. Miscellaneous New PL/SQL Features for Oracle 12c
    8. LAB 2: PL/SQL Enhancements
    9. LAB 2 Solutions: PL/SQL Enhancements
  3. Installation / Upgrading
    1. Overview of Database Creation
    2. THE Oracle Universal Installer
    3. Prerequisite Tasks
      1. Memory Requirements
      2. Hardware Requirements
      3. Software Requirements
      4. Package Requirements
      5. What About Windows?
    4. Running the Installer
    5. Post Installation
    6. Using the Database Configuration Assistant
    7. Using the Database Configuration Assistant – Short FORM
    8. Database Templates
    9. Upgrading the Database
    10. Removing Oracle Software
    11. Lab 3: Installation / Upgrading
    12. Lab 3 Solutions: Installation / Upgrading
  4. Enterprise Manager Enhancements
    1. Database Management Using EMDE
    2. Environmental Variables
    3. Accessing Enterprise Manager Database Express
    4. Modified Functionality with EMDE Changing Parameters
    5. Modification of Physical Structures
    6. Deleted Functionality in EMDE
    7. Database Administration with Other Tools
    8. EMDE Access for Non-DBA Users
    9. EMDE Access to Pluggable Databases
    10. Lab 4: Enterprise Manager Enhancements
    11. Lab 4 Solutions: Enterprise Manager Enhancements
  5. SQL Developer / SQL*PLUS
    1. SQL Developer
    2. Multitenant Connection Considerations
    3. Using SQL Developer
    4. SQL*PLUS for Oracle 12c
    5. Invisible Columns
    6. New SHOW Commands
    7. Last Login Time
    8. Support for The New Administrative Privileges
    9. Support for Pluggable Databases
    10. Lab 5: SQL Developer / SQL*PLUS
    11. Lab 5 Solutions: SQL Developer / SQL*PLUS
  6. Multitenant Databases
    1. The Impact of Multitenant Architecture
    2. Major Benefits of Multitenant Architecture
    3. The Bird's Eye View
    4. Walking the Directories of a Container Database
    5. Who? What? When? Where? How?
    6. Impacts of Multitenant Architecture
    7. Tools for Use with Multitenant Architecture
      1. SQL*Plus
      2. DBCA
      3. Oracle Enterprise Manager Cloud Control
      4. SQL Developer
      5. Server Control (SRVCTL)
    8. Lab 6: Multitenant Databases
    9. Lab 6 Solutions: Multitenant Databases
  7. Multitenant Basics
    1. Creating CDBS
    2. Features Unsupported for Multitenant Architecture
    3. The Create Database Command
    4. Seed Data Files
    5. Configuring Enterprise Manager Database Express for CDBS
    6. Using SQL Developer with CDBS as a DBA
    7. Lab 7: Multitenant Basics
    8. Lab 7 Solutions: Multitenant Basics
  8. Intermediate Multitenant
    1. Options Available
    2. The Create Pluggable Database Statement
      1. The STORAGE Clause
      2. File Locations Clause
      3. Temp File Clause
    3. Preparing to Create PDBS
    4. Creating PDBS Using the CDB Seed
      1. Specifics Using SQL*Plus
    5. Cloning an Existing Local PDB
      1. Specific Cloning Steps
    6. Cloning an Existing Remote PDB
      1. Specific Cloning Steps
      2. Effects Of Cloning a Remote PDB
    7. Unplugging a PDB
    8. Creating a PDB by Plugging in an Unplugged PDB
    9. Creating a PDB from a Non-CDB Database
    10. Using DBMS_PDB
    11. New Trigger Types for PDBS
      1. The BEFORE UNPLUG Trigger
      2. The AFTER CLONE Trigger
    12. Lab 8: Intermediate Multitenant
    13. Lab 8 Solutions: Intermediate Multitenant
  9. Advanced Multitenant
    1. Using Data Pump Export and Import
    2. Using EXP AND IMP
    3. Dropping PDBS
    4. Using Cloud Control to Create and Drop PDBS
    5. Administration Details
      1. Special Roles for CDBs
      2. Other Administrative Considerations for CDBs
      3. Manageability Considerations
      4. Objects in CDBs
      5. Services
      6. Sessions
      7. Common Listeners
      8. Connecting To PDBs in MOUNT Mode
      9. Login Triggers and the SET CONTAINER Clause
      10. Package States and Containers
      11. EXECUTE IMMEDIATE and SET CONTAINER
    6. Executing across All Pluggable Databases Using DBMS_SQL
    7. Logging Errors for multiple containers
    8. ALTER Database in a CDB
    9. Tablespaces in CDBS
    10. Using Force on PDBS
    11. Close VS. Close Immediate
    12. Specifying PDBS in Alter Pluggable Database
    13. Lab 9: Advanced Multitenant
    14. Lab 9 Solutions: Advanced Multitenant
  10. Ultimate Multitenant
    1. The Startup Command within PDBS
    2. Startup Pluggable Database
    3. Shutdown within PDBS
    4. Alter System Set Statements in CDBS
    5. The Container Clause in DDL Statements
    6. Running Scripts in All Containers
    7. automating TNSNAMES.ORA Maintenance
    8. Lab 10: Ultimate Multitenant
    9. Lab 10 Solutions: Ultimate Multitenant
  11. Multitenant Roundup
    1. Renaming a Pluggable Database
    2. Moving A PDB
    3. Building a Unified Parameter Query
    4. Lab 11: Multitenant Roundup
    5. Lab 11 Solutions: Multitenant Roundup
  12. Storage and Security
    1. New Super Users
    2. Enhanced Security for CDBS
    3. Temporary Tablespace Considerations for CDBS
    4. Hardening a CDB
    5. Storage Clauses Relevant to PDBS
    6. Alter System in a PDB
    7. Scope = SPFILE in PDBs
    8. Services and PDBs
    9. Views in CDBs
    10. CON_ID Details
    11. Other Interesting CDB Views
    12. CDB View Examples
    13. New Functions for Containers
    14. Triggers in a CDB
    15. Moving Datafiles Online
    16. Raw Partitions
    17. Database Smart Flash Cache Support
    18. Lab 12: Storage and Security
    19. Lab 12 Solutions: Storage and Security
  13. Backup and Recovery for CDBS
    1. Container Database Considerations
    2. Backup Setup
    3. Backing Up the Entire CDB
    4. Backing Up Just the Root Container
    5. Backing Up PDBS
    6. Backing Up TABLESPACES and Datafiles from within a PDB
    7. Executing RMAN across PDBS
    8. REDO LOG, Archive LOG and CONTROLFILE Backups in CDBS
    9. Complete Recovery of A CDB
    10. Complete Recovery of A PDB
    11. Complete Recovery of the Root Container
    12. Incomplete Recovery of the Entire CDB
    13. Incomplete Recovery of PDBS
    14. Loss OF System Tablespace in A PDB
    15. RMAN Restrictions in PDBS
    16. PRIOR Backups and Archivelogs for Converted Non-CDBS
    17. Flashback and CDBS
    18. Data Pump and CDBS
    19. Lab 13: Backup and Recovery for CDBS
    20. Lab 13 Solutions: Backup and Recovery for CDBS
  14. Automatic Data Optimization
    1. Storage and Compression Tiering
    2. The Heat Map
    3. Automatic Data Optimization
    4. Compression Levels
  15. In-Database Archiving
    1. To Keep or Not to Keep
    2. The Row Archival Clause
    3. ORA_ARCHIVE_STATE
    4. ROW Archival Visibility
    5. Lab 15: In-Database Archiving
    6. Lab 15 Solutions: In-Database Archiving
  16. Auditing Enhancements
    1. Unified Auditing
    2. Enabling Unified Auditing
    3. Disabling Unified Auditing
    4. Handling Earlier Audit Records
    5. Creating A SEC_ADMIN Account
    6. Creating a Unified Audit Policy
    7. Automatic Audits with Unified Auditing
    8. Disabling / Dropping Audit Policies
    9. Immediate-Write vs. Queued-Write Mode
    10. Audit Data Cleanup
    11. Lab 16: Auditing Enhancements
    12. Lab 17 Solutions: Auditing Enhancements
  17. Privilege Enhancements
    1. Considerations Regarding Password Case Sensitivity
    2. Profiles and Password Policies
    3. Roles in Oracle 12c
    4. Separation of Duty
    5. Inherit [ ANY ] Privileges
    6. Permission Control within Views
    7. Database Privilege Analysis
      1. Restrictions on Privilege Analysis
      2. Potential Benefits OF Privilege Analysis
      3. Privilege Analysis IN Container Databases
      4. Privilege Analysis Policies
      5. Disabling a Privilege Analysis Policy
      6. Generating a Privilege Analysis Report
      7. Dropping a Privilege Analysis Policy
    8. Significant Changes to Roles and Privileges
    9. Lab 17: Privilege Enhancements
    10. Lab 17 Solutions: Privilege Enhancements
  18. Data Redaction
    1. Overview OF Data Redaction
    2. Exemption from Redaction Policies
    3. How and When Redaction Occurs
    4. Redaction Examples
    5. Function_Parameters FOR Partial Redaction
    6. Using Regular Expressions
    7. Using Random Values in Redaction
    8. The Expression Parameter
    9. Enable / Disable / Drop Redaction Policies
    10. Using RES for Partial VARCHAR2 Redactions
    11. Redaction_Policies / Redaction_Columns
    12. Lab 18: Data Redaction
    13. Lab 18 Solutions: Data Redaction
  19. RMAN / FDA Enhancements
    1. New Backup Super User
    2. RMAN Connections
    3. Select and Describe from within RMAN
    4. Simpler SQL Commands
    5. Duplicate with NOOPEN
    6. Cross-Platform Backup and Restore
    7. Recovery over a Network
    8. Storage Snapshot Technology
    9. Table and Partition Recovery
    10. Multisection Backups on Very Large Files
    11. Active Database Duplication Enhancements
    12. Tablespace Transports across Platforms and Endianness
      1. Convert at Source
      2. Restore From Converted At Source
      3. Convert at Target
      4. Restore From Converted At Target
    13. Standby Database Updating
    14. Data Guard Enhancements
    15. Oracle Scheduler Script JOBS
    16. Lab 19: RMAN / FDA Enhancements
    17. LAB 19 Solutions: RMAN / FDA Enhancements
  20. DB Operations
    1. Database Operations
    2. Do Monitoring Use Cases
    3. Enabling Database Operations Monitoring
    4. DB Operations Monitoring Architecture Overview
    5. Do Attributes
    6. USING DBMS_SQL_MONITOR
      1. BEGIN_OPERATION Function
      2. END_OPERATION Procedure
      3. REPORT_SQL_MONITOR Function
      4. Simple Database Operations Monitoring Example
      5. The Active Report TYPE
    7. New Optimizer Hints
    8. Lab 20: DB Operations
    9. Lab 20 Solutions: DB Operations
  21. Schema and Data Changes
    1. Database Changes
    2. CHANGE Management Capabilities
    3. The DBMS_COMPARISON Package
    4. The Create Comparison Procedure
    5. The Compare Function
    6. Discovering Differences
    7. The Converge Procedure
    8. The Recheck Function
    9. The DBA_COMPARISON_COLUMNS View
    10. Lab 21: Schema and Data Changes
    11. Lab 21 Solutions: Schema and Data Changes
  22. SQL Tuning
    1. Adaptive Execution Plans
    2. DBMS_XPLAN and Adaptive Execution Plans
    3. SQL Plan Directives / Extended Statistics
    4. Enhanced Statistics Gathering
    5. Histogram Enhancements
    6. LAB 22: SQL Tuning
    7. Lab 22 Solutions: SQL Tuning
  23. Real-Time ADDM / PERFORMANCE
    1. The Automatic Database Diagnostic Monitor
    2. Real-Time ADDM
    3. Emergency Monitoring / Current ADDM Findings
    4. Monitoring THE Database with EMDE
    5. USING the Performance Hub
      1. The Summary Tab
      2. The RAC Tab
      3. The Activity Tab
      4. The Workload Tab
      5. The Monitored SQL Tab
      6. The ADDM Tab
      7. The Current ADDM Findings Tab
      8. The Database Time Tab
      9. The Resources Tab
      10. The System Statistics Tab
      11. Workload Repository Reports
      12. Modifying Automatic Snapshot Settings
    6. Using Other Advisors
      1. SQL Tuning Advisor Details
      2. The Automatic SQL Tuning Advisor
      3. SQL Access Advisor
    7. Database Replay
    8. Workload Intelligence Overview
    9. Workload Dimensions
    10. Reports
    11. SECUREFILES
    12. PGA_AGGREGATE_LIMIT
    13. Real Application Testing
    14. Patch Inventory Package
    15. Statistics Enhancements
      1. Automatic Column Group Detection
      2. Concurrent Statistics Gathering
      3. Incremental Statistics Enhancements
      4. Global Temporary Tables Session-Private Statistics
      5. Reporting Mode
      6. Past Statistics Collection Reports
    16. Lab 23: Real-Time ADDM / Performance
    17. Lab 23 Solutions: Real-Time ADDM / Performance
  24. Resource Manager for CDBS
    1. Resource Manager and CDBS
      1. CDB Resource Plans
      2. The Initial Default Directive Attributes for PDBs
      3. PDB Resource Plans
      4. Background and Administrative Tasks
      5. Creating the Resource Plan for the CDB
      6. Updating the CDB Resource Plan
      7. Adding a New Plan Directive FOR A PDB
      8. Deleting A PDB's Plan Directive
      9. Enabling the CDB Resource Plan
      10. Disabling the CDB Resource Plan
      11. Deleting the Entire CDB Resource Plan
      12. Creating / Modifying PDB Resource Plans
      13. Enabling / Disabling PDB Resource Plans
      14. Resource Manager Views
      15. Enabling Resource Manager in PDBs
      16. Using Cloud Control with Resource Manager
    2. Runaway Query Management
    3. DBMS_SCHEDULER with a CDB
    4. Lab 24: Resource Manager for CDBS
    5. Lab 24 Solutions: Resource Manager / Performance
  25. Table / Index Enhancements
    1. Creating Multiple Indexes on Columns
    2. Advanced Row Compression
    3. Online Redefinition Enhancements
    4. DML_LOCK_TIMEOUT
    5. Editioning Enhancements
  26. ADR / Network Enhancements
    1. ADR Directory Structure
    2. ADR Command Interpreter Enhancements
    3. Advanced Network Command Interpreter ENHANCEMENTS COMPRESSION
    4. Multiprocess / Multithreaded Architecture
    5. Very Large Network Buffers
  27. Data Loading Enhancements
    1. Data Pump Enhancements
      1. Data Pump VIEWS_AS_TABLES
      2. Transform Clause Enhancements
      3. New Parameters
    2. Log Miner Enhancements
    3. Full Transportable Export / Import
    4. SQL*Loader Enhancements
      1. SQL*Loader Express Mode
      2. SQL*Loader Enhancements
      3. SQL*Loader / External Table Common Enhancements
  28. Partitioning Enhancements
    1. Moving Partitions Online
    2. Interval-Reference Partitioning
    3. Enhanced Cascade Functionality
    4. Operating on Multiple Partitions
    5. Partial Indexes
    6. Global Index Maintenance
    7. Controlling Statistics Gathering for partitions

InterSource Geneva, a premier Information Technology training firm, offers over 400 different courses on server, database and programming technologies, as well as end-user classes for the most popular office, graphics and design applications. We serve clients in Switzerland (Geneva, Lausanne, Bern, Basel, Zurich) and throughout Europe (France, Germany, Austria, Finland, Sweden, England, Netherlands, Spain, etc.).


InterSource offers custom, private courses at client sites, standard public courses in our Geneva classroom, and online training via live Web conference. Training is offered in English and many other languages (Francais, Deutsch, Espanol, Italiano.)


For an overall view of our offerings, please visit us at www.intersource.ch.