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:
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 InfoThis course comprises four modules that cover database configuration, report generation, table reservation system development, data analysis and visualization, and project assessment.
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.
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.
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.
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.
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 is a comprehensive course focusing on data visualization, visual analytics, and advanced business intelligence topics...
Learn to explore your ecommerce dataset using SQL in Google BigQuery. Access and query data, remove duplicates, and execute queries.
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....