Name: Database Engineer Capstone
Rating: 4.3

This course is part of the Meta Database Engineer Professional Certificate

4.3

stars

10 ratings

Taught by Meta Staff

1,973 already enrolled

Offered By

Meta Database Engineer Professional CertificateMeta

About this Course

21,919 recent views

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.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

Course 8 of 9 in the

Meta Database Engineer Professional Certificate

Intermediate Level

To complete this course, you will need database engineering experience.

Approx. 15 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

What you will learn

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

Skills you will gain

Database (DBMS)
Application development
MySQL
Django (Web Framework)
Project Management

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

Course 8 of 9 in the

Meta Database Engineer Professional Certificate

Intermediate Level

To complete this course, you will need database engineering experience.

Approx. 15 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructor

Taught by Meta Staff

293,526 Learners

67 Courses

Offered by

Syllabus - What you will learn from this course

Week1

Week 1

4 hours to complete

Project info

4 hours to complete

3 videos (Total 10 min), 12 readings, 6 quizzes

3 videos

Introduction to the course4mProject overview and set up3mModule summary2m

12 readings

Course syllabus5mHow to be successful in this course10mChecking your project environment10mAdditional resources5mRecap: Version control5mExercise: Setting up the repository10mRecap: Database setup in MySQL Workbench and SQL basics10mExercise: Set up the MySQL instance server in MySQL Workbench30mRecap: Creating an Entity Relationship Model in MySQL Workbench10mExercise: Create an ER diagram data model and implement it in MySQL25mExercise: Committing the project30mAdditional resources5m

6 practice exercises

Readiness Check: Did you set up the Git repository?9mReadiness Check: Did you set up the MySQL instance?9mReadiness Check: Did you create and implement the correct database model?3mReadiness Check: Did you push your commits?6mKnowledge check15mModule quiz: Starting the project30m

Week2

Week 2

5 hours to complete

Database queries procedures and prepared statements

5 hours to complete

3 videos (Total 12 min), 9 readings, 9 quizzes

3 videos

Creating report queries for Little Lemon sales data3mDevelop a table booking system3mModule summary4m

9 readings

Recap: MySQL virtual tables and JOINS10mExercise: Create a virtual table to summarize data30mRecap: MySQL query optimization with stored procedures and Prepared Statements10mExercise: Create optimized queries to manage and analyze data30mAdditional resources5mRecap: SQL queries and transactions5mExercise: Create SQL queries to check available bookings based on user input30mExercise: Create SQL queries to add and update bookings30mAdditional resources5m

9 practice exercises

Readiness Check: Did you create the virtual table with the correct JOINS?9mReadiness Check: Did you create the correct optimized queries?9mReadiness Check: Did you commit your progress to Git?15mKnowledge check15mReadiness Check: Testing the available bookings queries9mReadiness Check: Testing new booking queries3mReadiness Check: Did you commit your progress to Git?3mKnowledge check15mModule quiz: Database queries, procedures and prepared statements30m

Week3

Week 3

4 hours to complete

Clients and visualization

4 hours to complete

3 videos (Total 11 min), 8 readings, 8 quizzes

3 videos

Data analytics and visualization3mCreating a database client3mModule summary3m

8 readings

Recap: Working with Tableau10mExercise: Set up the Tableau Workspace for data analysis10mExercise: Create interactive dashboard for sales and profits30mAdditional resources5mRecap: Python and database clients5mExercise: Set up the client project30mExercise: Add query functions30mAdditional resources5m

8 practice exercises

Readiness Check: Did you set up the Tableau Workspace and prepare data?3mReadiness Check: Did you create a dashboard with suitable worksheets?3mKnowledge check15mReadiness Check: Did you set up the Python project for the database client?3mReadiness Check: Did you implement the functions to the query database?3mReadiness Check: Did you commit your progress to Git?3mKnowledge check15mModule quiz: Clients and visualization30m

Week4

Week 4

3 hours to complete

Project Assessment

3 hours to complete

2 videos (Total 8 min), 3 readings, 3 quizzes

About the Meta Database Engineer Professional Certificate

Want to get started in the world of database engineering? This program is taught by industry-recognized experts at Meta. You’ll learn the key skills required to create, manage and manipulate databases, as well as industry-standard programming languages and software such as SQL, Python, and Django used for supporting outstanding websites and apps like Facebook, Instagram and more.

Upon completion, you’ll get access to the Meta Career Programs Job Board—a job search platform that connects you with 200+ employers who have committed to sourcing talent through Meta’s certificate programs, as well as career support resources to help you with your job search. In this program, you’ll learn: Core techniques and methods to structure and manage databases. Advanced techniques to write database driven applications and advanced data modeling concepts. MySQL database management system (DBMS) and data creation, querying and manipulation. How to code and use Python Syntax How to prepare for technical interviews for database engineer roles. Any third-party trademarks and other intellectual property (including logos and icons) referenced in the learning experience remain the property of their respective owners. Unless specifically identified as such, Coursera’s use of third-party intellectual property does not indicate any relationship, sponsorship, or endorsement between Coursera and the owners of these trademarks or other intellectual property.

Frequently Asked Questions

When will I have access to the lectures and assignments?
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.
What will I get if I subscribe to this Certificate?
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.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

Database Engineer Capstone

About this Course

What you will learn

Skills you will gain