Practice advanced SQL queries with MySQL 5.7+ (Udemy.com)
Build on your current knowledge and get to a next level in SQL. Learn by writing - lots of examples are waiting for you.
Created by: Michal Juhas
Last updated December 2017
What you will learn
- write user defined functions
- write stored procedures
- simulate some of the analytic (window) functions
- work with cursors
- use the right indexes and partitions
- write advanced & beautiful queries
How it compares
Against the other 43 rated Udemy courses in MySQL on CourseDuck:
- Rating4.1 out of 5higher than 4% of them
- Reviews589#24 of 44 by number of reviews
- Length5 hoursshorter than 65% of them
- Last updatedDecember 2017earlier than 79% of them
Quality Score
Overall Score : 82 / 100
Course Description
In this course, we'll write the code & MySQL queries together. I prepared 2 test databases, 70+ lectures, 4+ hours of video and lots of examples and practices so that you can learn advanced SQL techniques by writing the code. You'll not learn just by watching me and eating pop-corn. You need to write the queries, and I'll help you! I believe that's the only way for you to adopt this new knowledge.
At the end of this course you will not just know these advanced techniques, but also know how to use them in practice.
Anyways, you have nothing to lose. Try this course and if you can honestly say that you learned nothing, just email Udemy, and they will give you a 100% refund within 30 days.
Recent reviews
- "The course was great. Now, I write beautiful queries, using coding style conventions and best practices." -Mauro
- Last course update: March 2017
- Video quality: Very high (1080p HD, 1920x1080)
- Length: Over 5 hours
We'll go through my personal best practices in writing advanced SQL code which I adopted in the last years. Thus some of the videos are long and content-heavy. I had to divide some of them into three parts because of Udemy's limit of 20 mins/video.
If you are a BI developer, automation tester, data analyst, or a DB admin, I'm sure you'll appreciate the hands-on examples and practices. They will help you understand the concepts and learn them by writing the advanced SQL code for MySQL.
If you have a tech background, you'll like the attached .md files with all the SQL code used in the course.
Please note
- Basics such as how to instal a database and SQL tools is not covered in the course.
- This course focuses on MySQL, not PostgreSQL (a new course focused on PostgreSQL coming soon!).
- Did you know that even SQL code can be beautiful? The more advanced SQL code I wrote for MySQL or PostgreSQL, the more I focused on writing beautiful code. It's especially important if you work with several colleagues on the same codebase.
- I recorded all the video content (5+ hours of final footage) in one day, from early morning to late night? I believe you need to get into the zone to produce great content, be creative or to learn efficiently. Thus I recommend the same to you: purchase this course, dedicate 1 full day to it, turn off your smartphone and learn, learn, learn.
- There's a quiz before and after the course. Take it to check your level of knowledge at the beginning of the course to assess your level of SQL & MySQL knowledge. Then take it after the course. If you learn nothing, ask for refund. (Although I'm certain this doesn't happen!)
- As a CTO, I'm responsible for HotelQuickly's product, engineering, technical infrastructure and databases - we use MySQL & PostgreSQL. Prior to joining HotelQuickly I spent 4 years working as a data warehouse consultant, developing and optimising data marts running on Oracle.
- "Let's be clear: If you used only basics of the sql, you will definitely learn lots of new stuff here. This is definitely not the introductory course to MySQL and author will not waste your time by explaining basics to you. Author is very knowledgeable about the topic and you will surely learn, at least how to write well structured queries, and you can apply those immediately in your work. In first 3 chapters you will have a lot of explanations and practices to keep you busy." -Dusan Kostic (see full below)
- "SELECT * FROM `the_most_fascinating`.`course` :-) I really like it!!! Thank you a lot Michal for you very professional work!!" -Andrey Ivashkin
- "This is great course on MYSQL, I learned more here, than any other course I have taken so far." -David Abraham
- "Lots of stuff you can learn from this course. There are still more to MySQL than just creating databases. I would recommend anyone to take this course after they know the basics." -Raymond John Escobar
Who this course is for:
- Those who know SQL basics and want to get to next level
- Business intelligence (BI) analysts
- BI developers
- Data scientists
- IT specialists
- QA analysts & testers
- Automation testers
- DB administrators
- NOT beginners (in this course you already need to have basic / intermediate SQL knowledge)
Instructor Details
- 4.1 Rating
589 Reviews
Michal Juhas
Passionate about exponential technologies, personal growth, and children education.
As a CTO of HotelQuickly, I was responsible for our product & engineering, technical infrastructure, and databases. Before joining HotelQuickly, I spent four years working as a data warehouse consultant, developing and optimizing data marts.
I have a strong background in databases, ETL tools, business intelligence (BI) solutions, and new trends in software development, so I run a course "Practice advanced SQL queries with MySQL 5.7+"
As a father of two kids, I'm passionate about early childhood education methods, and kids acceleration. I run a course "Boost your kids' intelligence, teach them encyclopedic facts."
More courses by Michal Juhas
Software Development Lifecycle & Methodologies (2019)
4.4 (359 Reviews)
Provider: Udemy
Time: 2.6h
$11.99
Original price
More MySQL courses
MySQL Database Administration: Beginner SQL Database Design (2026)
4.7 (3,519 Reviews)
Provider: Udemy
Time: 7h
$13.99
Original priceCreate a Netflix clone from Scratch: JavaScript PHP + MySQL (2021)
4.7 (933 Reviews)
Provider: Udemy
Time: 11.7h
$11.99
Original priceMastering SQL (Using MySQL, Java, and Go) (2019)
4.7 (135 Reviews)
Provider: Udemy
Time: 20.8h
$11.99
Original priceSQL - Introduction to SQL with MySQL (2025)
4.6 (16,588 Reviews)
Provider: Udemy
Time: 3.1h
$11.99
Original priceSQL for Data Analysis: Beginner MySQL Business Intelligence (2026)
4.6 (10,696 Reviews)
Provider: Udemy
Time: 4.5h
$29.99
Original priceDatabase Design and MySQL (2015)
4.6 (1,669 Reviews)
Provider: Udemy
Time: 10.2h
$11.99
Original price
Reviews
By Claire Dyard
Jusqu'ici, ce cours correspond parfaitement à ce que j'attends. De la précision, de la rigueur, des bases de données importantes... Et la promesse d'avoir beaucoup, beaucoup à apprendre encore.
By Michal
Definitely is good to take that course. It helps quite a lot when you are dealing with more advanced SQL like UDF and functions. As stated few times by Michal, that is advanced course, so you do not find how to write basic queries here.
Michal is not a teacher neither native English speaker which you will spot right away. But I do not see it as a problem. Instead of, Michal is really experienced user. That is the most important when you are looking for advanced staff, teachers know theory, Michal know practice - that you will also spot right away.
I like the most:
- coding practice
- exercises
- topics discussed
Could be better:
- way of talking & when presenting sometimes some part is not visible on the screen
- add more content, more videos & make that course really comprehensive advanced SQL course best on udemy
- jumping between Atom, MySQL, PostgreSQL can be sometimes a bit confusing
However, course definitely recommended once you know the basic.
Regards
Michal
By Eric
He teaches with a great passion and really pulls you in. Wish we had the MD files, just for ease of use, but as a senior level developer, i am watching this with so many ideas on to 'level up' my junior members. I will be strongly suggesting this course to them all.
By Lessner Garcia
Es un curso muy útil, se aprende a escribir un buen código y entendible, así como afianzar conocimientos con lo que se cuenta.
Espero otro curso de Michal con cubos.
By Brian Alan García Garibay
Muy buen curso, la manera de explicar de Michal es muy buena, los temas son muy útiles y en general es un muy buen curso para las personas que nos gusta hacer más que un simple query, ¡Excelente!
By Tomáš Vaverka
Information in course are in-depth and well understandable. I recomend it to everyone interested in advanced MySQL techniques.
But in some lectures I wasn't satisfied with form of presentation. Zooming in/out and webcam image caused hiding of content which Michal talked about. But it's nothing big if you listen what Michal is saying.
By Andrew Riznyk
Great course for SQL - I was expecting MORE optimization and normalization, concerning database design and implementation.
This course does cover the steps to take to speed up queries; before my queries were trial and error when trying to optimize run times. now i can read how the database will perform a query and modify it to speed up execution time.
By Ricardo Granda Vásquez
I like the course because it really clarifies what I didn't know about mysql. It's true that MySql is more an issue of practice, but I have already the knowledge.
As mentioned before, it didn't look good to have downloaded the information from Mysql Website (or blogs) and make them PDF, not because of the information itself, but because it's like the author didn't want to expend time to make their own.
Another thing I didn't like it's that the author, in one of the first videos (introductory video If I'm not wrong) strongly insist in not to start the course if we don't have all the environment ready, which includes postgresql, at least in the introduction. I took several hours trying to install the DB in postgresql and, as I didn't succeed, I contacted the author and he replied saying that the course It's not for postgresql and the DB provided wouldn't work on it. He should clarify that or, in case, don't include that in the introduction.
Overall the course is good, in my case because I was a Mysql Newbie.
By Dusan Kostic
Let's be clear: If you used only basics of the sql, you will definitely learn lots of new stuff here. This is definitely not the introductory course to MySQL and author will not waste your time by explaining basics to you. Author is very knowledgeable about the topic and you will surely learn, at least how to write well structured queries, and you can apply those immediately in your work. In first 3 chapters you will have a lot of explanations and practices to keep you busy.
However, there are some things that needs to be addressed:
Course description does not specify that this is MacOS friendly version. Windows users will need to invest some time to setup sample database as author did not provided any information on how to do this on Windows machine. No information on how to combine split sample database file or how to extract tar.gz format in Windows, so you will have to search for a way for it (Total Commander can solve all these, for example). Author did not provided any Windows alternatives for MySQL GUI tools (MySQL Workbench worked for almost all situations). Yes, this is not a course about usage of the gui tools, but author, surely cannot expect us to write such advanced queries in command line.
Presentation of the material could be done better. There are tables from sample database that are empty, yet they are required for practices. Code cannot be copied from pdf to sql editor without removing clutter that crashes the query (e.g. found when query spans on two pages). Important parts of video presentations are sometimes blocked by author's cam or not visible as incorrect portion of presentation is zoomed in. Also, all these pdfs with carbon copies of mysql documentation (S**-R** label) should be placed in one lecture per chapter as those lectures does not serve any purpose other then to raise count of total lectures in course.
At the end, it seems that this course is released unfinished. However, I get the idea that the author wanted to teach us very advanced topics that most of us were never aware that they even existed. I thank him for pointing on those to me.
Foundation for this course is good, just I wished that presentation was better. Otherwise I would not have any problem giving this a 5 star.
By Sagar Anvekar
Overall a Good Course. Loved the Coding Practices as they were a little difficult and makes you think alot
By Ahmed Ashraf
maybe didn't feel the powerfull yet .. i think this is because of my knowledge with mysql
By Pavel Grančič
Great course for advanced level. More content would be welcomed.







