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: Databases
Status: Database Management
IntermediateCourse18 hours

Featured reviews

KB

Reviewed Apr 26, 2023

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

PI

Reviewed 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.

AD

Reviewed Jun 5, 2024

Great course! Short and informative videos and interesting tasks.

AS

Reviewed Dec 6, 2022

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

CD

Reviewed Nov 12, 2023

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

AR

Reviewed Mar 4, 2023

The course is very useful, the exercises are great.

LP

Reviewed 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..

YN

Reviewed Dec 17, 2023

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

MA

Reviewed Jan 2, 2023

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

RT

Reviewed Apr 23, 2024

Its really a good course, it helped me with Advanced Topics on MYSQL

All reviews

Showing: 20 of 71

Sidney
5.0
Reviewed Dec 11, 2022
Brent
5.0
Reviewed Jul 3, 2023
Bernard
5.0
Reviewed Jan 8, 2023
Patricia
5.0
Reviewed May 10, 2023
Logeshwaran
5.0
Reviewed Jan 6, 2023
Krish
5.0
Reviewed Aug 3, 2023
Caleb
4.0
Reviewed Oct 5, 2023
Brisa
4.0
Reviewed Apr 14, 2023
brent
4.0
Reviewed Mar 6, 2023
Eldin
4.0
Reviewed Mar 7, 2023
马镓浚
4.0
Reviewed Feb 20, 2023
Pranshul
3.0
Reviewed Nov 23, 2022
Carl
5.0
Reviewed Dec 30, 2022
FARJAD.
5.0
Reviewed Sep 22, 2025
Abdullah
5.0
Reviewed Nov 12, 2022
Ricardo
5.0
Reviewed Oct 20, 2024
Manuel
5.0
Reviewed Jan 2, 2023
Yaoxiang
5.0
Reviewed Dec 17, 2023
aman
5.0
Reviewed Dec 6, 2022
Ahmad
5.0
Reviewed Jun 6, 2024