This site runs best with JavaScript enabled.
This site runs best with JavaScript enabled.
SQL Crash Course
Lessons
Switch to dark mode
All Lessons.
Lesson 1: What is SQL?
Lesson 2: The SQL SELECT Statement
Lesson 3: SELECT statement with specific columns.
Lesson 4: Filtering results with the WHERE Clause.
Lesson 5: Filtering results using the WHERE Clause and GREATER THAN.
Lesson 6: Filtering results using the WHERE Clause and the AND operator.
Lesson 7: Filtering results using the WHERE Clause and the OR operator.
Lesson 8: Filtering results using the WHERE Clause and the IN operator.
Lesson 9: Filtering results using the WHERE Clause and the NOT operator.
Lesson 10: Using wildcard comparisons with the LIKE operator.
Lesson 11: Handling Dates
Lesson 12: Removing duplicates from results with the DISTINCT keyword.
Lesson 13: Sorting results using ORDER BY.
Lesson 14: Using the CASE statement.
Lesson 15: How to LIMIT the number of results returned.
Lesson 16: Counting the number of rows returned with COUNT.
Lesson 17: Counting the number of rows returned with COUNT and the WHERE clause.
Lesson 18: Summing all values using the SUM Function.
Lesson 19: Finding the average of numerical values using the AVG function.
Lesson 20: Finding the minimum and maximum values using MIN and MAX functions.
Lesson 21: Aggregate functions using the GROUP BY clause.
Lesson 22: Using the HAVING clause to filter aggregate functions.
Lesson 23: Handling NULL values.
Lesson 24: Using the COALESCE function.
Lesson 25: Using Nested Queries
Lesson 26: Joining tables using INNER JOIN.
Lesson 27: Joining tables using LEFT JOIN.
Lesson 28: Joining tables using Multiple Joins.
Lesson 29: Joining tables using UNION joins.
Lesson 30: Using a Table Alias.
Lesson 31: Using a Column Alias.
Lesson 32: Joining tables using Self Joins.
Lesson 33: The INSERT INTO Statement
Lesson 34: The SQL UPDATE Statement
Lesson 35: The SQL DELETE Statement
Well Done!! You've Completed The SQL Crash Course