Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > Oracle 12c > Oracle Database 12c: New Features for Administrators Training

Oracle Database 12c: New Features for Administrators Training

Course#: ORA12CNF

This course provides a complete, hands-on introduction to the newest release of Oracle Enterprise Edition. Key features of this product are fully discussed and demonstrated.

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.  Full familiarity with Oracle11g PL/SQL is highly desirable.

Duration

5 Days

Outline of ORA12CNF Oracle Database 12c: New Features for Administrators Training

CHAPTER 1 – 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 1:  SQL ENHANCEMENTS
  • LAB 1 SOLUTIONS: SQL ENHANCEMENTS

CHAPTER 2 – 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 2:  PL/SQL ENHANCEMENTS
  • LAB 2 SOLUTIONS: PL/SQL ENHANCEMENTS

CHAPTER 3 – INSTALLATION / UPGRADING

  • OVERVIEW OF DATABASE CREATION
  • THE ORACLE UNIVERSAL INSTALLER
  • PREREQUISE 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 3: INSTALLATION / UPGRADING
  • LAB 3 SOLUTIONS: INSTALLATION / UPGRADING

CHAPTER 4 – 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 4:  ENTERPRISE MANAGER ENHANCEMENTS
  • LAB 4 SOLUTIONS: ENTERPRISE MANAGER ENHANCEMENTS

CHAPTER 5 – 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 5:  SQL DEVELOPER / SQL*PLUS
  • LAB 5 SOLUTIONS: SQL DEVELOPER / SQL*PLUS

CHAPTER 6 – 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 6: MULTITENANT DATABASES
  • LAB 6 SOLUTIONS: MULTITENANT DATABASES

CHAPTER 7 – 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 7:  MULTITENANT BASICS
  • LAB 7 SOLUTIONS: MULTITENANT BASICS

CHAPTER 8 – INTERMEDIATE MULTITENANT

  • OPTIONS AVAILABLE
  • THE CREATE PLUGGABLE DATABASE STATEMENT
    • The STORAGE Clause
    • File Locations Clause
    • Temp File 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 8:  INTERMEDIATE MULTITENANT
  • LAB 8 SOLUTIONS: INTERMEDIATE MULTITENANT

CHAPTER 9 – ADVANCED MULTITENANT

  • USING DATA PUMP EXPORT AND IMPORT
  • USING EXP AND IMP
  • DROPPING PDBS
  • USING CLOUD CONTROL TO CREATE AND DROP PDBS
  • ADMINISTRATION DETAILS
    • Special Roles For CDBs
    • Other Administrative Considerations For CDBs
    • Manageability Considerations
    • Objects In CDBs
    • Services
    • Sessions
    • Common Listeners
    • Connecting To PDBs In MOUNT Mode
    • Login Triggers And The SET CONTAINER Clause
    • Package States And Containers
    • EXECUTE IMMEDIATE And SET CONTAINER
  • EXECUTING ACROSS ALL PLUGGABLE DATABASES USING DBMS_SQL
  • LOGGING ERRORS FOR MULTIPLE CONTAINERS
  • ALTER DATABASE IN A CDB
  • TABLESPACES IN CDBS
  • USING FORCE ON PDBS
  • CLOSE VS. CLOSE IMMEDIATE
  • SPECIFYING PDBS IN ALTER PLUGGABLE DATABASE
  • LAB 9:  ADVANCED MULTITENANT
  • LAB 9 SOLUTIONS: ADVANCED MULTITENANT

CHAPTER 10 – ULTIMATE MULTITENANT

  • THE STARTUP COMMAND WITHIN PDBS
  • STARTUP PLUGGABLE DATABASE
  • SHUTDOWN WITHIN PDBS
  • ALTER SYSTEM SET STATEMENTS IN CDBS
  • THE CONTAINER CLAUSE IN DDL STATEMENTS
  • RUNNING SCRIPTS IN ALL CONTAINERS
  • AUTOMATING TNSNAMES.ORA MAINTENANCE
  • LAB 10:  ULTIMATE MULTITENANT
  • LAB 10 SOLUTIONS: ULTIMATE MULTITENANT

CHAPTER 11 – MULTITENANT ROUNDUP

  • RENAMING A PLUGGABLE DATABASE
  • MOVING A PDB
  • BUILDING A UNIFIED PARAMETER QUERY
  • LAB 11:  MULTITENANT ROUNDUP
  • LAB 11 SOLUTIONS: MULTITENANT ROUNDUP

CHAPTER 12 – STORAGE AND SECURITY

  • NEW SUPER USERS
  • ENHANCED SECURITY FOR CDBS
  • TEMPORARY TABLESPACE CONSIDERATIONS FOR CDBS
  • HARDENING A CDB
  • STORAGE CLAUSES RELEVANT TO PDBS
  • ALTER SYSTEM IN A PDB
  • SCOPE = SPFILE IN PDBs
  • SERVICES AND PDBs
  • VIEWS IN CDBs
  • CON_ID DETAILS
  • OTHER INTERESTING CDB VIEWS
  • CDB VIEW EXAMPLES
  • NEW FUNCTIONS FOR CONTAINERS
  • TRIGGERS IN A CDB
  • MOVING DATAFILES ONLINE
  • RAW PARTITIONS
  • DATABASE SMART FLASH CACHE SUPPORT
  • LAB 12:  STORAGE AND SECURITY
  • LAB 12 SOLUTIONS: STORAGE AND SECURITY

