Reading from SQL databases in Data Analysis Python - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the main Python library used to read data from SQL databases into a DataFrame?

The main Python library used is pandas, specifically the read_sql() or read_sql_query() functions.

beginner

What is a database connection string and why is it important?

A connection string is a text that contains information needed to connect to a database, like server address, database name, username, and password. It allows Python to access the database.

beginner

How do you execute a SQL query in Python to get data from a database?

You use pandas.read_sql_query(sql_query, connection) where sql_query is your SQL command and connection is the database connection object.

intermediate

What is the role of the SQLAlchemy library in reading from SQL databases?

SQLAlchemy helps create a database engine which manages the connection to the database. It works well with pandas to read data easily.

beginner

Why is it important to close a database connection after reading data?

Closing the connection frees up resources and avoids locking the database. It keeps your program and database running smoothly.

Which pandas function is used to read data from a SQL query?

A read_sql_query()

B read_csv()

C read_excel()

D read_json()

The function read_sql_query() reads data from a SQL query into a DataFrame.

What does a database connection string NOT usually include?

A Server address

B Username

C Database name

D Python version

Python version is not part of the connection string; it includes database name, username, password, and server address.

Which library helps create a database engine for connections?

A SQLAlchemy

B Matplotlib

C NumPy

D Seaborn

SQLAlchemy creates database engines to manage connections.

What is the correct order to read data from SQL in Python?

A Write SQL query, create connection, read data

B Create connection, write SQL query, read data

C Read data, write SQL query, create connection

D Create connection, read data, write SQL query

First create the connection, then write the SQL query, then read data using pandas.

Why should you close a database connection after use?

A To restart the computer

B To speed up the SQL query

C To save memory and avoid database locks

D To delete the database

Closing the connection saves resources and prevents locking issues.

Explain the steps to read data from a SQL database into a pandas DataFrame.

Think about connecting, querying, reading, and closing.

Describe the role of SQLAlchemy when working with SQL databases in Python.

Focus on connection management and integration with pandas.