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.
Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.
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.
Course 8 of 9 in the Meta Database Engineer Professional Certificate.
What You Will Learn
- Build a MySQL database solution.
- Deploy level-up ideas to enhance the scope of a database project.
Syllabus
WEEK 1
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.
WEEK 2
Database queries procedures and prepared statements
Use SQL to create virtual tables, stored procedures and prepared statements for Little Lemon restaurant.
WEEK 3
Clients and visualization
Visualize the sales data of a restaurant and implement a database client in Python.
WEEK 4
Project Assessment
Complete a peer review of the Little Lemon database project and reflect on what you have learned.
