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

kurs ist nicht verfügbar in Deutsch (Deutschland)

Wir übersetzen es in weitere Sprachen. Sehen Sie sich die Sprachen an, die wir anbieten.

Oracle HeatWave MySQL Foundation

Dozent: Jeremy Smyth

Bei enthalten

Mehr erfahren

2 Module

Verschaffen Sie sich einen Einblick in ein Thema und lernen Sie die Grundlagen.

Stufe Anfänger

Keine Vorkenntnisse erforderlich

5 Stunden zu vervollständigen

Flexibler Zeitplan

In Ihrem eigenen Lerntempo lernen

2 Module

Verschaffen Sie sich einen Einblick in ein Thema und lernen Sie die Grundlagen.

Stufe Anfänger

Keine Vorkenntnisse erforderlich

5 Stunden zu vervollständigen

Flexibler Zeitplan

In Ihrem eigenen Lerntempo lernen

Was Sie lernen werden

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

Kompetenzen, die Sie erwerben

Kategorie: Performance Tuning
Kategorie: Memory Management
Kategorie: Database Architecture and Administration
Kategorie: Database Management

Werkzeuge, die Sie lernen werden

Kategorie: MySQL
Kategorie: Database Management Systems
Kategorie: Oracle Databases
Kategorie: Oracle Cloud
Kategorie: Relational Databases
Kategorie: Query Languages

Wichtige Details

Zertifikat zur Vorlage

Zu Ihrem LinkedIn-Profil hinzufügen

Bewertungen

9 Aufgaben

Unterrichtet in Englisch

91%

of learners achieved a positive career outcome

Erfahren Sie, wie Mitarbeiter führender Unternehmen gefragte Kompetenzen erwerben.

Weitere Informationen zu Coursera für Unternehmen

Logos von Petrobras, TATA, Danone, Capgemini, P&G und L'Oreal

In diesem Kurs gibt es 2 Module

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.

Moduldetails

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.

Das ist alles enthalten

24 Videos4 Aufgaben

24 VideosInsgesamt 109 Minuten

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

4 AufgabenInsgesamt 45 Minuten

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

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.

Das ist alles enthalten

27 Videos5 Aufgaben

27 VideosInsgesamt 115 Minuten

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