Free MySQL HeatWave foundations course

February 28, 2023 | 2 minute read
Anuradha Chepuri
Consulting User Assistance Developer, Oracle
Text Size 100%:

There’s no better time to learn new skills than now! Oracle has introduced free training on MySQL Heatwave. Whether you’re a database administrator who wants to improve the performance of the analytics powering your applications or an executive looking to solve your organization’s needs, get started with this MySQL Heatwave Foundations course to simplify your database infrastructure, while getting real-time analytics, and lowering costs.

What this course covers 

  • How a typical application works with transactional data in an online transactional processing (OLTP) database and how to create a MySQL Heatwave cluster with the optimum number of nodes based on your data and workload

  • Differences between transactional and analytical processing (OLTP and OLAP) workloads

  • Advantages of using the MySQL Database service with Heatwave

  • Examples of transactional and analytical queries using the airportDB sample database, how to optimize analytical queries with summary tables, and comparison of the characteristics of transactional and analytical queries

  • The architecture of Heatwave, how to create a Heatwave cluster on a MySQL Database System, and the process of loading sample data into Heatwave

  • How to run queries in Heatwave and verify if the query is offloaded to Heatwave, identify the reasons in case the query is not offloaded, and then optimize Heatwave by using Advisors

By the end of this course, you can understand how to run your analytical queries on the same database that runs your application by enabling Heatwave for a massive performance improvement. Complete this short course and assessment to earn the MySQL Heatwave Foundations badge!

Learn more

MySQL HeatWave is the only cloud database service that combines transactions, analytics, and machine learning services into one MySQL Database, delivering real-time, secure analytics without the complexity, latency, risk, and cost of ETL duplication. MySQL HeatWave is 6.5 times faster than Amazon Redshift at half the cost, 7 times faster than Snowflake at one-fifth the cost, and 1,400 times faster than Amazon Aurora at half the cost.

You can deploy MySQL HeatWave on Oracle Cloud Infrastructure (OCI), AWS, Azure, or in your data center with OCI Dedicated Region. To learn more, check out the Product Resources page and this 2.5-minute video:

Anuradha Chepuri

Consulting User Assistance Developer, Oracle

As a Consulting User Assistance (UA) Developer, I'm responsible for developing all the UA Assets for Oracle Database products.

Previous Post

ODSA versus the OCI-Azure Interconnect

Niranjan Mohapatra | 11 min read

Next Post

OpenVPN DNS settings with OCI

Cody Brinkman | 4 min read