When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I purchase the Certificate?

When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Oracle HeatWave MySQL Foundation

Ce cours n'est pas disponible en Français (France)

Nous sommes actuellement en train de le traduire dans plus de langues. Consultez les langues disponibles.

Oracle HeatWave MySQL Foundation

Instructeur : Jeremy Smyth

Inclus avec

2 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

niveau Débutant

Aucune connaissance prérequise

5 heures à compléter

Planning flexible

Apprenez à votre propre rythme

2 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

niveau Débutant

Aucune connaissance prérequise

5 heures à compléter

Planning flexible

Apprenez à votre propre rythme

Ce que vous apprendrez

Describe the architecture and features of MySQL HeatWave
Create and manage DB systems
Add and manage a HeatWave cluster
Load data and run queries on HeatWave cluster
Explain the working of HeatWave query accelerator
Load data and run queries on HeatWave cluster
Optimize HeatWave workload by using advisors

Compétences que vous acquerrez

Catégorie : Memory Management
Catégorie : Database Architecture and Administration
Catégorie : Performance Tuning
Catégorie : Database Management

Outils que vous découvrirez

Catégorie : Oracle Cloud
Catégorie : Database Management Systems
Catégorie : MySQL
Catégorie : Oracle Databases
Catégorie : Relational Databases
Catégorie : Query Languages

Détails à connaître

Certificat partageable

Ajouter à votre profil LinkedIn

Évaluations

9 devoirs

Enseigné en Anglais

Découvrez comment les employés des entreprises prestigieuses maîtrisent des compétences recherchées

En savoir plus sur Coursera pour les affaires

logos de Petrobras, TATA, Danone, Capgemini, P&G et L'Oreal

Il y a 2 modules dans ce cours

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.

Détails du module

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.

Inclus

24 vidéos4 devoirs

24 vidéosTotal 109 minutes

Overview of MySQL HeatWave5 minutes
Oracle Cloud Infrastructure Basics5 minutes
MySQL HeatWave Architecture9 minutes
Practices for Introducing MySQL HeatWave - Overview1 minute
Cloud Shell Overview3 minutes
Practice 1-1 Preparing the Lab Environment5 minutes
Practice 1-2 Inspecting the Subnets of a VCN4 minutes
Creating DB Systems8 minutes
Connecting to DB Systems8 minutes
Editing DB Systems5 minutes
Managing DB Systems4 minutes
Practices for Deploying a DB System - Overview2 minutes
Practice 2-1: Creating a MySQL DB System7 minutes
Practice 2-2: Connecting to a MySQL System with Cloud Shell4 minutes
Practice 2-3: Editing a DB System4 minutes
Practice 2-4: Increasing the Storage Size of a DB System2 minutes
Practice 2-5 Stopping, Starting, and Restarting a MySQL DB System3 minutes
Adding a HeatWave Cluster4 minutes
Loading Data and Running Queries5 minutes
Managing HeatWave Cluster4 minutes
Practices for Deploying a HeatWave Cluster - Overview2 minutes
Practice 3-1: Adding a HeatWave Cluster to a DB System4 minutes
Practice 3-2: Loading Data into HeatWave and Running Queries on HeatWave6 minutes
Practice 3-3: Stop, Start, Restart, Resize, and Delete a HeatWave Cluster4 minutes

4 devoirsTotal 45 minutes

Introducing MySQL HeatWave10 minutes
Deploying a DB System10 minutes
Deploying a HeatWave Cluster10 minutes
Assessment 115 minutes

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.

Inclus

27 vidéos5 devoirs

27 vidéosTotal 115 minutes

Overview of HeatWave Query Accelerator5 minutes
Practice 1-1: Preparing the Lab Environment5 minutes
Loading Data into HeatWave Cluster - Overview3 minutes
Loading Data Manually6 minutes
Loading Data Using Auto Parallel Load8 minutes
Monitoring Data Loading3 minutes
Unloading Data5 minutes
Practice 2 Overview3 minutes
Practice 2-1: Loading Data Manually into HeatWave Cluster6 minutes
Practice 2-2: Loading Data with Auto Parallel Load5 minutes
Practice 2-3: Monitoring Data Loading into HeatWave Cluster3 minutes
Practice 2-4: Unloading Data from HeatWave Cluster5 minutes
Offloading Queries to HeatWave5 minutes
Debugging Queries4 minutes
Practice 3 Overview1 minute
Practice 3-1: Offloading Queries to HeatWave Cluster5 minutes
Practice 3-2: Debugging Queries That Are Not Offloaded to HeatWave Cluster5 minutes
Overview of Advisors4 minutes
Auto Encoding Advisor5 minutes
Auto Data Placement Advisor6 minutes
Query Insights5 minutes
Auto Unload Advisor5 minutes
Practice 4 Overview2 minutes
Practice 4-1: Viewing Query Runtime with Query Insights4 minutes
Practice 4-2: Identifying Tables to Unload with Auto Unload Advisor3 minutes
Practice 4-3: Optimizing String Column Encoding with Auto Encoding Advisor3 minutes
Practice 4-4: Optimizing Partitioning Columns with Auto Data Placement Advisor3 minutes