1. Learn
  2. /
  3. Courses
  4. /
  5. ETL and ELT in Python

Connected

Exercise

Pulling data from SQL databases

SQL databases are one of the most used data storage tools in the world. Many companies have teams of several individuals responsible for creating and maintaining these databases, which typically store data crucial for day-to-day operations. These SQL databases are commonly used as source systems for a wide range of data pipelines.

For this exercise, pandas has been imported as pd. Best of luck!

Instructions

100 XP
  • Update the connection URI to create a connection engine for the sales database, using sqlalchemy.
  • Query all rows and columns of the sales table and output the results.