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: Database Development
Database Development
Status: Stored Procedure
Stored Procedure
Intermediate·Course·18 hours
Featured reviews
5.0
·Reviewed Apr 26, 2023
I like the way she teaches very detailed and in a simple way
5.0
·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.
5.0
·Reviewed Jun 5, 2024
Great course! Short and informative videos and interesting tasks.
5.0
·Reviewed Dec 6, 2022
Great Course, Some advanced topics needs more explanation but overall a great course.
5.0
·Reviewed Nov 12, 2023
This is the content I needed to polish my SQL skills!
5.0
·Reviewed Mar 4, 2023
The course is very useful, the exercises are great.
5.0
·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..
5.0
·Reviewed Dec 17, 2023
The course is very nice. The only suggestion is to have a summary document for each module.
5.0
·Reviewed Jan 2, 2023
Great course! in all fairness they did a very good job with this course, in my opinion that is.
4.0
·Reviewed Apr 23, 2024
Its really a good course, it helped me with Advanced Topics on MYSQL
All reviews
Showing: 20 of 71
All Learners
All Stars
Most Helpful
S
Sidney
5.0
·Reviewed Dec 11, 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!
B
Brent
5.0
·Reviewed Jul 3, 2023
This course really helped me to understand how SQL can be used in a programmatic way with explanations on Triggers, Functions, Procedures, and other various query optimization techniques. I found the introduction to the storing and referencing of JSON objects particularly interesting because the concept can really simplify the structure of a table and increase its readability.
B
Bernard
5.0
·Reviewed Jan 8, 2023
All I can say is that this course literally provides an advanced concepts of SQL commands and a deep dive of not-so-often used and complex MySQL features. I learned a lot though I think I need to revisit most of the topics as it is not easy to memorize those syntax :) Great work, Meta!
P
Patricia
5.0
·Reviewed May 10, 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.
L
Logeshwaran
5.0
·Reviewed Jan 6, 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..
K
Krish
5.0
·Reviewed Aug 3, 2023
Amazing course , it goes over and beyond in teaching you practical ways of bettering your sql / mysql implementations. Thankful for this course.
C
Caleb
4.0
·Reviewed Oct 5, 2023
I generally enjoyed the course and picked up a few things here and there. I did feel that some of the labs and test questions could have been more clear. I felt like I was guessing sometimes, not because I didn't have an understanding, but because the wording was confusing. Again, in general, it's a good course for those seeking to develop their MySQL skills.
B
Brisa
4.0
·Reviewed Apr 14, 2023
The topics discussed in this course are great, but I felt like the pace of it didn't match with the previous courses. This is the 4th course on this certificate and so far the one I enjoyed the less. I still think it was absolutely worth my time and that I learned a lot but I would have liked some more guidance on the activities.
B
brent
4.0
·Reviewed Mar 6, 2023
This was a helpful course that delves into how to write MySql queries more effectively. The only thing that would be better would add a MySQL project after learning so much about MySql. I think it would be nice to show what we have learned
E
Eldin
4.0
·Reviewed Mar 7, 2023
It was good but not as good as the previous once. Some parts were to fast paced and didnt cover enough info. I had the feeling like they didnt have enough time so they picked up the pace for some lections.
马
马镓浚
4.0
·Reviewed Feb 20, 2023
Some errors in this course need to be corrected, overall a good course.
P
Pranshul
3.0
·Reviewed Nov 23, 2022
Difficult to access their labs.
C
Carl
5.0
·Reviewed Dec 30, 2022
Much more involved than the intro course, but so well presented and organized that I really flourished. I feel pretty confident in my ability to work in and with MySQL, and comfortable with the resources available to fine tune the syntax. Probably the single best module I have taken thus far on Coursera.
F
FARJAD.
5.0
·Reviewed Sep 22, 2025
Their are very less labs in this that's i can get much hands-on experience regarding all concepts of Advanced MY SQL. Instructor teach complex concepts in very hurry. My suggestion is to prepare topic in smooth way so that's why beginner can get more knowledge. Thanks
A
Abdullah
5.0
·Reviewed Nov 12, 2022
Really good and comprehensive course but the problem is that the instructor speaks too fast and sometimes its difficult to grasp the concept due to that. Would really appreciate it if this isn't the case with the other courses in this professional certificate.
R
Ricardo
5.0
·Reviewed Oct 20, 2024
Auxilia a quem busca base teórica - para os conceitos de SQL e prática para que almeja consolidar conhecimento em SQL.
M
Manuel
5.0
·Reviewed Jan 2, 2023
Great course! in all fairness they did a very good job with this course, in my opinion that is.
Y
Yaoxiang
5.0
·Reviewed Dec 17, 2023
The course is very nice. The only suggestion is to have a summary document for each module.
A
aman
5.0
·Reviewed Dec 6, 2022
Great Course, Some advanced topics needs more explanation but overall a great course.
A
Ahmad
5.0
·Reviewed Jun 6, 2024
Great course! Short and informative videos and interesting tasks.