Skip to content
New Workbook
Sign up
Introduction to SQL

Introduction to SQL

Here you can access the books table used in the course.

Note: When using sample integrations such as those that contain course data, you have read-only access. You can run queries, but cannot make any changes such as adding, deleting, or modifying the data (e.g., creating tables, views, etc.).

Take Notes

SQL - Sequence Query Language Data Types - VARCHAR, INT, FLOAT

A query is a request for data from a database.

VIEW

Add notes about the concepts you've learned and SQL cells with queries you want to keep.

Spinner
DataFrameavailable as
books
variable
-- Add your own queries here
SELECT * 
FROM books

Explore Datasets

Use the books table to explore the data and practice your skills!

  • Select only the title column.
  • Alias the title column as book_title.
  • Select the distinct author names from the author column.
  • Select all records from the table and limit your results to 10.
Spinner
DataFrameavailable as
df
variable

SELECT title AS book_title
FROM books;
Spinner
DataFrameavailable as
df1
variable
SELECT DISTINCT author
FROM books;
Spinner
DataFrameavailable as
df2
variable

SELECT *
FROM books
Limit 10;