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

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

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

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

Data Modeling, Warehouse & Documentation

Курс от Coursera
Уровень не указан≈ 16.8 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

Learn how to design, document, and implement high-quality data models through this comprehensive course in the Data Engineering Skill Path. You will develop essential competencies in relational modeling, dimensional design, schema implementation, and professional data documentation practices. Through hands-on activities, you will build data dictionaries, translate business requirements into structured models, implement star and snowflake schemas using SQL DDL, and evaluate trade-offs in warehouse architecture to support analytical workloads. This course brings together expertise from multiple IBM instructional teams, offering diverse perspectives on database fundamentals, modeling techniques, warehouse design, and the use of generative AI to assist with schema development. You will progressively move from foundational relational concepts to enterprise warehouse structures, advanced normalization, and AI-supported model optimization. The curriculum balances conceptual depth with applied practice, ensuring you can confidently design scalable, high-integrity data models for real-world environments. Perfect for aspiring data engineers and analytics professionals seeking strong skills in dimensional modeling, warehouse design, and documentation that supports performance, governance, and long-term maintainability.

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

Generative AIRelational DatabasesData ModelingData SecurityDatabasesData DictionarySQLStar SchemaData ArchitectureDatabase TheorySnowflake SchemaData GovernanceDatabase Management SystemsData ManagementData WarehousingData InfrastructureDatabase Design

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

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

01Start Here: Get Oriented and Check Your Skills2 материалов
Start Here: How This Skill-Based Course WorksЧтениеSkill Diagnostic: Find Your Recommended Starting PointЗадание
02Relational Database Concepts20 материалов

Fundamental Relational Database Concepts

Review of Data Fundamentals Видео

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

Professionals from the Industry

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

Data Modeling, Warehouse & Documentation
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 16.8 ч

6 модулей

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

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

Часть программы вашего университета
Information and Data ModelsВидео
ERDs and Types of RelationshipsВидео
Mapping Entities to TablesВидео
Data TypesВидео
Relational Model ConceptsВидео
Hands-on Lab: Relational Model ConceptsPLUGIN
Summary and Highlights Чтение
Practice Quiz: Fundamental Relational Database ConceptsЗадание

Introducing Relational Database Products

Database ArchitectureВидеоDistributed Architecture and Clustered DatabasesВидеоDatabase Usage PatternsВидеоIntroduction to Relational Database OfferingsВидеоDb2ВидеоMySQLВидеоPostgreSQLВидеоReading: Deep Dive into Advanced Relational Model ConceptsPLUGINReading: Advanced Relational Model ConceptsPLUGINSummary and HighlightsЧтениеPractice Quiz: Introducing Relational Database ProductsЗадание
03Data Engineering Lifecycle23 материалов

Data Platforms, Data Stores, and Security

Architecting the Data PlatformВидеоFactors for Selecting and Designing Data StoresВидеоSecurityВидеоViewpoints: Importance of Data SecurityВидеоSummary and HighlightsЧтениеPractice QuizЗадание

Data Collection and Data Wrangling

How to Gather and Import DataВидеоData WranglingВидеоTools for Data WranglingВидеоHands-On Lab: Load data into the Datasette from a CSV fileВнешний инструмент[Optional] Hands-on Lab: Load data into the Db2 Database from a CSV filePLUGINSummary and HighlightsЧтениеPractice QuizЗадание

Querying Data, Performance Tuning, and Troubleshooting

Querying and Analyzing DataВидеоPerformance Tuning and TroubleshootingВидеоLab: Explore your dataset using SQL queries using DatasetteВнешний инструмент[Optional] Hands-on Lab: Explore Your Dataset Using SQL Queries in DB2PLUGINSummary and HighlightsЧтениеPractice QuizЗадание

Governance and Compliance

Governance and ComplianceВидеоSummary and HighlightsЧтениеPractice QuizЗаданиеOptional: Overview of the DataOps MethodologyЧтение
04Designing, Modeling, and Implementing Data Warehouses18 материалов

Designing, Modeling and Implementing Data Warehouses

Overview of Data Warehouse Architectures ВидеоCubes, Rollups, and Materialized Views and TablesВидеоGrouping Sets in SQLЧтениеFacts and Dimensional ModelingВидеоHands-on Lab: Working with Facts and Dimension TablesВнешний инструментData Modeling using Star and Snowflake SchemasВидеоUnderstanding Slowly Changing Dimensions (SCD)ЧтениеData Warehousing with Star and Snowflake schemasЧтениеStaging Areas for Data WarehousesВидеоHands-on Lab: Setting up a Staging AreaВнешний инструментVerify Data QualityВидеоHands-on Lab: Verifying Data Quality for a Data WarehouseВнешний инструментPopulating a Data WarehouseВидеоHands-on Lab: Populating a Data Warehouse using PostgreSQLВнешний инструментQuerying the DataВидеоHands-On Lab: Querying the Data Warehouse using PostgreSQL (Cubes, Rollups, Grouping Sets and Materialized Views)Внешний инструментPractice Quiz: Designing, Modeling and Implementing Data WarehousesЗадание

Summary

Summary: Designing, Modeling and Implementing Data WarehousesЧтение
05Data Engineering and Generative AI26 материалов

Data Engineering and Generative AI  

Generative AI for Data Engineering ВидеоReading: Generative AI Tools for Data EngineeringPLUGINHow Data Engineers Leverage the Power of Generative AI ВидеоExamples of Generative AI in Data Engineering ВидеоExpert Viewpoints: Impact of Generative AI on Data EngineeringВидеоReading: Case Study on Successful Implementations of Generative AI in Data Engineering PLUGINPractice Quiz: Data Engineering and Generative AI ЗаданиеDiscussion Prompt: Discuss How Generative AI Can Be Used in Data Engineering ОбсуждениеData Engineering |Expert Viewpoints: AI’s Impact on the Design and Architecture of Data RepositoriesВидео

Generative AI for Data Architecture, Planning and Preparation

Reading: Leveraging Generative AI in Data Engineering Process PLUGINDesigning Future-Ready Data Architectures with Generative AIВидеоHands-on Lab: Generative AI for Architecture Design Внешний инструментAutomating Schema Design with Generative AI ВидеоHands-on Lab: Generative AI for Database, Data Warehouse Schema DesignВнешний инструментDemo: Generative AI for Data Generation and Augmentation Видео

Summary

Summary: Data Engineering and Generative AIЧтениеCheat Sheet: Data Engineering and Generative AIPLUGIN
06Assessment2 материалов

Lesson

Learner Expectations for Skill AssessmentЧтениеSkill AssessmentЗадание
Hands-on Lab: Generative AI for Data Generation and AugmentationPLUGIN
Reading: Generative AI for Data AnonymizationPLUGIN
Hands-on Lab: Generative AI for Data AnonymizationВнешний инструмент
Hands-on Lab: Testing EnvironmentВнешний инструмент
Demo: Generative AI for Infrastructure SetupВидео
Hands-on Lab: Generative AI for Infrastructure SetupВнешний инструмент
Expert Viewpoints: How is Gen AI impacting the Design and Architecture of Data Repositories?Видео
Successful Implementations of Generative AI for Data Design Видео
Practice Quiz Generative AI for Data DesignЗадание