Database Engineer Capstone

Database Engineer Capstone

Name: Database Engineer Capstone
Rating: 3.950819672131148 (61 reviews)

This course is part of Meta Database Engineer Professional Certificate

Instructor: Taught by Meta Staff

7,287 already enrolled

Included with Coursera Plus

Learn more

4 modules

Gain insight into a topic and learn the fundamentals.

4.0

(61 reviews)

Intermediate level

Recommended experience

18 hours to complete

3 weeks at 6 hours a week

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

4.0

(61 reviews)

Intermediate level

Recommended experience

18 hours to complete

3 weeks at 6 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Build a MySQL database solution.
Deploy level-up ideas to enhance the scope of a database project.

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

25 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Build your Data Management expertise

This course is part of the Meta Database Engineer Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from Meta

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 4 modules in this course

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.

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.

What's included

3 videos12 readings6 assignments1 discussion prompt

3 videosTotal 10 minutes

Introduction to the course4 minutesPreview module
Project overview and set up3 minutes
Module summary2 minutes

12 readingsTotal 155 minutes

Course syllabus5 minutes
How to be successful in this course10 minutes
Checking your project environment10 minutes
Additional resources5 minutes
Recap: Version control5 minutes
Exercise: Setting up the repository10 minutes
Recap: Database setup in MySQL Workbench and SQL basics10 minutes
Exercise: Set up the MySQL instance server in MySQL Workbench30 minutes
Recap: Creating an Entity Relationship Model in MySQL Workbench10 minutes
Exercise: Create an ER diagram data model and implement it in MySQL25 minutes
Exercise: Committing the project30 minutes
Additional resources5 minutes

6 assignmentsTotal 92 minutes

Readiness Check: Did you set up the Git repository?9 minutes
Readiness Check: Did you set up the MySQL instance?9 minutes
Readiness Check: Did you create and implement the correct database model?3 minutes
Readiness Check: Did you push your commits?6 minutes
Knowledge check15 minutes
Module Quiz: Starting the Project50 minutes

1 discussion promptTotal 10 minutes

Meet and greet10 minutes

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

What's included

3 videos9 readings9 assignments

3 videosTotal 11 minutes

Creating report queries for Little Lemon sales data3 minutesPreview module
Develop a table booking system3 minutes
Module summary4 minutes

9 readingsTotal 155 minutes

Recap: MySQL virtual tables and JOINS10 minutes
Exercise: Create a virtual table to summarize data30 minutes
Recap: MySQL query optimization with stored procedures and Prepared Statements10 minutes
Exercise: Create optimized queries to manage and analyze data30 minutes
Additional resources5 minutes
Recap: SQL queries and transactions5 minutes
Exercise: Create SQL queries to check available bookings based on user input30 minutes
Exercise: Create SQL queries to add and update bookings30 minutes
Additional resources5 minutes

9 assignmentsTotal 128 minutes

Readiness Check: Did you create the virtual table with the correct JOINS?9 minutes
Readiness Check: Did you create the correct optimized queries?9 minutes
Readiness Check: Did you commit your progress to Git?15 minutes
Knowledge check15 minutes
Readiness Check: Testing the available bookings queries9 minutes
Readiness Check: Testing new booking queries3 minutes
Readiness Check: Did you commit your progress to Git?3 minutes
Knowledge check15 minutes
Module Quiz: Database Queries, Procedures and Prepared Statements50 minutes

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

What's included

3 videos8 readings8 assignments

3 videosTotal 10 minutes

Data analytics and visualization3 minutesPreview module
Creating a database client3 minutes
Module summary3 minutes

8 readingsTotal 125 minutes

Recap: Working with Tableau10 minutes
Exercise: Set up the Tableau Workspace for data analysis10 minutes
Exercise: Create interactive dashboard for sales and profits30 minutes
Additional resources5 minutes
Recap: Python and database clients5 minutes
Exercise: Set up the client project30 minutes
Exercise: Add query functions30 minutes
Additional resources5 minutes

8 assignmentsTotal 95 minutes

Readiness Check: Did you set up the Tableau Workspace and prepare data?3 minutes
Readiness Check: Did you create a dashboard with suitable worksheets?3 minutes
Knowledge check15 minutes
Readiness Check: Did you set up the Python project for the database client?3 minutes
Readiness Check: Did you implement the functions to the query database?3 minutes
Readiness Check: Did you commit your progress to Git?3 minutes
Knowledge check15 minutes
Module Quiz: Clients and Visualization50 minutes

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

What's included

2 videos3 readings2 assignments1 peer review1 discussion prompt

2 videosTotal 7 minutes

Course recap for Capstone project4 minutesPreview module
Congratulations, you have completed the Capstone project!2 minutes

3 readingsTotal 40 minutes

About the final project assessment5 minutes
Exemplar: Little Lemon database30 minutes
Next steps5 minutes

2 assignmentsTotal 171 minutes

Project self-review21 minutes
Final Graded Quiz: Database Engineer Capstone150 minutes

1 peer reviewTotal 60 minutes

Little Lemon database60 minutes

1 discussion promptTotal 10 minutes

Reflect on learning10 minutes

Instructor

Instructor ratings

3.8 (13 ratings)

Taught by Meta Staff

Offered by

Recommended if you're interested in Data Management

University of Colorado System
Database Management Essentials
Course
Meta
Database Structures and Management with MySQL
Course
IBM
SQL for Data Science with R
Course
University of Michigan
Introduction to Structured Query Language (SQL)
Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

4.0

61 reviews

5 stars
60.65%
4 stars
14.75%
3 stars
3.27%
2 stars
1.63%
1 star
19.67%

Showing 3 of 61

Reviewed on Dec 21, 2023

Gaining practical skills from this course is really commendable.

View more reviews

New to Data Management? Start here.

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:

The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.

Database Engineer Capstone

What you'll learn

Skills you'll gain

Details to know

See how employees at top companies are mastering in-demand skills

Build your Data Management expertise

Earn a career certificate

There are 4 modules in this course

Project info

What's included

Database queries procedures and prepared statements

What's included

Clients and visualization

What's included

Project Assessment

What's included

Instructor

Offered by

Recommended if you're interested in Data Management

Database Management Essentials

Database Structures and Management with MySQL

SQL for Data Science with R

Introduction to Structured Query Language (SQL)

Why people choose Coursera for their career

Learner reviews

New to Data Management? Start here.

Open new doors with Coursera Plus

Advance your career with an online degree

Join over 3,400 global companies that choose Coursera for Business

Frequently asked questions

When will I have access to the lectures and assignments?

What will I get if I subscribe to this Certificate?

What is the refund policy?

More questions