Oracle Database 12c R2: New Features for Administrators Part 2 Ed 1

Oracle Database 12c R2: New Features for Administrators Part 2 Ed 1 Certification Training Course Overview

The Oracle Oracle Database 12c R2: New Features for Administrators Part 2 Ed 1 training course give you a detailed knowledge of Oracle Database 12c Release 2 new and enhanced features in different areas of database administration like Unified Auditing, new partitioning methods, Recovery Manager,online operations, Oracle Data Pump, SQL*Loader, Full Database In-Memory Caching, Automatic Data Optimization, Transparent Data Encryption (TDE) and other areas of security, In-Memory Column Store and Automatic Big Table Caching.

Who Should Do Oracle Oracle Database 12c R2: New Features for Administrators Part 2 Ed 1 training?

  • Database Administrators
  • System Administrator
  • End Users

Oracle Database 12c R2: New Features for Administrators Part 2 Ed 1 (40 Hours) Download Course Contents

Live Online Training
Group Training 3000
06 - 10 Dec 09:00 AM - 05:00 PM CST
(8 Hours/Day)
03 - 07 Jan 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training (GTR) 3450
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Buy Flexi For Only $99 (Online Training Re-imagined)

Course Modules

Module 1: Introduction
  • Global objectives of the course
  • Lessons grouped by modules
  • Schedule of the week
Module 2: Auditing Using Unified Audit
  • Quick review of 11g R2 audit trail implementation
  • Overview of the Unified Audit Trail
  • Creating and enabling audit policies for all users to whom the role is granted directly
  • Capturing VPD (Virtual Private Database) generated predicates
Module 3: Controlling Data Access Using Privileges and Profiles
  • New 12.2 administrative privileges
  • Password file enhancements
  • Enhance the security of administrative users
  • Enforce the associated profile’s password limits
  • Using mandatory INHERIT PRIVILEGES privilege to execute invoker's rights procedure
  • Using mandatory INHERIT PRIVILEGES privilege to select from BEQUEATH current_user views
  • Using new INHERIT (ANY) REMOTE PRIVILEGES privilege
Module 4: Controlling Data Access Using Privilege Analysis
  • Overview of database privilege analysis
  • Granting the CAPTURE_ADMIN role to enable management of privilege capture
  • Creating and starting/stopping privilege captures and runs
  • Viewing privilege analysis result
  • Querying DBA_PRIV_CAPTURES
Module 5: Redacting Data
  • Overview of Oracle Data Redaction
  • Types of Data Redaction Policies
  • New redaction format library in EM GUI
  • Redaction policy expression
  • Redacting with Nullify redaction function
Module 6: Encrypting Data
  • Encrypt / decrypt / rekey tablespaces online
  • Configure automatic tablespace encryption
Module 7: Controlling Data Access Using Transparent Sensitive Data Protection
  • Configure and use TSDP with VPD
  • Configure and use TSDP with Data Redaction
  • Configure and use TSDP with Unified Auditing
  • Configure and use TSDP with Fine-Grained Auditing (FGA)
  • Configure and use TSDP with Transparent Data Encryption (TDE)
Module 8: Making Data Available by Using RMAN Features
  • RMAN enhancements
  • Transport Data Across Platforms
  • Table recovery
  • Automate the manual recovery process by using Recover Database Until Available Redo
  • REPAIR FAILURE command extented
Module 9: Making Data Available by Using Oracle Data Pump, SQL*Loader and External Tables
  • Oracle Data Pump enhancements
  • SQL*Loader enhancements
  • Querying against external tables and overriding external table clauses
Module 10: Making Data Available by Performing Online Operations
  • Describe online redefinition supports
  • Move and compress table partitions ONLINE
Module 11: Partitioning Data
  • Enable reference partitioning with interval partitioned parent tables
  • Incorporate the CASCADE option for TRUNCATE PARTITION and EXCHANGE [SUB]PARTITION operations
  • Convert partitioning Range to Interval and vice-versa
  • Convert subpartitioning Range to Interval and vice-versa
  • Simplify the maintenance of (sub) partitioned tables
  • Composite partitioning
