Welcome to the SQL Tutorial

Learn to answer questions with data using SQL. No coding experience necessary.

Basic SQL

Introduction
The SQL Tutorial for Data Analysis
Learn to answer questions with data to solve challenging problems.
Start Now
Lesson 1
Using SQL in Mode
Learn to use Mode's Query Editor to run SQL queries against data in a relational database.
Start Now
Lesson 2
SQL SELECT
The SQL SELECT statement is used to retrieve data from a database based on criteria specified in the query.
Start Now
Lesson 3
SQL LIMIT
Use the SQL LIMIT command to restrict how many rows a SQL query returns.
Start Now
Lesson 4
SQL WHERE
Use the SQL WHERE clause to filter data.
Start Now
Lesson 5
SQL Comparison Operators
Use SQL comparison operators like =, <, and, > to filter numerical and non-numerical data.
Start Now
Lesson 6
SQL Logical Operators
SQL logical operators allow you to filter results using several conditions at once.
Start Now
Lesson 7
SQL LIKE
An introduction to the LIKE operator, which matches similar values.
Start Now
Lesson 8
SQL IN
Use the SQL IN operator in the WHERE clause to filter data by a list of values.
Start Now
Lesson 9
SQL BETWEEN
Use the SQL BETWEEN operator to select values from a specific range.
Start Now
Lesson 10
SQL IS NULL
Use SQL's IS NULL operator to select rows that have no data in a given column.
Start Now
Lesson 11
SQL AND
Use the SQL AND operator to select rows that satisfy two or more conditions.
Start Now
Lesson 12
SQL OR
Use the SQL OR operator to select rows that satisfy either of two conditions.
Start Now
Lesson 13
SQL NOT
Use the SQL NOT operator to select rows for which a certain conditional statement is false.
Start Now
Lesson 14
SQL ORDER BY
See code and examples of using SQL ORDER BY to sort data.
Start Now

Intermediate SQL

Advanced SQL

SQL Analytics Training

LIVE WEEKLY GROUP DEMO

Get to know Mode

Get a firsthand look at how Mode helps data teams deliver high-impact ad hoc analysis and self-service reporting in one platform.

Welcome to the SQL Tutorial

Basic SQL

The SQL Tutorial for Data Analysis

Using SQL in Mode

SQL SELECT

SQL LIMIT

SQL WHERE

SQL Comparison Operators

SQL Logical Operators

SQL LIKE

SQL IN

SQL BETWEEN

SQL IS NULL

SQL AND

SQL OR

SQL NOT

SQL ORDER BY

Intermediate SQL

Putting it together

SQL Aggregate Functions

SQL COUNT

SQL SUM

SQL MIN/MAX

SQL AVG

SQL GROUP BY

SQL HAVING

SQL CASE

SQL DISTINCT

SQL Joins

SQL INNER JOIN

SQL Outer Joins

SQL LEFT JOIN

SQL RIGHT JOIN

SQL Joins Using WHERE or ON

SQL FULL OUTER JOIN

SQL UNION

SQL Joins with Comparison Operators

SQL Joins on Multiple Keys

SQL Self Joins

Advanced SQL

Leveling up

SQL Data Types

SQL Date Format

Data Wrangling with SQL

Using SQL String Functions to Clean Data

Writing Subqueries in SQL

SQL Window Functions

Performance Tuning SQL Queries

Pivoting Data in SQL

SQL Analytics Training

About Analytics Training

Investigating a Drop in User Engagement

Investigating a Drop in User Engagement: Answers

Understanding Search Functionality

Understanding Search Functionality: Answers

Validating A/B Test Results

Validating A/B Test Results: Answers

SQL Tutorial Conclusion

Get to know Mode