We may earn an affiliate commission when you visit our partners.

Database Engineer Capstone

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.

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.

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.

Enroll now

Or subscribe to Coursera Plus

And get unlimited access to Coursera

What's inside

Syllabus

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.

Database queries procedures and prepared statements

Use SQL to create virtual tables, stored procedures and prepared statements for Little Lemon restaurant.

Clients and visualization

Visualize the sales data of a restaurant and implement a database client in Python.

Project Assessment

Complete a peer review of the Little Lemon database project and reflect on what you have learned.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Teaches practical expertise in database technologies, which is industry-standard for many applications, from healthcare and education systems to marketing and entertainment

Taught by Meta Staff, who are recognized for their work in the field of database engineering

Develops multiple skills in database engineering, which are core skills for data analysts, database administrators, and software engineers

Examines diverse tools and software, including Git, MySQL Workbench, Tableau, and Python, which are highly relevant to the field of database engineering

Builds a strong foundation of database engineering principles for beginners in the field

Requires database engineering experience

Save this course

Save Database Engineer Capstone to your list so you can find it easily later:

Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Database Engineer Capstone with these activities:

Review MySQL Workbench

Show steps

MySQL Workbench is a crucial tool that you'll use throughout the course. Reviewing the basics before the course begins will help you become familiar with the software and make the learning process smoother.

Browse courses on MySQL Workbench

Show steps

Review the MySQL Workbench documentation
Install MySQL Workbench and connect to a database
Create a new database and table

Solve SQL queries

Show steps

Solving SQL queries is a fundamental skill for any data engineer. This activity will help you practice writing efficient and effective queries.

Browse courses on SQL

Show steps

Find a set of SQL practice problems
Solve the problems using MySQL Workbench
Check your answers against the provided solutions

Design a database for a small business

Show steps

Designing a database is a complex but important task for any data engineer. This project will give you hands-on experience in applying the concepts you learn in the course to a real-world problem.

Browse courses on Database Design

Show steps

Identify the business requirements for the database
Create an Entity Relationship Diagram (ERD)
Implement the ERD in MySQL
Load data into the database
Test the database

Four other activities

Expand to see all activities and additional details

Show all seven activities

Volunteer at a data science hackathon

Show steps

Volunteering at a data science hackathon is a great way to apply your skills to a real-world problem and make a difference in the community.

Browse courses on Data Science

Show steps

Find a data science hackathon to volunteer at
Register to volunteer
Attend the hackathon
Help participants with their projects
Network with other data scientists

Write a blog post about database design

Show steps

Writing a blog post about database design will help you solidify your understanding of the concepts and share your knowledge with others.

Browse courses on Database Design

Show steps

Choose a topic for your blog post
Research the topic and gather information
Write a draft of your blog post
Edit and proofread your blog post
Publish your blog post

Mentor a junior data engineer

Show steps

Mentoring a junior data engineer is a great way to give back to the community and help others learn. It will also help you solidify your understanding of the concepts you've learned in the course.

Browse courses on Mentoring

Show steps

Find a junior data engineer to mentor
Set up regular meetings
Provide guidance and support
Help the mentee develop their skills
Track the mentee's progress

Build a data dashboard for a restaurant

Show steps

Building a data dashboard is a valuable skill for any data engineer. This project will give you hands-on experience in using Tableau to create visualizations that communicate data insights.

Browse courses on Data Visualization

Show steps

Gather data from a restaurant
Clean and prepare the data
Create visualizations using Tableau
Design and build a dashboard
Present your dashboard to stakeholders

Career center

Learners who complete Database Engineer Capstone will develop knowledge and skills that may be useful to these careers:

Database Administrator

A Database Administrator, also known as a DBA, is responsible for the planning, implementation, and maintenance of database systems. They ensure that databases are running smoothly and efficiently, and that data is accurate and secure. The Database Engineer Capstone course from Meta can help you develop the skills and knowledge necessary to succeed in this role, by providing hands-on experience with MySQL, SQL, and other database technologies.

See salaries and explore the career path for Database Administrator

Data Analyst

A Data Analyst is responsible for collecting, cleaning, and analyzing data to identify trends and patterns. They use this information to help businesses make informed decisions. The Database Engineer Capstone course from Meta can help you develop the skills and knowledge necessary to succeed in this role, by providing hands-on experience with data analytics and visualization tools.

See salaries and explore the career path for Data Analyst

Data Engineer

