A Jupyter Notebook exploring the idea of ETL in big data and data science, as well as using SQLAlchemy and raw SQL queries to explore the chinook.db database.
The file can be downloaded here: http://www.sqlitetutorial.net/sqlite-sample-database/
Getting started is quick and easy. All you need is the file above, and the notebook. You will need Python 3.x, pip, Pandas, and you'll need to install the package used if you don't already have them in your Python environment.
pip install sqlalchemy
pip install pandas
Unzip the chinook.zip file into the working directory of your Jupyter Notebook, and then you're ready to connect the Sqlite engine and get started.
Check out my Medium article where I wrote about this project: https://medium.com/@rileypredum/sql-and-etl-an-introduction-to-sqlalchemy-in-python-fc66e8be1cd4