CHAPTER 13 – BACKUP AND RECOVERY FOR CDBS

  • CONTAINER DATABASE CONSIDERATIONS
  • BACKUP SETUP
  • BACKING UP THE ENTIRE CDB
  • BACKING UP JUST THE ROOT CONTAINER
  • BACKING UP PDBS
  • BACKING UP TABLESPACES AND DATAFILES FROM WITHIN A PDB
  • EXECUTING RMAN ACROSS PDBS
  • REDO LOG, ARCHIVE LOG AND CONTROLFILE BACKUPS IN CDBS
  • COMPLETE RECOVERY OF A CDB
  • COMPLETE RECOVERY OF A PDB
  • COMPLETE RECOVERY OF THE ROOT CONTAINER
  • INCOMPLETE RECOVERY OF THE ENTIRE CDB
  • INCOMPLETE RECOVERY OF PDBS
  • LOSS OF SYSTEM TABLESPACE IN A PDB
  • RMAN RESTRICTIONS IN PDBS
  • PRIOR BACKUPS AND ARCHIVELOGS FOR CONVERTED NON-CDBS
  • FLASHBACK AND CDBS
  • DATA PUMP AND CDBS
  • LAB 13:  BACKUP AND RECOVERY FOR CDBS
  • LAB 13 SOLUTIONS: BACKUP AND RECOVERY FOR CDBS

CHAPTER 14 – AUTOMATIC DATA OPTIMIZATION

  • STORAGE AND COMPRESSION TIERING
  • THE HEAT MAP
  • AUTOMATIC DATA OPTIMIZATION
  • COMPRESSION LEVELS

CHAPTER 15 – IN-DATABASE ARCHIVING

  • TO KEEP OR NOT TO KEEP
  • THE ROW ARCHIVAL CLAUSE
  • ORA_ARCHIVE_STATE
  • ROW ARCHIVAL VISIBILITY
  • LAB 15:  IN-DATABASE ARCHIVING
  • LAB 15 SOLUTIONS: IN-DATABASE ARCHIVING

CHAPTER 16 – 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 16:  AUDITING ENHANCEMENTS
  • LAB 17 SOLUTIONS: AUDITING ENHANCEMENTS

CHAPTER 17 – 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 17:  PRIVILEGE ENHANCEMENTS
  • LAB 17 SOLUTIONS: PRIVILEGE ENHANCEMENTS

CHAPTER 18 – 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 18:  DATA REDACTION
  • LAB 18 SOLUTIONS: DATA REDACTION

CHAPTER 19 – 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
  • MULTISECTION 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 19:  RMAN / FDA ENHANCEMENTS
  • LAB 19 SOLUTIONS: RMAN / FDA ENHANCEMENTS

CHAPTER 20 – 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 20:  DB OPERATIONS
  • LAB 20 SOLUTIONS: DB OPERATIONS

CHAPTER 21 – 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 21:  SCHEMA AND DATA CHANGES
  • LAB 21 SOLUTIONS: SCHEMA AND DATA CHANGES

CHAPTER 22 – SQL TUNING

  • ADAPTIVE EXECUTION PLANS
  • DBMS_XPLAN AND ADAPTIVE EXECUTION PLANS
  • SQL PLAN DIRECTIVES / EXTENDED STATISTICS
  • ENHANCED STATISTICS GATHERING
  • HISTOGRAM ENHANCEMENTS
  • LAB 22:  SQL TUNING
  • LAB 22 SOLUTIONS: SQL TUNING

CHAPTER 23 – 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 23:  REAL-TIME ADDM / PERFORMANCE
  • LAB 23 SOLUTIONS: REAL-TIME ADDM / PERFORMANCE

CHAPTER 24 – RESOURCE MANAGER FOR CDBS

  • RESOURCE MANAGER AND CDBS
    • CDB Resource Plans
    • The Initial Default Directive Attributes For PDBs
    • PDB Resource Plans
    • Background And Administrative Tasks
    • Creating The Resource Plan For The CDB
    • Updating The CDB Resource Plan
    • Adding A New Plan Directive For A PDB
    • Deleting A PDB’s Plan Directive
    • Enabling The CDB Resource Plan
    • Disabling The CDB Resource Plan
    • Deleting The Entire CDB Resource Plan
    • Creating / Modifying PDB Resource Plans
    • Enabling / Disabling PDB Resource Plans
    • Resource Manager Views
    • Enabling Resource Manager In PDBs
    • Using Cloud Control With Resource Manager
  • RUNAWAY QUERY MANAGEMENT
  • DBMS_SCHEDULER WITH A CDB
  • LAB 24:  RESOURCE MANAGER FOR CDBS
  • LAB 24 SOLUTIONS: RESOURCE MANAGER / PERFORMANCE

CHAPTER 25 – TABLE / INDEX ENHANCEMENTS

  • CREATING MULTIPLE INDEXES ON COLUMNS
  • ADVANCED ROW COMPRESSION
  • ONLINE REDEFINITION ENHANCEMENTS
  • DML_LOCK_TIMEOUT
  • EDITIONING ENHANCEMENTS

CHAPTER 26 – ADR / NETWORK ENHANCEMENTS

  • ADR DIRECTORY STRUCTURE
  • ADR COMMAND INTERPRETER ENHANCEMENTS
  • ADVANCED NETWORK COMPRESSION
  • MULTIPROCESS / MULTITHREADED ARCHITECTURE
  • VERY LARGE NETWORK BUFFERS

CHAPTER 27 – 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

CHAPTER 28 – 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
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.