A Data Engineer is responsible for designing and building data pipelines, which are the systems that move data from one place to another. They also work with data scientists and other analysts to ensure that data is clean and accurate. The Database Engineer Capstone course from Meta can help you develop the skills and knowledge necessary to succeed in this role, by providing hands-on experience with database design and data modeling.

See salaries and explore the career path for Data Engineer

Data Scientist

A Data Scientist is responsible for using data to solve business problems. They use a variety of statistical and machine learning techniques to identify trends and patterns in data, and to build predictive models. The Database Engineer Capstone course from Meta can help you develop the skills and knowledge necessary to succeed in this role, by providing hands-on experience with data analytics and visualization tools.

See salaries and explore the career path for Data Scientist

Software Engineer

A Software Engineer is responsible for designing, developing, and maintaining software applications. They work with a variety of programming languages and technologies to create software that meets the needs of businesses and users. The Database Engineer Capstone course from Meta can help you develop the skills and knowledge necessary to succeed in this role, by providing hands-on experience with database design and data modeling.

See salaries and explore the career path for Software Engineer

Web Developer

A Web Developer is responsible for designing and developing websites. They work with a variety of programming languages and technologies to create websites that are both functional and visually appealing. The Database Engineer Capstone course from Meta can help you develop the skills and knowledge necessary to succeed in this role, by providing hands-on experience with database design and data modeling.

See salaries and explore the career path for Web Developer

Business Analyst

A Business Analyst is responsible for analyzing business processes and identifying ways to improve them. They work with stakeholders to gather requirements and develop solutions that meet the needs of the business. The Database Engineer Capstone course from Meta may be useful for this role, by providing hands-on experience with data analytics and visualization tools.

See salaries and explore the career path for Business Analyst

Project Manager

A Project Manager is responsible for planning, executing, and closing projects. They work with stakeholders to define project scope, develop project plans, and track project progress. The Database Engineer Capstone course from Meta may be useful for this role, by providing hands-on experience with project management tools and techniques.

See salaries and explore the career path for Project Manager

Systems Analyst

A Systems Analyst is responsible for analyzing and designing computer systems. They work with stakeholders to gather requirements and develop solutions that meet the needs of the business. The Database Engineer Capstone course from Meta may be useful for this role, by providing hands-on experience with database design and data modeling.

See salaries and explore the career path for Systems Analyst

Technical Writer

A Technical Writer is responsible for creating user manuals, training materials, and other documentation. They work with subject matter experts to gather information and develop clear and concise documentation. The Database Engineer Capstone course from Meta may be useful for this role, by providing hands-on experience with database design and data modeling.

See salaries and explore the career path for Technical Writer

Computer Programmer

A Computer Programmer is responsible for writing and coding computer programs. They work with a variety of programming languages and technologies to create software that meets the needs of businesses and users. The Database Engineer Capstone course from Meta may be useful for this role, by providing hands-on experience with database design and data modeling.

See salaries and explore the career path for Computer Programmer

Quality Assurance Analyst

A Quality Assurance Analyst is responsible for testing software applications to identify and fix defects. They work with developers and testers to ensure that software applications meet the quality standards of the business. The Database Engineer Capstone course from Meta may be useful for this role, by providing hands-on experience with testing tools and techniques.

See salaries and explore the career path for Quality Assurance Analyst

Database Designer

A Database Designer is responsible for designing and developing database systems. They work with stakeholders to gather requirements and develop solutions that meet the needs of the business. The Database Engineer Capstone course from Meta can help you develop the skills and knowledge necessary to succeed in this role, by providing hands-on experience with database design and data modeling.

See salaries and explore the career path for Database Designer

Data Warehouse Engineer

A Data Warehouse Engineer is responsible for designing and building data warehouses. They work with data analysts and other stakeholders to gather requirements and develop solutions that meet the needs of the business. The Database Engineer Capstone course from Meta may be useful for this role, by providing hands-on experience with data warehouse design and implementation.

See salaries and explore the career path for Data Warehouse Engineer

ETL Developer

An ETL Developer is responsible for developing and maintaining ETL (extract, transform, load) processes. They work with data engineers and other stakeholders to gather requirements and develop solutions that meet the needs of the business. The Database Engineer Capstone course from Meta may be useful for this role, by providing hands-on experience with ETL tools and techniques.

See salaries and explore the career path for ETL Developer

Reading list

We've selected 11 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Database Engineer Capstone.