Course Description

Prepare to pass exam: MySQL HeatWave Implementation Associate - Rel 1

A MySQL HeatWave Implementation Certified Associate has demonstrated the knowledge required to provision, configure, and manage MySQL HeatWave for transactions, analytics, machine learning, and Lakehouse.

Individuals who earn this certification understand how to manage user accounts, connectivity, machine learning, and analytics with MySQL HeatWave Lakehouse.

To prepare for the MySQL HeatWave Implementation Associate - Rel 1 exam, focus on:

• Understanding HeatWave’s architecture and benefits.
  
• Mastering data loading techniques and management practices.
• Enhancing SQL skills for query writing and optimization.
• Studying performance optimization strategies.
• Gaining hands-on experience with HeatWave and using Oracle documentation.

Exam topics covered

MySQL HeatWave Service

• Identify key features and benefits
  
• Describe MySQL HeatWave architecture
• Define MySQL HeatWave terminology
• Identify MySQL HeatWave limitations

Provisioning and Connecting DB systems

• Identify VCN requirements for provisioning DB systems
  
• Connect to DB system with OCI Bastion
• Connect to DB system with MySQL Shell
• Connect to DB system with OCI Cloud Shell
• Connect to DB system with OCI SQL Worksheet
• Authenticate DB system with OCI Identify Access Management credentials

Managing DB systems

• Demonstrate a command of DRG and DRG Attachments
  
• Apply BGP in the OCI environment
• Evaluate OCI VPN Services  
• Validate the various FastConnect products from OCI
• Sustain Multicloud Connectivity configurations

Backing up and restoring DB systems

• Back up and restore a DB system
  
• Manage automatic backups
• Perform point-in-time recovery

MySQL HeatWave Configurations

• Create custom configurations
  
• Compare configurations
• Describe the effects of changing dynamic and non-dynamic variables
• Update a DB system configuration

Read Replicas    

• Create and manage read replicas
  
• Describe the read replica load balancer
• Connect to a read replica

Inbound Replication

• Set up and troubleshoot inbound replication
  
• Create and manage channels

Data Migrations

• Create a DB system with data import
  
• Import data into a DB system
• Export data from MySQL servers and DB systems
• Migrate data with replication

High Availability

• Enable and disable the high availability of a DB system
  
• Explain placement considerations for a high availability DB system
• Distinguish between switchover and failover

HeatWave Cluster

• Describe the architecture of HeatWave cluster
  
• Add a HeatWave cluster to a DB system
• Determine whether a query is offloaded to HeatWave cluster for execution
• Create Lakehouse external tables

HeatWave AutoML

• Distinguish between model types
  
• Train a model using existing data
• Describe how to evaluate a trained model