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 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 ✔️ |
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