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.
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!
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:
As a Consulting User Assistance (UA) Developer, I'm responsible for developing all the UA Assets for Oracle Database products.