Introduction to SQL
  • AI Chat
  • Code
  • Report
    • Beta
    Spinner

    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.

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

    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.
    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.
    Unknown integration
    DataFrameavailable as
    df1
    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.
    Unknown integration
    DataFrameavailable as
    df2
    variable
    
SELECT *
FROM books
Limit 10;
    This query is taking long to finish...Consider adding a LIMIT clause or switching to Query mode to preview the result.