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

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

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

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

Advanced Data Modeling

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

О курсе

Develop a working knowledge and familiarity with advanced database concepts such as usage, modeling, automation, storage, optimization and administration. To take this course, you must have completed the previous Database courses. You must also be eager to continue your journey with coding. The Professional Certificates create opportunities so that anyone regardless of education, background or experience can learn high-quality skills to land a high-growth career—no degree or experience required to get started. By the end of this course, you’ll be able to: - Deploy basic data modeling skills and navigate modern storage options for a data warehouse - Apply planning and execution of ETL style database engineering by building upon existing MySQL skills - Develop a working knowledge of the different aspects of managing a database including administration of database operations and concerns, alongside processes and solutions for monitoring, reporting and debugging - Demonstrate data modeling skills within a real-world project environment You’ll gain experience with the following tools and software: - Workbench data modeling software - Syntaxes used to interact with a data warehouse - Extract, transform and loading (ETL) techniques and methods - MySQL data warehouse administration - Data warehouse monitoring and reporting tools - Database debugging and testing tools - Data modeling tools

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

Data WarehousingData ModelingMySQL WorkbenchData AnalysisExtract, Transform, LoadStar SchemaData Visualization SoftwareDatabasesAnalyticsSnowflake SchemaDashboard CreationDatabase DesignMySQLDatabase AdministrationDatabase ManagementDashboardData ArchitectureDatabase DevelopmentInteractive Data VisualizationDatabase Architecture and Administration

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

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

01Data Modeling and Management28 материалов

Course Introduction

Introduction to Advanced Data ModelingВидеоHow is data modeling used at Meta?ВидеоCourse syllabus for Advanced Data ModelingЧтениеHow to be successful in this courseЧтение

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

Taught by Meta Experts

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

Advanced Data Modeling
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 19.1 ч

4 модулей

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

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

Часть программы вашего университета
Building Your Data Modeling ExpertiseDIALOGUE
Course requirementsЧтение
Additional resourcesЧтение

Database modeling

Overview of data modelingВидеоTypes of data modelsВидеоData model exampleЧтениеRecap: Normalization of relational database modelsВидеоKnowledge Check: Database modelingЗаданиеExercise: Design a database model for this scenarioЧтениеSolution: Design a database model for this scenarioЧтениеSelf review: Design a database model for this scenarioЗаданиеAdditional resourcesЧтение

MySQL Workbench (WB)

Introduction to MySQL WorkbenchВидеоInstalling MySQL WorkbenchЧтениеData management in MySQL WorkbenchВидеоDatabase modeling in MySQL WorkbenchВидеоMySQL Workbench for data modeling and data managementЧтениеKnowledge Check: MySQL Workbench (WB)ЗаданиеExercise: Design a database model in MySQL WorkbenchЧтениеSolution: Design a database model in MySQL WorkbenchЧтениеSelf review: Design a database model in MySQL WorkbenchЗаданиеModule summary: Data modeling and managementВидеоModule Quiz: Data Modeling and ManagementЗаданиеAdditional resourcesЧтение
02Data Warehousing17 материалов

What is a data warehouse?

Overview of data warehousingВидеоData warehouse architectureВидеоThe data warehouse Extract, Transform and Load (ETL) processЧтениеCase Study: Real world data projectВидеоETL testingЧтениеKnowledge check: Data warehousingЗаданиеAdditional resourcesЧтение

Dimensional data modeling

Fundamentals of dimensional data modelingВидеоOLAP cubesЧтениеDimensional data modeling in practiceВидеоKnowledge check: Dimensional data modeling fundamentalsЗаданиеExercise: Create a dimensional data modelЧтениеSolution: Create a dimensional data modelЧтение
03Advanced Data Analytics19 материалов

Introduction to data analytics

Overview of data analyticsВидеоData mining versus machine learningВидеоThe value of data insights in businessЧтениеOverview of data visualizationВидеоWhich data analytics reports do you engage with weekly, and why?ОбсуждениеKnowledge check: Data analyticsЗаданиеAdditional resourcesЧтение

Advanced data analytics in practice

Using advanced analytic tools for data analysisВидеоGetting started with TableauЧтениеData import and data preparation in TableauВидеоData filtering and visualization in TableauВидеоCreate an interactive dashboardВидеоKnowledge check: Advanced data anlytics in practiceЗадание
04Model and Analyze Data10 материалов

Final project assessment

Course recap for Advanced Data ModelingВидеоAbout the final project assessmentЧтениеExercise: Data modeling projectЧтениеData modeling projectВзаимная проверкаSolution: Data modeling projectЧтениеFinal Graded Quiz: Advanced Data ModelingЗаданиеWhat challenges did you encounter when modeling and analyzing your data?Обсуждение

Course wrap-up

Congratulations, you have completed Advanced Data ModelingВидеоReflect on learningОбсуждениеNext steps after completing Advanced Data ModelingЧтение
Self review: Create a dimensional data modelЗадание
Module summary: Data warehousingВидео
Module Quiz: Data WarehousingЗадание
Additional resourcesЧтение
Exercise: Data analysis in TableauЧтение
Solution: Data analysis in TableauЧтение
Self review: Data analysis in TableauЗадание
Module summary: Advanced data analyticsВидео
Module Quiz: Advanced Data AnalyticsЗадание
Additional resourcesЧтение