SQL from Zero to Hero - The Ultimate Guide to SQL Data Analysis

In this class, you’ll learn about everything about SQL, the most popular data analysis tool in both the Analytics and the Data Science industry.

By the end of this course, you will be able to confidently:

Read and write queries
Analyse data using various of functions and operations, from basic to advanced
Visualise data in a meaningful way
Present finding to create impact using data
And most importantly… to use SQL to solve real life problems!

This class also comes with 100+ carefully selected questions and each comes with a suggested solution, allowing you put what you've learned in practice.

There is no prerequisite for this class. This is a class created for absolute beginners who have passion in learning SQL!

Hands-on Class Project

The class project is to complete questions in the Problem Set after each lesson. Solution and explanation for each question can be found here.

You can find all data sets and the data config file in the Resource section.

A few things that might be worth noting:

There are always multiple ways to get the correct results. Your query may be correct even if it is different from the query in the solution. Check if both queries give the same results.
Questions that have the [Advanced] tag are either more challenging or require knowledge from multiple lessons. There will be detailed explanations for each advanced question.