Module 12: Managing Information Lifecycle Using ADO
  • Data classification in 12c : tablespace, group, object, row levels
  • Configure heat map
  • Automatic movement and compression
  • Compression levels and types
  • Policy declaration
  • Customized automated action execution with user-defined function
  • Execution in scheduled maintenance windows and by MMON
  • Customized schedule with DBMS_ILM package
Module 13: Managing Information Lifecycle Using In-Database Archiving and Temporal
  • Challenges of old data in tables and 11g solutions
  • In-database archiving new solutions
  • Use ROW ARCHIVAL clause to enable row lifecycle state for applications
  • Set ROW ARCHIVAL VISIBILITY for session level visibility control
  • Use predicate on ORA_ARCHIVE_STATE column
  • Temporal Validity versus Temporal History (Transaction Time of FDA)
  • Set a Temporal Validity by using PERIOD FOR clause of CREATE / ALTER TABLE
  • New SQL temporal data type
Module 14: Monitoring DB Operations and Performance
  • Overview
  • Use cases
  • Current Tools
  • Define a DB operation
  • Monitoring: Bracketing an Operation
  • Monitoring the Progress of Operations
  • DB Operation Tuning
  • DB Operation Active Report
Module 15: Configuring In-Memory Column Store
  • In-Memory Database option goals and benefits
  • Row format and columnar format
  • New SGA component
  • Deployment
  • Compression and priority in-memory segments attributes
  • Dictionary tables, added columns, IM statistics and IM Advisor
  • IM FastStart
  • Interaction with other products
Module 16: Using In-Memory Column Store
  • Caching results of frequently evaluated expressions and virtual columns
  • Optimizing joined columns by creating join groups
Module 17: Improving Performance Using In-Memory Caching
  • Setting up Full Database In-Memory Caching
  • Explaining the two buffer replacement algorithms of Automatic Big Table Caching
  • Configuring Automatic Big Table Caching with DB_BIG_TABLE_CACHE_PERCENT_TARGET initialization parameter
  • Using Automatic Big Table Caching
Module 18: Improving SQL Performance
  • Statistics gathering performance improvements: Optimizer Statistics Advisor
  • Adaptive Execution Plan
  • Benefit from automatic dynamic sampling
Module 19: Using Real Application Testing Enhancements
  • SQL Performance Analyzer enhancements
  • SQL Plan Management enhancements
  • Database Replay enhancements
Module 20: Improving Performance Using Other Features
  • Manage session PGA limit
  • Multiple indexes on the same set of columns
  • Describe Advanced Row Compression and Avanced Index Compression HIGH level
  • Reduce Cursor Invalidations for DDLs
  • Define real-time materialized views with on query computation and ON STATEMENT refresh materialized views
  • Using multi-process multi-threaded Oracle architecture
  • Describe Database Smart Flash Cache enhancements
  • Use temporary undo for your temporary tables
Download Course Contents

Request More Information

Course Prerequisites
  • Understanding of Oracle Database 11g R2
  • Understanding of Oracle Multitenant Container Database architecture

Upon completion of this training you will know:

  • Manage security with Unified Auditing, privileges and profiles, Privilege Analysis, Data Redaction, Data Encryption, Transparent Sensitive Data Encryption
  • Describe the new RMAN enhancements
  • Manage data availability with new features of Oracle Data Pump, SQL*Loader and external tables, performing online operations
  • Manage data partitioning
  • Manage Information Lifecycle ADO, using In-Database Archiving and Temporal features
  • Describe database operations
  • Configure and use In-Memory Column Store
  • Use In-Memory Caching
  • Use Real Application Testing enhancements

Top Trending Technologies

 Cloud Computing Certification Training Courses
 IT Security and Cybersecurity Certification Courses
 Fundamentals Training and Certification Courses
 Cloud Architect Certification Training Courses
 System Administration Training and Certification Courses
 CRM Training and Certification Courses
 Developers Training and Certification Courses
 Big Data Analytics Courses & Certification Training
 Data Analytics Certification and Training Courses
 Security Testing Training & Certification Courses

FAQ's