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.
Monthly Subscription Starting at AED 99 + VAT
- Level Professional
- المدة 18 ساعات hours
- الطبع بواسطة Meta
-
Offered by
عن
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.الوحدات
Project info
-
1
Videos
-
4
Readings
-
1
Discussion
1
Discussions
- Meet and greet
1
Videos
- Introduction to the course
4
Readings
- Course syllabus
- How to be successful in this course
- Checking your project environment
- Additional resources
Setting up the Project
-
2
Videos
-
8
Readings
-
6
Assignment
6
Assignment
- Readiness Check: Did you set up the Git repository?
- Readiness Check: Did you set up the MySQL instance?
- Readiness Check: Did you create and implement the correct database model?
- Readiness Check: Did you push your commits?
- Knowledge check
- Module Quiz: Starting the Project
2
Videos
- Project overview and set up
- Module summary
8
Readings
- Recap: Version control
- Exercise: Setting up the repository
- Recap: Database setup in MySQL Workbench and SQL basics
- Exercise: Set up the MySQL instance server in MySQL Workbench
- Recap: Creating an Entity Relationship Model in MySQL Workbench
- Exercise: Create an ER diagram data model and implement it in MySQL
- Exercise: Committing the project
- Additional resources
Adding sales reports
-
1
Videos
-
5
Readings
-
4
Assignment
4
Assignment
- Readiness Check: Did you create the virtual table with the correct JOINS?
- Readiness Check: Did you create the correct optimized queries?
- Readiness Check: Did you commit your progress to Git?
- Knowledge check
1
Videos
- Creating report queries for Little Lemon sales data
5
Readings
- Recap: MySQL virtual tables and JOINS
- Exercise: Create a virtual table to summarize data
- Recap: MySQL query optimization with stored procedures and Prepared Statements
- Exercise: Create optimized queries to manage and analyze data
- Additional resources
Table booking system
-
2
Videos
-
4
Readings
-
5
Assignment
5
Assignment
- Readiness Check: Testing the available bookings queries
- Readiness Check: Testing new booking queries
- Readiness Check: Did you commit your progress to Git?
- Knowledge check
- Module Quiz: Database Queries, Procedures and Prepared Statements
2
Videos
- Develop a table booking system
- Module summary
4
Readings
- Recap: SQL queries and transactions
- Exercise: Create SQL queries to check available bookings based on user input
- Exercise: Create SQL queries to add and update bookings
- Additional resources
Data visualization
-
1
Videos
-
4
Readings
-
3
Assignment
3
Assignment
- Readiness Check: Did you set up the Tableau Workspace and prepare data?
- Readiness Check: Did you create a dashboard with suitable worksheets?
- Knowledge check
1
Videos
- Data analytics and visualization
4
Readings
- Recap: Working with Tableau
- Exercise: Set up the Tableau Workspace for data analysis
- Exercise: Create interactive dashboard for sales and profits
- Additional resources
Database client
-
2
Videos
-
4
Readings
-
5
Assignment
5
Assignment
- Readiness Check: Did you set up the Python project for the database client?
- Readiness Check: Did you implement the functions to the query database?
- Readiness Check: Did you commit your progress to Git?
- Knowledge check
- Module Quiz: Clients and Visualization
2
Videos
- Creating a database client
- Module summary
4
Readings
- Recap: Python and database clients
- Exercise: Set up the client project
- Exercise: Add query functions
- Additional resources
Final project assessment
-
1
Videos
-
2
Readings
-
1
PeerReview
-
2
Assignment
2
Assignment
- Project self-review
- Final Graded Quiz: Database Engineer Capstone
1
Peer Review
- Little Lemon database
1
Videos
- Course recap for Capstone project
2
Readings
- About the final project assessment
- Exemplar: Little Lemon database
Course wrap-up
-
1
Videos
-
1
Readings
-
1
Discussion
1
Discussions
- Reflect on learning
1
Videos
- Congratulations, you have completed the Capstone project!
1
Readings
- Next steps
Auto Summary
The "Database Engineer Capstone" is an advanced course designed for professionals in the IT and Computer Science domain. This course, offered by Coursera, focuses on applying your database engineering skills to a real-world project by creating a database and client for Little Lemon restaurant. Ideal for those with prior experience in database engineering, this capstone project lets you showcase your expertise by solving practical problems. Throughout the course, you'll recap key concepts from previous modules and integrate them into your final project. Key skills developed include setting up a database project, generating sales reports, creating a table booking system, and utilizing data analytics and visualization. You'll also gain hands-on experience with essential tools and software such as Git, MySQL Workbench, Tableau, and Python. With a total duration of 1080 minutes, this professional-level course offers flexible subscription options, including Starter and Professional plans. This course is perfect for database engineers looking to solidify their skills and demonstrate their capability in handling real-world challenges.
Taught by Meta Staff