Coursera Database Engineering Capstone Project - October 2023
This project is the capstone for the Coursera Database Engineering Professional Certificate. It demonstrates the application of SQL and database engineering principles to solve real-world problems.
- Design and implement a relational database for a restaurant management system (Little Lemon).
- Write SQL scripts for creating and managing database tables.
- Develop and optimize SQL queries for data analysis and reporting.
- Use stored procedures and functions to automate repetitive tasks.
- Visualize data using Tableau for insights and business decisions.
- SQL: for database creation, manipulation, and querying.
- MySQL: as the database management system (DBMS).
- Tableau: for data visualization and dashboard creation.
- Jupyter Notebooks: for executing SQL queries with MySQL connector.
- ER Diagrams: Database design visualizations.
- SQL Scripts: For database creation, data insertion, and queries.
- Stored Procedures: Predefined routines for common operations.
- Tableau Dashboards: Visual analysis of the restaurant’s data.
- Jupyter Notebooks: Interactive environments to execute SQL code.
- Clone this repository to your local machine.
- Import the SQL scripts into a MySQL database.
- Use the stored procedures and queries provided to interact with the database.
- Open the Tableau files for data visualization.
- Adding more advanced queries for predictive analytics.
- Optimizing existing SQL queries for performance.
- Integrating the system with a web application for real-time data interaction.
- Project Overview: High-level description of the project and its purpose.
- Project Objectives: Specific tasks and goals accomplished in the project.
- Technologies Used: Listing tools and technologies employed.
- Project Contents: Detailed explanation of what files or folders contain.
- How to Run the Project: Step-by-step instructions for others who might want to use or replicate your work.
- Future Improvements: Potential upgrades or next steps.