Back to Advanced MySQL Topics
Meta

Advanced MySQL Topics

In this course, you'll begin to push beyond simple SQL statements in MySQL to an advanced level in database engineering. By the end of this course, you'll be able to: - Use control statements and variables in different contexts in MySQL - Develop user defined functions and procedures - Optimize MySQL database queries - Demonstrate a working knowledge of common table expressions and the JSON data type - Understand how and when to use triggers and events - Utilize subqueries, JOINS, views and transactions to perform data analysis - and use database optimization techniques such as MySQL transactions You'll gain experience with the following advanced MySQL database skills: - MySQL user defined functions - Advanced MySQL stored procedures - MySQL optimization techniques including Indexes, Transactions, CTE and JSON - MySQL triggers and events - Database analytics in MySQL - Advanced SQL queries for data analysis with JOINS, views and subqueries Through this course you'll develop new skills, improve your productivity, learn to act effectively with data and boost your career prospects. To be successful in this course, you should have already completed the previous course, “Database Structures and Management with MySQL,” or have prior experience with the skills taught in that course.

Status: MySQL
Status: Performance Tuning
IntermediateCourse18 hours

Featured reviews

MA

5.0Reviewed Jan 2, 2023

Great course! in all fairness they did a very good job with this course, in my opinion that is.

PI

5.0Reviewed May 9, 2023

It was very challenging but the instructor maximized the time and resources available for a great course delivery. I learnt a lot, and hoping to practice to become more proficient.

YE

4.0Reviewed Aug 26, 2023

I found the content helpful and the lab environment helped me practice what learned step by step. However, the pace and tone of the instructor can be improved. I had to pause a lot to understand it.

YN

5.0Reviewed Dec 17, 2023

The course is very nice. The only suggestion is to have a summary document for each module.

CD

5.0Reviewed Nov 12, 2023

This is the content I needed to polish my SQL skills!

LP

5.0Reviewed Jan 5, 2023

Thank you so much for the opportunity to learn Advanced MySql learn New things with crisp and clearly Taught Menter and Meta and Coursera thanks for help me..

AD

5.0Reviewed Jun 5, 2024

Great course! Short and informative videos and interesting tasks.

KS

5.0Reviewed Aug 2, 2023

Amazing course , it goes over and beyond in teaching you practical ways of bettering your sql / mysql implementations. Thankful for this course.

AR

5.0Reviewed Mar 4, 2023

The course is very useful, the exercises are great.

KB

5.0Reviewed Apr 26, 2023

I like the way she teaches very detailed and in a simple way

SI

5.0Reviewed Dec 10, 2022

Learned a bunch of new SQL topics here.. I recommend this to anyone interested in improving their SQL skills. Don't forget to expand your understanding via any other resources out there.Good one!

AS

5.0Reviewed Dec 6, 2022

Great Course, Some advanced topics needs more explanation but overall a great course.

All reviews

Showing: 20 of 68

Sidney Isoe
5.0
Reviewed Dec 11, 2022
Brent Artuch
5.0
Reviewed Jul 3, 2023
Bernard D. Rebagoda
5.0
Reviewed Jan 8, 2023
Patricia Ojonoka Idakwo
5.0
Reviewed May 10, 2023
Logeshwaran P
5.0
Reviewed Jan 6, 2023
Krish Shah
5.0
Reviewed Aug 3, 2023
Caleb Hill
4.0
Reviewed Oct 5, 2023
Brisa PR
4.0
Reviewed Apr 14, 2023
brent zitsman
4.0
Reviewed Mar 6, 2023
Eldin Fehric
4.0
Reviewed Mar 7, 2023
马镓浚
4.0
Reviewed Feb 20, 2023
Pranshul Maheshwari
3.0
Reviewed Nov 23, 2022
Carl Smith
5.0
Reviewed Dec 30, 2022
FARJAD. KHAN
5.0
Reviewed Sep 22, 2025
Abdullah Zubair
5.0
Reviewed Nov 12, 2022
Ricardo Aparecido de Sousa Freitas
5.0
Reviewed Oct 20, 2024
Manuel Alva
5.0
Reviewed Jan 2, 2023
Yaoxiang Nie
5.0
Reviewed Dec 17, 2023
aman sandhu
5.0
Reviewed Dec 6, 2022
Ahmad Dusmatov
5.0
Reviewed Jun 6, 2024