The entire Oracle database administrator curriculum, including this course that you are now reading, has these prerequisites from our course Series For Oracle Database Developers. Equivalent experience is also acceptable.

• ORACLE DATABASE 12C: SQL FUNDAMENTALS (LEVELS I & II)
• ORACLE DATABASE 12C: PL/SQL FUNDAMENTALS (LEVELS I & II)

With regard to this text and its position within the course For Oracle Administrators these are the required prerequisites, or equivalent experience:

• ORACLE DATABASE 12C: INSTALL & UPGRADE WORKSHOP
• ORACLE DATABASE 12C: ARCHITECTURE & INTERNALS
• ORACLE DATABASE 12C: ADMINISTRATION WORKSHOP

Oracle Training Certification



Oracle Training Objectives

• Setting metric and alert thresholds for proactive database monitoring by the server alert framework.
• Globalization features within the database to support applications in multiple languages, currencies, time zones and countries.
• Database connection and session options that support thousands of concurrent users, including a shared servers configuration.
• Automatic database management, monitoring and tuning facilities. Included are automatic management of storage space and memory resources within the database and the role of the Segment Advisor and Memory Advisors.
• Automatic resumption of database operations even in the face of storage space allocation failures and errors.
• Protecting data-at-rest in the database using the advanced data security feature Transparent Data Encryption, as well as a solid overview of underlying encryption technologies, protocols and algorithms.
• Protecting data en route with Oracle Net Services encryption.
• An introduction to advanced space management topics, including custom space management attributes, resumable space allocation and other subjects.
• Advanced compression techniques for tables and indexes.
• Columnar vs. row-oriented database storage and the use of hybrid columnar compression.
• Heat map tracking of segment access to measure hot, warm and cold areas of the database that could be targeted for optimization.
• ILM data management and support for that framework with available features of the Oracle database.
• Automatic data optimization and policies that automatically implement the ILM concepts of row-level compression tiering, segment-level compression tiering and segment-level storage tiering.
• Implementing custom ILM storage management policies.
• In-memory storage of database objects, including big table caching, full database caching and in-memory column stores.
• Archiving inactive data inside the database while not degrading performance while limiting added storage costs.
• Introduce temporal validity into a table and perform flashback query operations using temporal validity criteria.
• Data redaction that allows data privacy policies to be dynamically enforced during queries.

Course duration

5 Days

Oracle Training Course outline

Advanced Administration: About Advanced Database Administration

• Database Feature Usage
• Server Alert Framework
• Managing The Server Alerts Using EM CC
• pDB Level Alerts

Advanced Administration: Globalization

• Globalization Settings
• Managing NLS Settings
• Date & Time Localization
• Linguistic Sorting & Matching
• Linguistic Indexes
• About Locale Builder

Advanced Administration: Database Connections & Shared Servers

• Connection & Session Options
• Shared Servers Architecture
• Comparing Shared Servers & Dedicated Servers
• Configure Shared Servers
• Use Shared Servers
• Monitor Shared Servers

Advanced Security: Database Security Threats

• Potential Threats
• Potential Attackers
• The Threat Matrix
• Database Security Checklist

Advanced Security: Encryption Concepts

• About Encryption
• Data-At-Rest Encryption
• Data-In-Transit Encryption
• Data-En-Route Encryption
• Encryption Limitations
• Encryption Algorithms & Potential Weaknesses
• Managing Encryption Keys

Advanced Security: TDE Keystore Management

• About Transparent Data Encryption
• The SYSKM Administrator
• TDE Encryption Algorithms
• Understanding How Column Encryption Works
• Understanding How Tablespace Encryption Works
• Is TDE Unbreakable?
• Managing TDE
• Managing The Keystore
• Managing A Wallet Keystore Using SQL
• Managing A Wallet Keystore Using EM CC
• Managing A Wallet Keystore Using OWM
• Advanced Management Options
• Keystore Backups
• Migrate To HSM Keystore
• Wallet Open Options
• Regenerate Master Encryption Key

Advanced Security: TDE Data Encryption

• Implement Tablespace Encryption
• Implement Column Encryption
• Assessing Encryption Usage

Advanced Security: Oracle Net Services Encryption & Security

• Network-Launched Attacks
• Limiting Database Attacks
• Preventing Denial-of-service Attacks
• Avoiding Disclosure Of Vulnerabilities
• Oracle Net Services User Notifications
• Oracle Net Native Encryption
• Implementation With Oracle Net Manager
• Implementation With sqlnet.ora

Advanced Storage: Space Management

• Space Management Best Practices
• Segment Storage Specifications
• Estimate & Track Space Usage
• Resumable Space Allocation
• Enable A Resumable Session
• Detect A Suspended Session
• Resuming A Session
• Using DBMS_RESUMABLE()
• Deferred Segment Creation

Advanced Storage: The Segment Advisor

• About The Segment Advisor
• Using The SHRINK SPACE Option
• Segment Advisor Within EM CC
• The Automatic Segment Advisor
• Programmatic Segment Advisor

Advanced Compression

• About Compression
• Table Compression
• Basic Table Compression
• Advanced Row Compression
• Additional Table Compression Considerations
• Index Compression
• Key Compression
• Advanced Index Compression
• Hybrid Columnar Compression
• Compression Analysis
• Using SQL Metadata Queries
• Using DBMS_COMPRESSION()
• Using EM CC

Heat Map Tracking & Automatic Data Optimization (ADO)

• About ILM
• The Oracle Database & ILM Support
• Heat Map Tracking
• Automatic Data Optimization (ADO)
• Adding ADO Policies Using SQL
• Managing ADO Policies Using SQL
• Managing ADO Policy Evaluation
• Managing ADO Policies Using EM CC

In-Memory Storage

• About Traditional Table Caching
• Big Table Caching
• Full Database Caching
• In-Memory Column Store
• IMCS Internals
• Configuring The IMCS
• Assigning Objects To The IMCS
• Assigning Columns To The IMCS
• Monitoring IMCS Using EM CC

In-Database Archiving

• About In-Database Archiving
• In-Database Archival Tables
• In-Database Archiving Of Rows
• Temporal Validity

Data Redaction

• About Data Redaction
• The Redaction Functions
• Using Function Type dbms_redact.random
• Using Function Type dbms_redact.partial
• Function Type dbms_redact.partial Shortcuts
• Using Function Type dbms_redact.regexp
• Function Type dbms_redact.regexp Shortcuts
• Defining Redaction Policies
• Managing Redaction Policies
• Customizing Full Redaction
• Viewing Redaction Metadata
• Using EM Cloud Control
• Inference Attacks

---

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved