8 Week SQL Challenge

In my journey to switch careers into the field of Data, I am excited to undertake the #8WeekSQLChallenge, kindly created by Data with Danny in order to enhance my SQL skills. This repository will store all the solutions for the case studies included in this challenge.

Case Studies

Case Study | Topic | SQL | Status| | --- | --- | --- | --- | |📄 #1 Danny's Diner |Customer Analytics | MySQL | Completed ✔️| |📄 #2 Pizza Runner | Delivery Operations Analytics | MySQL| Completed ✔️| |📄 #3 Foodie-Fi| Subscription Analytics | MySQL| Completed ✔️| |📄 #4 Data Bank | Financial Data Storage and Usage Analytics | PostgreSQL| Completed ✔️ | |📄 #5 Data Mart | Sales Performance Analytics | PostgreSQL | Completed ✔️ | |📄 #6 Clique Bait | Digital Analytics| PostgreSQL | Completed ✔️ | |📄 #7 Balanced Tree | Sales Performance Analytics | PostgreSQL | Completed ✔️ | |📄 #8 Fresh Segments | Digital Marketing Analytics | PostgreSQL | Completed ✔️|

Technologies

Installation

For writing MySQL queries in Jupyter Notebook, we will need to install the pymysql library

pip install pymysql

For writing PostgreSQL queries in Jupyter Notebook, we will need to install the psycopg2 library

pip install psycopg2