1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Importing Data in Python

Exercise

The Hello World of SQL Queries!

Now, it's time for liftoff! In this exercise, you'll perform the Hello World of SQL queries, SELECT, in order to retrieve all columns of the table Album in the Chinook database. Recall that the query SELECT * selects all columns.

Instructions

100 XP
  • Open the engine connection as con using the method connect() on the engine.
  • Execute the query that selects ALL columns from the Album table. Store the results in rs.
  • Store all of your query results in the DataFrame df by applying the fetchall() method to the results rs.
  • Close the connection!