Oracle 12c/18c Training

Course Content

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
  Data Validation
  Data-bound Collation
  Setting Collation At The Schema Level
  Setting Collation At The Table And Column Levels
  Setting Collation For Views Using Collate
  Specifying Collation For An Expression
  Case-insensitive Database
  Unicode 7.0 Support
  Miscellaneous New Sql Features
  Hey Broke Login.sql!
  Data Model Review
  Lab 1: Sql Enhancements
  Lab 1 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
  
  The Impact Of Data-bound Collation
  
  New Views For Use With Pl/scope
  
  Miscellaneous New Pl/sql Features For Oracle12c
  
  Lab 2: Pl/sql Enhancements
  
  Lab 2 Solutions: Pl/sql Enhancements
Installation / Upgrading
- Overview Of Database Creation
  In The Beginning
  The Oracle Universal Installer
  Prerequisite Tasks
  Memory Requirements
  Hardware Requirements
  
  Package Requirements
  
  What About Windows?
  
  Running The Installer
  
  Post Installation
  
  Environment
  
  Using The Database Configuration Assistant
  
  Using The Database Configuration Assistant – Short Form
  
  Database Templates
  
  Upgrading The Database
  
  Using The Compatible Parameter
  
  Database Control Removal
  
  Upgrade Prerequisites
  
  Time Warp From Chapter 8
  
  Removing Oracle Software
  
  Lab 3: Installation / Upgrading
  
  Lab 3 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
Sql Developer / Sql*plus
- Sql Developer New Features
  Instance Viewer
  Multitenant Connection Considerations
  Using Sql Developer
  Sql*plus For Oracle12c
  New Show Commands
  Last Login Time
  Support For The New Administrative Privileges
  Support For Pluggable Databases
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
  Service Control (Srvctl)
Multitenant Basics
- Creating Cdbs
  Features Unsupported For Multitenant Architecture
  The Create Database Command For Cdbs
  Seed Data Files
  Configuring Enterprise Manager Database Express For Cdbs
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
  Hot Cloning
  Refreshable Pdbs
  Unplugging A Pdb
  Creating A Pdb By Plugging In An Unplugged Pdb
  Enhancements To Unplug/plug In Release 2
  Creating A Pdb From A Non-cdb Database
  Using Dbms_pdb
  Hot Cloning Non-cdbs
  Pdb Relocate
  New Trigger Types For Pdbs
  The Before Unplug Trigger
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
  Default And Temporary Tablespaces For Pdbs
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
Multitenant Roundup
- Renaming A Pluggable Database
  Moving A Pdb
  Using Oracle Managed Files With Cdbs
  This Is For Your Own Good!
  A Brief Word On Data Guard
  Multitenant Enhancements In Release 2
  Parallel Pdb Creation
  Hot Cloning Pdbs
  Converting Release 1 Pdbs To Use Local Undo
  Default Tablespace Clause In Cloning
  Relaxed Character Set Restrictions
  Support For Individualized Pdb Time Zones
  Flashback Database
  Relocating Pdbs Online
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
  Network File System Capability
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
In-database Archiving
- To Keep Or Not To Keep
  The Row Archival Clause
  Ora_archive_state
  Row Archival Visibility
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
  New Unified Auditing Features In Release 2
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
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
  New Redaction Procedures In Release 2
  Redaction_policies / Redaction_columns
Rman 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
  Memory-resident (A.k.a. In-memory) Scheduler Jobs
  Enhancements Added In Oracle 12c Release 2
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
Schema And Data Changes
- 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
Sql Tuning
- Adaptive Execution Plans
  Dbms_xplan And Adaptive Execution Plans
  Sql Plan Directives / Extended Statistics
  Enhanced Statistics Gathering
  Histogram Enhancements
Real-time Addm / Performance
- The Automatic Database Diagnostic Monitor
  Real-time Addm
  Emergency Monitoring / Current Addm Findings
  Monitoring The Database With The New 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 Database Time Tab
  The Resources Tab
  The System Statistics Tab
  The Containers 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
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
Table / Index Enhancements
- Creating Multiple Indexes On Columns
  Advanced Row Compression
  Online Redefinition Enhancements
  Split Partition And Subpartition (R1)
  Other Relevant Release 1 New Features
  Dml_lock_timeout
  Editioning Enhancements
  Conversion Of A Nonpartitioned Table
  Create Table For Exchange (Ctfe)
  Monitoring Index Usage
  Dba_index_usage
  V$index_usage_info
  Optimizer Statistics Advisor
  Subpartitioned Interval Partitions

Course Tutorials

Demo Videos

dsdada

Watch

Oracle 12c/18c Training

Oracle 12c/18c Training

Course Content

Course Tutorials

Login Here

Enroll Now

Recover Password