Danny's Diner

Introduction

Danny seriously loves Japanese food so in the beginning of 2021, he decides to embark upon a risky venture and opens up a cute little restaurant that sells his 3 favourite foods: sushi, curry and ramen.

The restaurant has captured some very basic data from their few months of operation but have no idea how to use their data to help them run the business.

Project Insights

** Entity Relationship Diagram **

For this project, I leveraged my SQL skills to analyze and manipulate data to answer complex business questions. I used a variety of SQL functions and techniques, including :

• Select
• Joins
• Where
• Group by
• Order by
• Aggregate functions
• CTE
• Windows functions.

To store and manage the data, I used MySQL DBMS, which proved to be a reliable and powerful tool throughout the project. You can find my solution to the case study on this GitHub repository: https://github.com/Shishinyy/DannysDiner

Overall, this project was an amazing learning experience, and I'm looking forward to applying these skills in future projects.