Database Engineer Capstone

In this course you’ll complete a capstone project in which you’ll create a database and client for Little Lemon restaurant. To complete this course, you will need database engineering experience. The Capstone project enables you to demonstrate multiple skills from the Certificate by solving an authentic real-world problem. Each module includes a brief recap of, and links to, content that you have covered in previous courses in this program. In this course, you will demonstrate your new skillset by designing and composing a database solution, combining all the skills and technologies you've learned throughout this program to solve the problem at hand. By the end of this course, you’ll have proven your ability to: -Set up a database project, -Add sales reports, -Create a table booking system, -Work with data analytics and visualization, -And create a database client. You’ll also demonstrate your ability with the following tools and software: -Git, -MySQL Workbench, -Tableau, -And Python.

• Project info
• This module provides practical hands on experience with using MySQL. Set up a MySQL instance server in MySQL Workbench, then create an ER Diagram data model and implement it in MySQL.
• Database queries procedures and prepared statements
• Use SQL to create virtual tables, stored procedures and prepared statements for Little Lemon restaurant.
• Clients and visualization
• Visualize the sales data of a restaurant and implement a database client in Python.
• Project Assessment
• Complete a peer review of the Little Lemon database project and reflect on what you have learned.