SQL101 is a browser based, interactive course designed to teach you SQL through real world business scenarios. No matter what field you are in, understanding data is crucial for success. Jumpstart your career and add this highly in-demand skill to your arsenal today.
Get Started NowOur proprietary, interactive coding interface allows you to learn by doing - right in your browser. Nothing to download or set up.
Learn only the topics you need to know for immediate usage in real world situations. No theory, no fluff, only the essentials.
Over 125 exercises based on real business situations give you the foundational SQL skills you will use on the job every day.
Most analytics courses use irrelevant scenarios to teach you only the basics. SQL101 puts you through hundreds of real life scenarios designed by professional data analysts to teach you how to use SQL at an expert level in the real world.
Check your code at any point to get feedback your results. Trial & error hammers home the core concepts as you go.
Develop your SQL skills in real-time as you work your way through tough questions you will encounter in real life.
We start with the basics of every SQL query, then move on to WHERE and LIMIT, doing math with SQL, and finally how to work with decimals.
Logic is a foundational topic in SQL. This module includes operators such as AND, OR, LIKE, IN, BETWEEN, and more...
Learn what to do when data doesn't exist and how to put the data that does exist in the proper order for easy analysis.
The building blocks of reporting, aggregate functions allow you to calculate important metrics. Learn functions such as MAX, MIN, COUNT and SUM, among others.
Learn how to remove data from your results that you don't need. This includes useful functions like DISTINCT, HAVING, and CASE statements.
You will never be comfortable with SQL if you can't work with dates, numbers, and strings. This module teaches you the most effective ways to do so.
The topic that separates the beginners from the veterans -- joins. Learn about all of the useful types of joins that allow you to combine datasets with ease.
This module will make you an advanced SQL practitioner. Learn how to implement and combine multiple queries to pull complex reports and do in-depth analysis.
You cannot be a SQL expert without knowing window functions. Separate yourself from the pack by learning the ins and outs of window functions.
Learn advanced window function techniques to that will take your analysis to the next level and let you look into the "past" and "future".
Jason is the founder and creator of SQL101. He has been a senior data analyst in the New York City start-up world for nearly 10 years, helping grow multi-million dollar companies. Completely self-taught, he has a passion for teaching others the skills that helped him carve out a career in analytics.