Database Engineer Capstone (Coursera)

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.