datafun-05-sql

This project integrates Python and SQL. It demonstrates the skills needed to interact with a SQL database, including creating and managing a database, building a schema, performing various SQL operations, including queries with joins, filters, and aggregations, and logging to document the process.

Create Project Virtual Environment

On Windows, create a project virtual environment in the .venv folder.

py -m venv .venv
.venv\Scripts\Activate
py -m pip install pyarrow pandas requests

Freeze Requirements

py -m pip freeze > requirements.txt

Git add and commit

git add .
git commit -m "add .gitignore, cmds to readme"
git push origin main

How to Install and Run the Project

py -m pip install pyarrow
py -m pip install pandas
py -m pip install requests
py -m pip freeze > requirements.txt

Project Highlights

SQL Operations Data Used Python and SQL Integration

Schema Design & Database Creation

• Create new SQLite database file.

• Design schema with at least two related tables, including foregin key constraints.

• Utilized example data sets 'authors.csv' and 'books.csv' from module 5

Specification

This project was built to the following specification:

• datafun-05-spec