Workspace
maitri mou/

Introduction to SQL

0
Beta
Spinner

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!

Unknown integration
DataFrameavailable as
books
variable
-- Select all entries from the books table
SELECT * 
FROM books
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.

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.

Unknown integration
DataFrameavailable as
df
variable
SELECT title
FROM books
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.

Use * to select all fields from a table.

Unknown integration
DataFrameavailable as
df
variable
SELECT *
FROM books
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.

Use AS to rename columns with an alias.

Unknown integration
DataFrameavailable as
df
variable
SELECT title AS book_title
FROM books
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.

Use DISTINCT to select unique records or combinations of records.

Unknown integration
DataFrameavailable as
df
variable
SELECT DISTINCT author
FROM books
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.

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

Unknown integration
DataFrameavailable as
df
variable
SELECT title
FROM books
LIMIT 5
This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.

Query other data

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

  • AI Chat
  • Code