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!

Bu egzersiz

ETL and ELT in Python

kursunun bir parçasıdır

Kursu Görüntüle

Egzersiz talimatları

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.

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

import sqlalchemy

# Create a connection to the sales database
db_engine = sqlalchemy.____("postgresql+psycopg2://repl:password@localhost:5432/____")

# Query the sales table
raw_sales_data = pd.____("____", db_engine)
print(raw_sales_data)

Kodu Düzenle ve Çalıştır