Oracle HeatWave MySQL Foundation

Overview

AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off

One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.

The Oracle HeatWave MySQL Foundations course is designed to introduce you to HeatWave's massively parallel, high-performance, native in-memory query acceleration. Learn about configuring the cluster and using the innovative Autopilot features to accelerate your MySQL performance by orders of magnitude for analytics and mixed workloads.

Syllabus

HeatWave MySQL: Getting Started

This module provides an overview of the MySQL HeatWave Database Service along with it architecture. It then covers how to deploy, connect, edit, and manage a MySQL DB System. Next, it covers how to use Auto Parallel Load to load data into HeatWave and determine whether a query is executed on the HeatWave cluster. Finally, the course covers the steps to view, stop, start, restart, resize, and delete a HeatWave Cluster.

HeatWave MySQL: Accelerating Queries

This module explains the workings of HeatWave Query Accelerator and in the process, you learn how to use Auto Parallel Load to load data into HeatWave Cluster. You learn how to offload queries to HeatWave Cluster and to debug queries. Additionally, you learn how to optimize HeatWave workloads by using advisors, such as Auto Encoding Advisor, Auto Data Placement Advisor, Query Insights, Auto Unload Advisor.