Skip to content
Introduction to SQL

Introduction to SQL Sandbox

👋 Welcome to your new workspace! You can use this interactive notebook to take notes, explore the course data, and practice your SQL skills!

The books table from Introduction to SQL is available for you to query in the SQL cell below! Click inside the cell and press "Run" to execute the pre-written query or write your own query!

Spinner
DataFrameavailable as
books
variable
-- Select all entries from the books table
SELECT * 
FROM books

Click "Add markdown" to add and edit text cells for notes, and "Add SQL" to continue practicing your queries!

Introduction to SQL Interactive Cheat Sheet

Below are some interactive examples of things you learned from the course. Bookmark this page as a reference and a place to experiment with queries!

Use SELECT and FROM to retrieve rows from a specified table or view.

Spinner
DataFrameavailable as
df
variable
SELECT title
FROM books

Use * to select all fields from a table.

Spinner
DataFrameavailable as
df
variable
SELECT *
FROM books

Use AS to rename columns with an alias.

Spinner
DataFrameavailable as
df
variable
SELECT title AS book_title
FROM books

Use DISTINCT to select unique records or combinations of records.

Spinner
DataFrameavailable as
df
variable
SELECT DISTINCT author
FROM books

Use LIMIT to limit the results of your query to a specified number of rows.

Spinner
DataFrameavailable as
df
variable
SELECT title
FROM books
LIMIT 5

Query other data

Want to continue to practice your SQL skills with different data? Try out the following: