Oracle Database 19c New Features for Administrators


Request for price


Length: 5.0 day (40 hours)

 

This course is designed to provide database administrators with a comprehensive understanding of the new features and enhancements introduced in Oracle Database 19c. It covers key areas such as database administration, security, availability, performance, data warehousing, diagnostics, and shading

  • Database administrators
  • Database developers
  • IT professionals who manage Oracle databases
  • A solid understanding of Oracle Database 12c administration
  • Experience with SQL and PL/SQL ​

Start with the customer – find out what they want and give it to them.

Course objectivesCourse outlines

Course objectives

After completing this course, students will be able to:

    • Learn about the new features and enhancements in Oracle Database 19c
    • Understand the impact of these features on database performance and security
    • Learn how to configure and manage these new features
    • Troubleshoot issues related to the new features
    • Prepare for the Oracle Database 19c Administrator Certified Professional exam

Course outlines

  • 1. Introduction to Oracle Database 19c
    • Overview of new features and enhancements
    • Architectural changes and implications
    • Upgrade considerations and best practices
  • 2. Database Administration
    • Enhanced Database Configuration Assistant (DBCA)
    • Simplified installation and configuration
    • New database options and parameters
    • Improved patching and maintenance processes
  • 3. Security
    • Enhanced security features
    • Key management for encrypted Oracle-Managed Tablespaces (OMTs)
    • Database Vault operations control
    • Data Redaction and Masking
  • 4. Availability
    • Advanced Data Guard enhancements
    • Automatic Database Recovery (ADR) improvements
    • Faster database recovery and failover
  • 5. Performance
    • Memory optimization and performance tuning
    • In-Memory Database enhancements
    • Real Application Clusters (RAC) improvements
    • SQL Performance Analyzer enhancements
  • 6. Data Warehousing
    • Hybrid partitioned tables
    • Automated indexing
    • SQL Diagnostic Advisor
    • Data Pump enhancements
  • 7. Diagnostics
    • Automatic Diagnostic Repository (ADR) enhancements
    • SQL Tuning Advisor improvements
    • Real-Time SQL Monitoring
  • 8. Sharding
    • Multiple PDB shards in a CDB
    • Table families for system-managed sharding
    • Sharding administration and management

​

Download outlines