Skip to content
Introduction to SQL
  • AI Chat
  • Code
  • Report

    • 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.

    Unknown integration
    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.