Database Engineer Capstone from Coursera

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 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.

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

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

Database Engineer Capstone

What's inside

Syllabus

Good to know

Save this course

Career center

Reading list

Share

Similar courses