К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Database Engineer Capstone · LearnSpace
Назад в каталог
courseraIT и технологии

Database Engineer Capstone

Курс от Meta
Средний≈ 17.9 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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.

Навыки, которые вы освоите

Git (Version Control System)MySQL WorkbenchTableau SoftwareSQLDatabase ManagementStored ProcedureMySQLData Visualization SoftwareDatabase DesignDjango (Web Framework)Code ReviewInteractive Data VisualizationProject ManagementApplication DevelopmentDatabase DevelopmentData ModelingDatabasesVersion ControlDatabase SoftwareDatabase Application

Программа курса

4 модулей · 68 учебных материалов

01Project info22 материалов

Project info

Introduction to the courseВидеоCourse syllabusЧтениеHow to be successful in this courseЧтениеChecking your project environmentЧтение

Учитесь у экспертов

Taught by Meta Experts

Преподаватель курса

Database Engineer Capstone
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 17.9 ч

4 модулей

Язык: Английский

Субтитры: Арабский, Французский, Бенгальский, Узбекский, Китайский (Китай), Греческий, Бразильский португальский, Вьетнамский, Немецкий, Пушту, Урду, Русский, Тайский, Индонезийский, Азербайджанский, Испанский, Дари, Хинди, Казахский, Венгерский

Часть программы вашего университета
Pre-Flight Check: Essential Skills for Capstone SuccessDIALOGUE
Additional resourcesЧтение

Setting up the Project

Project overview and set upВидеоRecap: Version controlЧтениеExercise: Setting up the repositoryЧтениеReadiness Check: Did you set up the Git repository?ЗаданиеRecap: Database setup in MySQL Workbench and SQL basicsЧтениеExercise: Set up the MySQL instance server in MySQL WorkbenchЧтениеReadiness Check: Did you set up the MySQL instance?ЗаданиеRecap: Creating an Entity Relationship Model in MySQL WorkbenchЧтениеExercise: Create an ER diagram data model and implement it in MySQLЧтениеReadiness Check: Did you create and implement the correct database model?ЗаданиеExercise: Committing the projectЧтениеReadiness Check: Did you push your commits?ЗаданиеKnowledge checkЗаданиеModule summaryВидеоModule Quiz: Starting the ProjectЗаданиеAdditional resourcesЧтение
02Database queries procedures and prepared statements19 материалов

Adding sales reports

Creating report queries for Little Lemon sales dataВидеоRecap: MySQL virtual tables and JOINSЧтениеExercise: Create a virtual table to summarize dataЧтениеReadiness Check: Did you create the virtual table with the correct JOINS?ЗаданиеRecap: MySQL query optimization with stored procedures and Prepared StatementsЧтениеExercise: Create optimized queries to manage and analyze dataЧтениеReadiness Check: Have you created the optimized queries and committed your progress to Git?ЗаданиеKnowledge checkЗаданиеAdditional resourcesЧтение

Table booking system

Develop a table booking systemВидеоRecap: SQL queries and transactionsЧтениеExercise: Create SQL queries to check available bookings based on user inputЧтениеReadiness Check: Testing the available bookings queriesЗаданиеExercise: Create SQL queries to add and update bookingsЧтениеReadiness Check: Did you commit your progress to Git?Задание
03Clients and visualization18 материалов

Data visualization

Data analytics and visualizationВидеоRecap: Working with TableauЧтениеExercise: Set up the Tableau Workspace for data analysisЧтениеReadiness Check: Did you set up the Tableau Workspace and prepare data?ЗаданиеExercise: Create interactive dashboard for sales and profitsЧтениеReadiness Check: Did you create a dashboard with suitable worksheets?ЗаданиеKnowledge checkЗаданиеAdditional resourcesЧтение

Database client

Creating a database clientВидеоRecap: Python and database clientsЧтениеExercise: Set up the client projectЧтениеReadiness Check: Did you set up the Python project for the database client?ЗаданиеExercise: Add query functionsЧтениеReadiness Check: Have you implemented the database query functions and committed your progress to Git?Задание
04Project Assessment9 материалов

Final project assessment

Course recap for Capstone projectВидеоAbout the final project assessmentЧтениеProject self-reviewЗаданиеLittle Lemon databaseВзаимная проверкаExemplar: Little Lemon databaseЧтениеFinal Graded Quiz: Database Engineer CapstoneЗадание

Course wrap-up

Congratulations, you have completed the Capstone project!ВидеоReflect on learningОбсуждениеNext stepsЧтение
Knowledge checkЗадание
Module summaryВидео
Module Quiz: Database Queries, Procedures and Prepared StatementsЗадание
Additional resourcesЧтение
Knowledge checkЗадание
Module summaryВидео
Module Quiz: Clients and VisualizationЗадание
Additional resourcesЧтение