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!
-- Select all entries from the books table
SELECT *
FROM departmentsClick "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.
SELECT title
FROM booksUse * to select all fields from a table.
SELECT *
FROM booksUse AS to rename columns with an alias.
SELECT title AS book_title
FROM booksUse DISTINCT to select unique records or combinations of records.
SELECT DISTINCT author
FROM booksUse LIMIT to limit the results of your query to a specified number of rows.
SELECT title
FROM books
LIMIT 5Query other data
Want to continue to practice your SQL skills with different data? Try out the following: