Written SQL Lessons

CH 1Beginner

Ready to write code?

Theory is important, but coding is best learned by doing. Enter our interactive SQL sandbox to execute queries directly against our mock SaaS databases.

Enter Interactive Playground→

Written SQL Lessons

Introduction to Relational Databases and SQL

Retrieving Data with the SELECT Statement

Sorting Retrieved Data with ORDER BY

Filtering Data using the WHERE Clause

Advanced Data Filtering with Logical Operators

Pattern Matching with LIKE and Wildcards

Creating Calculated Fields and Aliases

Using Data Manipulation Functions

Summarizing Data with Aggregate Functions

Grouping Data with GROUP BY and HAVING

Understanding Subqueries

Querying Multiple Tables with INNER JOIN

Advanced Joins: Outer, Cross, and Self Joins

Combining Queries with UNION

Inserting Data into Tables

Updating and Deleting Data

Creating and Manipulating Tables

Creating and Using Views

Ready to write code?