Course

Proyecto final de ingenieros de bases de datos

Meta

Join this engaging course and immerse yourself in the world of database engineering with a focus on real-world applications. Throughout the program, you will craft a robust database and client solution for the renowned Little Lemon restaurant. This hands-on experience will enable you to showcase your expertise in MySQL, Tableau, Python, and Git, among other essential tools and technologies.

Throughout this course, you will:

  • Design and implement a MySQL database solution for a restaurant environment
  • Create a reservation system for managing table bookings
  • Utilize advanced techniques to enhance the scalability and performance of the database project
  • Engage in data analysis and visualization using Tableau
  • Develop a database client using Python

This comprehensive course is designed to empower you with practical skills that are highly sought after in the industry. Upon completion, you will have the confidence and proficiency to tackle real-world database engineering challenges.

Certificate Available ✔

Get Started / More Info
Proyecto final de ingenieros de bases de datos
Course Modules

This course comprises four modules that cover database configuration, report generation, table reservation system development, data analysis and visualization, and project assessment.

Información del proyecto

Module 1 provides an introduction to the course, including setting up the project environment, configuring MySQL Workbench, and creating an entity-relationship model. You will also work with Git for version control and complete a project startup quiz.

Consultas, procedimientos y sentencias preparadas de bases de datos

Module 2 delves into creating sales reports and developing a table reservation system using MySQL. It also covers optimizing queries using stored procedures and prepared statements. You will conduct various preparatory checks and complete a module quiz.

Clientes y visualización

Module 3 focuses on data analysis and visualization using Tableau, along with the development of a database client using Python. This module involves setting up the Tableau workspace, creating interactive dashboards, and implementing query functions in the database client. You will perform preparatory checks and a knowledge assessment.

Evaluación del proyecto

Module 4 concludes the course with a final project review, an example of the Little Lemon database, self-assessment tasks, and a comprehensive final quiz for the entire course.

More Data Management Courses

From Data to Insights with Google Cloud 日本語版

Google Cloud

Learn to query and process petabytes of data in seconds with Google BigQuery. Gain insights into scalable data solutions and advanced SQL functions.

Business Intelligence and Visual Analytics

University of California, Irvine

Business Intelligence and Visual Analytics is a comprehensive course focusing on data visualization, visual analytics, and advanced business intelligence topics...

Exploring Your Ecommerce Dataset with SQL in Google BigQuery

Google Cloud

Learn to explore your ecommerce dataset using SQL in Google BigQuery. Access and query data, remove duplicates, and execute queries.

Python Project for Data Engineering

IBM

Showcase your Python skills in this hands-on Data Engineering Project. Apply ETL techniques, web scraping, and APIs to extract, transform, and load data using Python....