Skip to content

Introduction to SQL

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

Codes

SELECT * to select all fields in the table.

Good to start new work/ by going through client's database schema.

When we've got this type of vast and interrelated data, SQL is excellent for targeting and returning only the data which is relevant to our business question.

Spinner
DataFrameas
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.