SQL Beginner to Guru: MySQL Edition - Master SQL with MySQL (Udemy.com)
SQL skills are in demand. Learn to master SQL using MySQL. Become a SQL Guru today!
Created by: John Thompson
Last updated August 2026
Our take
Based on the ratings of 1,150 students, a sample of their written reviews and the syllabus, as the course stood in August 2026. No course pays to be reviewed.
John Thompson's course is a beginner's tour of SQL on MySQL. It runs about 11 hours across 168 lectures and 16 sections. It starts with installing MySQL and Workbench, then moves through selecting, grouping, joins, inserts, updates, deletes, transactions, views and creating tables. It was last updated in August 2026, so the setup material should be reasonably current. More than 20,000 students have taken it, and the people who get the most from it have never written a query before.
Reviewers keep coming back to the teaching. They describe John as clear, detailed and well paced, and several like the assignments because they force real practice. The complaints are consistent too. The title promises a guru, and some three-star reviewers say it does not deliver one. Triggers and procedures are missing, sub-selects go by quickly, and one experienced user found the assignments jump in difficulty. One reviewer called it so basic that free web tutorials would do.
Of the 1,150 ratings, 630 are five stars and 393 are four, so most students leave happy. Treat it as a solid first course, not a finishing one. The Slack community, GitHub code and downloadable slides are useful extras, though one reviewer said old questions went unanswered. Anyone chasing advanced features or performance work will need a second course afterward. For a true beginner, starting here carries little risk.
Pros
- Instructor explains each step in order, and reviewers single out his clear voice and pace
- Assignments let beginners practice right after each section's lessons
- Goes past SELECT into joins, transactions, views and building tables
- Refreshed in 2026, with Slack community, GitHub code and PDF slides included
Cons
- Title oversells it: reviewers note no triggers or procedures, so no guru at the end
- Sub-selects get a quick pass, and one assignment jumps sharply in difficulty
- Experienced users find it basic, and on-screen mistakes can dent confidence
Great course if you don't have any experience with MySQL. John is a great instructor, the course is pretty well organized.
Built for true beginners. The only requirement is basic comfort with files and folders.
What you will learn
- Become a SQL Guru! Be that 'go-to' person!
- Master SQL to create reports from realistic MySQL databases
- See how to aggregate and analyze data using SQL functions
- Create your own database through the power of SQL
- Understand How to Leverage Database Transactions
- Tune SQL statements for optimum performance
- Avoid common mistakes with SQL
Course content
16 sections · 168 lectures · 11 hours of video 3 quizzes, 10 articles
- 1SQL Beginner to Guru MySQL Edition Introduction 3 free previews5 lectures · 28 min
- 2Introduction to SQL 5 free previews11 lectures · 1.3 hours
- 3Installation of MySQL 5 free previews9 lectures · 28 min
- 4Connecting to MySQL 3 free previews9 lectures · 31 min
- 5Selecting Data from a Single Table 12 free previews28 lectures · 2 quizzes · 2.1 hours
- 6Grouping and Summarizing Data with SQL 3 free previews10 lectures · 1 quiz · 29 min
- 7Using SQL to Select Data from More Than One Table 3 free previews16 lectures · 1.1 hours
- 8Using SQL to Insert Data 4 free previews11 lectures · 33 min
- 9Using SQL to Update Data 3 free previews11 lectures · 24 min
- 10Using SQL to Delete Data 1 free preview6 lectures · 19 min
- 11Using SQL Transactions 1 free preview10 lectures · 47 min
- 12Advanced SQL Reporting 1 free preview14 lectures · 1.1 hours
- 13Introduction to DDL Statements - Creating SQL Views5 lectures · 13 min
- 14Using SQL to Create MySQL Database Tables12 lectures · 52 min
- 15Using SQL to Update Tables 2 free previews8 lectures · 29 min
- 16Appendix A3 lectures · 13 min
Who it is for
The instructor says it suits
- Anyone wishing to learn how to use SQL!
What you need before you start
- Just a computer - Any modern PC, Mac or Linux system will work!
- Fundamental computer skills are helpful (you understand what files and directories are)
How it compares
Against the other 388 rated Udemy courses in SQL on CourseDuck:
- Rating4.6 out of 5higher than 69% of them
- Reviews1,150#135 of 389 by number of reviews
- Length11.4 hourslonger than 76% of them
- Last updatedAugust 2026more recently than 90% of them
Quality Score
Overall Score : 92 / 100
Course Description
SQL is the programming language used to get data in and out of databases. Relational Databases are extremely popular with companies of all sizes.
Employers are searching for people with SQL skills. Go to any popular jobs site, and search for the keyword 'SQL'. You will see 10's of THOUSANDS of job postings.
Right now these positions are going unfilled - because companies cannot find enough people with SQL skills.
In this course, you will learn how to use SQL using the MySQL relational database - the most popular database in the world.
No previous SQL experience is needed. This course is perfect for beginners.
In this course, you will:
Learn how to install MySQL on your computer.
Learn how to install MySQL Workbench on your computer.
See how to import the famous MySQL employee database into your MySQL database.
Get hands on experience generating SQL reports.
Master SQL join statements.
Create table joins using database tables with MILLIONS of records!
See how easy it is to use SQL to update one record or many records in the database.
Learn to use SQL Sub-Selects.
Write advanced SQL reports against a ecommerce database.
Understand what database transactions are, and the tools you have to control them with MySQL.
Use SQL to create tables in your MySQL database.
Learn the MySQL syntax to alter existing database tables.
Tackle challenging real world like assignments for SQL reporting and database maintenance tasks.
Leverage using SQL views for common reports.
Course Extras
Slack Community - Join the instructor, teacher's assistants, and other students in a Slack Community exclusive to this course!
All Source Code in GitHub - Get access to all source code used in course via GitHub (no experience with GitHub necessary)
All Lecture Slides Downloadable as PDFs - Download lecture slides for study and future reference!
Other Databases?
This course is focused on using SQL with the MySQL database.
SQL is a standard, which which is supported by many other databases. The SQL skills you learn in this course can be applied to other databases such as Postgres, Oracle, and MS SQL Server.
There is a ton of demand for people with SQL skills. In the US, there are over 100,000 job openings for people with SQL skills.
Through this course, you will master SQL.
Open the door to new opportunities and enroll today!
Instructor Details
- 4.6 Rating
1,150 Reviews
John Thompson
Hi. I'm John.
I've been in the IT industry for over 25 years. Today, I specialize mainly in Java, the most successful and widely known programming language in use today. I also specialize with the Spring Framework, which the most popular open source application framework for building enterprise class applications on the Java platform. Just some of the organizations I've worked with include Visa, Kohls, Federal Home Loan Bank, and Belk Department Stores.
Through the courses I'm providing, I hope to leverage my years of experience to accelerate your learning of the Spring Framework. I'm not going to lie to you. The Spring Framework is a big framework. The environment for enterprise Java is even bigger. If you're new to Java, you have a lot to learn. I hope through the content on this web site I can accelerate your education of the Java and Spring landscape.
More courses by John Thompson
Spring Boot Microservices with Spring Cloud Beginner to Guru (2026)
4.6 (5,706 Reviews)
Provider: Udemy
Time: 42.5h
$18.99
Reviews
By Marcin Wołoszyn on 8/13/2020
The whole course is greatly presented. I belive that the most basic issues are depicted and what is more important the logic which stands behind them is explained. However do not expect being a senior-class specialist after completing all lessons. I used that course to refresh my SQL knowledge and some (or even many, but I am not an expert) essential queries are missing. Despite that fact I think it is a great way to enter the SQL world :).
By Sampath Kumar on 4/29/2020
This course is pretty useful for SQL beginners to understand basic concepts of SQL. The lectures are really good and the course has very good hands-on assignments. One thing I feel with this course is that it covers all basic concepts whereas for becoming SQL Guru, there should be some sections on advanced concepts like concurrency control, stored procedures etc.
By Marco Happe on 4/24/2020
Mein zweiter Kurs, der erste ist Spring Framework 5: Beginner to Guru. John hat eine sehr angenehme Stimme und er zeigt immer wieder Tricks wie man sich die arbeit erleichtern kann. Finde es sehr gut das er seine Fehler in den Videos lässt und man auch durch seine Fehler lernt. Finde es sehr motivierend das jemand nach 25 Jahren MySQL auch noch Fehler macht, das macht ihn menschlich und nicht zu einem Oberlehrer wie man es bei anderen Tutoren sieht. Danke John für diesen und deine anderen Kurse, jeder einzelne hilft mir weiter.
By Corrado Alfano on 2/20/2020
The course is really great overall. My only feedback was on the database name "employees" with a table inside called "employees", which at times was confusing. I would have created a db called "companyABC" with an employees table inside.. Also I would apply real world examples when it comes to some joins, updates or deletes just to have a clearer vision. This is a 10.5 hours course after a while the eyes get tired of looking at the same display on workbench. Either then that, the speech was flawless and the you kept it up, I never felt annoyed once. Really well done!
By Bilyana Bangieva on 1/30/2020
Great experience! Very well chosen content, explained very understandable and supported by a lot of examples. The assignments are challenging, which I like a lot. It gives you the opportunity to master the knowledge from each chapter. I strongly recommend the course
By David Hernández Herrera on 6/20/2019
Al principio las clases me parecieron un poco tediosas, pero ahora que ya voy por la mitad, el curso es muy agradable y practico puedes practicar lo que se que revisa en las clases y tratar de hacer tus propias sentencias para probar la funcionalidad que tienen. Ahora que he acabado el curso me parece muy útil, ya que pude reforzar los conocimientos que ya tenia y mejorar algunas practicas
By Arjen Schuurman on 4/5/2019
Excellent course by John (as always :) Only remark I have is about missing some info/explanations about indexes. He uses them several times without descent explanation. John mentions we will see it later, cause he has a whole section about it but its not in the course (yet). Hope you will add it :)
By Usman Hanif Khan on 2/16/2019
I actually landed a job through this course, I am a finance professional but thought of moving to business intelligence, i was called for an interview, before my interview i went through this course, i was completely new to SQL and programming but the step by step instructions made my life a lot easier, if you practice the assignments by yourself and go through them a few times you will get conceptually strong and would be well equipped to do data analysis using SQL. A huge huge thank you to the instructor John Thompson, I wish i could thank you in person some day. good luck guru
By Patrick Skelley on 11/28/2018
John T. is fantastic, tons of experience and gives you a high level idea of how parts of the industry have evolve. John gives options for lectures based on skill level, particularly in set up. I would have personally liked more interaction with the command line as opposed to workbench and some talk on how to be command line efficient in SQL in the workplace. That's the only reason I'm giving 4.5 stars. One other thing, I speed up videos at least 1.5 or 1.75x speed.
By Maciej Kraśkiewicz on 7/24/2018
It is my third course of John, and for the third time I am satisfied with the content. As always you get tons of information, and what is very important for me: Assignments - Part of the course, when you can challange yourself and see that you really learned something new. MySQL was something new for me, but topics were covered in a nice way, from the beginning to more advanced topics.
i am completely new to MySQL. His tutorials helping me understand basics. thanks for help









