Database Engineer Final Project
Learn to build a MySQL database for Little Lemon restaurant. Develop skills in data modeling, querying, visualization, and client application development.
Learn to build a MySQL database for Little Lemon restaurant. Develop skills in data modeling, querying, visualization, and client application development.
In this comprehensive course, you'll create a complete database solution for the Little Lemon restaurant, applying advanced database engineering skills. The project combines multiple skills from the Meta Database Engineer Certificate program to solve a real-world problem. You'll design and implement a database solution from scratch, setting up a MySQL server instance, creating an ER diagram model, implementing virtual tables, stored procedures, and prepared statements. The course also covers developing a table reservation system, creating sales reports, and building a database client using Python. Additionally, you'll learn to visualize restaurant data using Tableau, creating interactive dashboards for sales and profit analysis. Through hands-on assignments and practical implementation, you'll demonstrate proficiency with essential tools including Git, MySQL Workbench, Tableau, and Python.
Instructors:
Spanish
English
Powered by
What you'll learn
Configure a MySQL database project from scratch
Create and implement an Entity-Relationship diagram model
Develop optimized queries using virtual tables, stored procedures and prepared statements
Build a table reservation system with SQL
Create interactive sales dashboards with Tableau
Develop a database client application with Python
Skills you'll gain
This course includes:
0.5 Hours PreRecorded video
25 assignments
Access on Mobile, Tablet, Desktop
Batch access
Shareable certificate
Closed caption
Top companies offer this course to their employees
Top companies provide this course to enhance their employees' skills, ensuring they excel in handling complex projects and drive organizational success.
There are 4 modules in this course
This final project course for the Meta Database Engineer certificate provides hands-on experience creating a complete database solution for the Little Lemon restaurant. Students will apply multiple skills learned throughout the certificate program to design and implement a fully functional database system. The project is structured across four modules, each focusing on different aspects of database engineering. Students will set up a MySQL server instance, create an ER diagram model, implement SQL queries for sales reporting and table reservations, visualize data with Tableau, and develop a database client application using Python. The course integrates version control using Git, ensuring professional project management. By completing this practical, real-world project, students demonstrate their ability to design and implement comprehensive database solutions.
Información del proyecto
Module 1 · 4 Hours to complete
Consultas, procedimientos y sentencias preparadas de bases de datos
Module 2 · 4 Hours to complete
Clientes y visualización
Module 3 · 3 Hours to complete
Evaluación del proyecto
Module 4 · 2 Hours to complete
Fee Structure
Instructor
Taught by Meta Staff
Meta offers a range of courses designed to deepen expertise in key areas of software development, including APIs, advanced data modeling, and advanced programming in Kotlin. These courses are taught by Meta's experienced staff, providing learners with valuable insights and practical skills needed to excel in the tech industry. The APIs course covers the fundamentals of building and working with APIs, which are essential for modern web and mobile applications.
Testimonials
Testimonials and success stories are a testament to the quality of this program and its impact on your career and learning journey. Be the first to help others make an informed decision by sharing your review of the course.
Frequently asked questions
Below are some of the most commonly asked questions about this course. We aim to provide clear and concise answers to help you better understand the course content, structure, and any other relevant information. If you have any additional questions or if your question is not listed here, please don't hesitate to reach out to our support team for further assistance.