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

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

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

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

Data Engineering & Management

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

О курсе

Learn how to design, optimize, and manage modern data systems through this comprehensive course in the Data Engineering & Management Skill Path. You will build critical competencies including designing conceptual, logical, and dimensional data models, applying normalization to relational databases, and evaluating indexes and execution plans to improve query performance. You will also master advanced SQL functions to create derived features, optimize queries for speed, and automate workflows with reusable scripts. Beyond relational data, you will gain practical expertise in integrating external data through APIs, applying programmatic logic and regular expressions to transform unstructured data, and developing multi-step transformation pipelines. You will practice data reconciliation, enforce schemas for consistency, and analyze data lineage to trace and resolve quality issues. Additional focus on OLTP vs. OLAP design, outlier handling, and clustering techniques prepares you to bridge engineering and analytical perspectives. This course brings together expertise from Edureka, Microsoft, Google, Packt, Arizona State University, Maven Analytics, Coursera Instructor Network, and Johns Hopkins University, ensuring a balanced blend of academic rigor and industry relevance. You will progress from relational database foundations to Python scripting, API integration, and Tableau visualizations, preparing you to confidently build scalable, high-quality data systems that deliver business value.

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

Database SystemsStar SchemaData ManagementUnstructured DataDatabase DesignDatabase DevelopmentSQLData StorytellingTransact-SQLData ModelingData PresentationUnsupervised LearningData CleansingRelational DatabasesMicrosoft SQL ServersDatabase ManagementDashboard CreationInteractive Data VisualizationDashboardDatabase Theory

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

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

01Personalize your learning path1 материалов
Personalize your learning pathЗадание
02Introduction to MS SQL Server41 материалов

Overview of MS SQL Server

Course IntroductionЧтениеWhat is SQL?Видео

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

Professionals from the Industry

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

Data Engineering & Management
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 42.7 ч

16 модулей

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

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

Часть программы вашего университета
Introduction to Microsoft SQL ServerВидео
Installation of MS SQL Server Видео
SQL Server Interface - Object ExplorerВидео
SQL Server Interface - Basic ScriptsВидео
Data Modeling - ER Diagram ComponentsВидео
Data Modeling - ER Diagram EntitiesВидео
MS SQL Server User GuideЧтение
MS SQL Server EditionsЧтение
Practice Quiz: Basics of SQL ServerЗадание

ER Modeling in MS SQL Server

Cardinality in ER DiagramsВидеоDegrees of RelationshipsВидеоER Modeling Session - Building TablesВидеоER Modeling Session - Creating DiagramsВидеоRelease notes for SQL Server Management Studio (SSMS)ЧтениеPractice Quiz: ER ModelingЗадание

Data Normalization

Operation on KeysВидеоNormalizationВидеоTypes of Normalization - 1NFВидеоTypes of Normalization - 2NFВидеоTypes of Normalization - 3NFВидеоTypes of Normalization - 4NFВидеоTypes of Normalization - 5NFВидеоNormalizationЧтениеPractice Quiz: Data NormalizationЗадание

SQL Commands

DDL CommandsВидеоDQL CommandsВидеоDML CommandsВидеоDCL CommandsВидеоTCL CommandsВидеоMERGE StatementВидеоALTER StatementВидеоSQL JoinsЧтениеPractice Quiz: SQLЗадание

Practice Session: SQL Commnads

Implementing Joins ВидеоImplementing Joins - Right, Full and Cross JoinsВидеоImplementing Restaurant Database - Creating DatabaseВидеоImplementing Restaurant Database - CommandsВидеоImplementing Restaurant Database - TransactionsВидеоPractice Quiz: SQL Queries and CommandsЗадание
03Skill Assessment 13 материалов

Lesson

Practice for Database FundamentalsЗаданиеLearner Expectations for AssessmentЧтениеCheckpoint 1 of 4: Database FundamentalsЗадание
04Clean Data for More Accurate Insights27 материалов

Data cleaning is a must

Glossary and CitationsЧтениеClean it up!ВидеоWhy data cleaning is criticalВидеоAngie: I love cleaning dataВидеоWhat is dirty data?ЧтениеRecognize and remedy dirty dataВидеоPrinciples of data integrity PLUGINTest your knowledge on data cleaningЗадание

First steps toward clean data

Data-cleaning tools and techniquesВидеоClean data from multiple sourcesВидеоCommon data-cleaning pitfallsЧтениеHands-On Activity: Cleaning data with spreadsheetsЗаданиеTest your knowledge on the first steps toward clean dataЗадание

Continue cleaning data in spreadsheets

Step-by-Step guide: Data-cleaning features in spreadsheetsЧтениеData-cleaning features in spreadsheetsВидеоStep-by-Step: Optimize the data-cleaning process ЧтениеOptimize the data-cleaning processВидеоWorkflow automationЧтениеStep-by-Step: Different data perspectivesЧтение

Module 2 challenge

Glossary terms from module 2Чтение
05Concepts for Data Modeling37 материалов

Welcome to the course

How to open an image in a new tabЧтениеSetting up your Power BI environmentЧтениеNew name for Power BI datasetsЧтениеHow to locate your downloaded filesЧтениеAdditional resources: Concepts for data modelingЧтение

Introduction to data models

Introduction to data modelsВидеоModel view in Power BIЧтениеIntroduction to schemasВидеоSchemas cheatsheetЧтениеSetting up a Flat schema in Power BIВидеоTable and column properties cheatsheetЧтениеExercise: Configuring a Flat schemaЧтениеSelf-review: Configuring a Flat schemaЗаданиеExemplar: Configuring a Flat schemaЧтениеActivity: Configure a Flat schema with multiple sourcesЧтениеKnowledge check: Introduction to data modelsЗаданиеAdditional resources: Introduction to data modelsЧтение

Introduction to cardinality and cross-filter direction

Understanding fact and dimension tablesВидеоNormalization and denormalizationЧтениеIntroduction to cardinalityВидеоManaging model relationshipsЧтениеModel relationships cheatsheetЧтениеIntroduction to cross-filter directionВидео

Working with advanced data models

Setting up a Star schema in Power BIВидеоExercise: Configuring a Star schemaЧтениеSelf-review: Configuring a Star schemaЗаданиеExemplar: Configuring a Star schemaЧтениеSetting up a Snowflake schemaВидеоActivity: Changing your Star schema into a Snowflake schemaЧтение
06Skill Assessment 23 материалов

Lesson

Practice for Data ModelingЗаданиеLearner Expectations for AssessmentЧтениеCheckpoint 2 of 4: Data ModelingЗадание
07Dark Data Classifications: Internal Dark Data12 материалов

Lesson 1: Dark Data Tiers Overview

Overview of Dark Data Classification: Inside and OutsideВидеоOLTP SystemsВидеоOLAP SystemsВидеоExternally Integrated SystemsВидеоDark Data TiersЧтение

Lesson 2: Dark Data Tier 1, Captive Data

Dark Data Tier 1, Captive Data Deep DiveВидеоDark Data Discovery ВидеоDark Data Tier 1, Captive Data ExampleВидеоCaptive Data: Tier 1Чтение

Lesson 3: Dark Data Tier 2, Generative Data

Overview of Generative Data ВидеоExample of Generative DataВидеоGenerative Data: Tier 2Чтение
08Working With Advanced SQL25 материалов

Built-in Functions and T-SQL

What is T-SQL?ВидеоAggregate Functions ВидеоConvenient Aggregate Functions – AVG() and MAX()ВидеоConvenient Aggregate Functions – MIN() and SUM()ВидеоConvenient Aggregate Functions – COUNT() and COUNT_BIG()ВидеоStatistical Aggregate FunctionsВидеоUser Defined Aggregate FunctionsВидеоODBC Scalar FunctionsЧтениеT-SQL ЧтениеSQL FunctionsЧтениеPractice Quiz: SQL FunctionsЗадание

Practice Sessions - Functions

Querying using Built-in FunctionsВидеоComposing T-SQLВидеоDatabase FunctionsЧтение

Queries and Views

Introduction to Sub - QueriesВидеоSQL Server Views - Describing ViewsВидеоSQL Server Views OperationsВидеоCase ExpressionsВидеоStored ProceduresВидеоUnderstanding concurrency controlЧтениеPractice Quiz: Queries and Views

Practice Session - Views and Queries

Operating ViewsВидеоImplementing Stored ProceduresВидеоExecuting Stored ProceduresВидеоViewsЧтение
09Data and APIs 11 материалов

Introduction to APIs and Data Formats

IntroductionВидеоLegal ConsiderationsВидеоInformation & Social Analysis of RedditЧтениеIntroduction to APIs and Data FormatsЗадание

Practical Data Handling with Python

APIsВидеоOutdated APIs for Reference and ExampleЧтениеAdditional Python ScriptsЧтениеPython Scripts for Data CollectionЧтениеPractical Data Handling with PythonЗадание

Module-end Assessments

Self-Reflective Reading: Social Media Data CollectionЧтениеPractice Lab: Scraping Data from a Multi-Page Website Using PythonЛабораторная
10Skill Assessment 33 материалов

Lesson

Practice for Data Workflow OptimizationЗаданиеLearner Expectations for AssessmentЧтениеCheckpoint 3 of 4: Data Workflow OptimizationЗадание
11Python Fundamentals20 материалов

Prerequisite - Python Fundamentals

Full Specialization ResourcesЧтениеInstallation of Python and AnacondaВидеоPython IntroductionВидеоVariables in PythonВидеоNumeric Operations in PythonВидеоLogical OperationsВидеоIf Else LoopВидеоFor While LoopВидеоFunctionsВидеоStrings: Part 1ВидеоStrings: Part 2ВидеоList: Part 1ВидеоList: Part 2ВидеоList: Part 3ВидеоList: Part 4ВидеоTuplesВидеоSetsВидеоDictionariesВидеоComprehensionВидеоInstalling and Managing Packages with AnacondaDIALOGUE
12Regular Expressions30 материалов

Regular Expressions

What are regular expressions?ВидеоReview: Why use regular expressions?ЧтениеWhy use regular expressions?ВидеоBasic Matching with grepВидеоPractice Quiz: Regular Expressions Задание

Basic Regular Expressions

Review: Simple matching in PythonЧтениеSimple Matching in PythonВидеоReview: Wildcards and Character ClassesЧтениеWildcards and Character ClassesВидеоReview: Repetition QualifiersЧтениеRepetition QualifiersВидеоReview: Escaping CharactersЧтениеEscaping CharactersВидеоReview: Regular Expressions in ActionЧтениеRegular Expressions in ActionВидеоStudy guide: Regular expressionsЧтениеPractice Quiz: Basic Regular Expressions Задание

Advanced Regular Expressions

Review: Capturing GroupsЧтениеCapturing GroupsВидеоReview: More on repetition qualifiersЧтениеMore on Repetition QualifiersВидеоReview: Extracting a PID using regexes in PythonЧтениеExtracting a PID Using regexes in PythonВидео

Module Review

Glossary terms from course 2, module 3ЧтениеExemplar: Work with regular expressionsЧтениеAdditional Resources & CitationsЧтение
13Unsupervised Learning42 материалов

Intro to Unsupervised Machine Learning

Supervised vs. Unsupervised LearningВидеоCommon Unsupervised TechniquesВидеоUnsupervised ML WorkflowВидеоRECAP: Feature EngineeringВидеоKEY TAKEAWAYS: Intro to Unsupervised MLВидео

Clustering & Segmentation

Introduction to Cluster AnalysisВидеоClustering BasicsВидеоIntro to K-MeansВидеоWSS & Elbow PlotsВидеоK-Means FAQsВидеоCASE STUDY: K-MeansВидеоIntro to Hierarchical ClusteringВидеоAnatomy of a DendrogramВидеоHierarchical Clustering FAQsВидеоKEY TAKEAWAYS: Clustering & SegmentationВидео

Association Mining & Basket Analysis

Introduction to Association MiningВидеоAssociation Mining BasicsВидеоThe Apriori AlgorithmВидеоBasket Analysis ExamplesВидеоMinimum Support ThresholdsВидеоInfrequent ItemsetsВидео

Outlier Detection

Introduction to OutliersВидеоOutlier Detection BasicsВидеоCross-Sectional OutliersВидеоCross-Sectional Outlier ExampleВидеоCASE STUDY: Cross-Sectional OutlierВидеоTime-Series OutliersВидео

Dimensionality Reduction

Introduction to Dimensionality ReductionВидеоDimensionality Reduction BasicsВидеоPrinciple Component AnalysisВидеоPCA ExampleВидеоInterpreting ComponentsВидеоScree PlotsВидеоAdvanced Techniques
14GenAI for Data Engineers: Scaling with GenAI12 материалов

Lesson 1: GenAI for Data Engineers: Scaling with GenAI

Introduction to GenAI for Data EngineersВидеоOur Roadmap & Resources Available: How to Get StartedЧтениеGenAI and Data Engineering: GlossaryЧтениеHistory & Background for GenAI and Data EngineeringВидеоDemo: Create Synthetic Data for Testing a Data Pipeline with ChatGPTВидеоDemo: Create Synthetic Data for Testing a Data Pipeline with Google GeminiЧтениеDemo: Create and Implement an Entity Relationship Diagram with CoPilotЧтение[optional] Entity Relationship Diagram ShowcaseВзаимная проверкаEntity Relationship Diagram ЗаданиеRemediating Risks and Ethical ConcernsВидеоDemo: Data Pipeline Development from Low-Code, to SQL, to Python with ChatGPTВидеоDemo: Data Pipeline Development with Data Loading and Code Documentation using ChatGPTЧтение
15Data Visualizations and Presentations23 материалов

Present a story

Tableau Public overviewЧтениеHow to sign on to Tableau Public ЧтениеThe visualization life cycleВидеоDownload your datasets and begin presenting with Tableau ЧтениеFollow-along guide: Work with Tableau, Part 1Чтение Work with Tableau, Part 1ВидеоTest your knowledge: Present a storyЗадание

Advanced Tableau

Follow-along guide: Work with Tableau, Part 2Чтение Work with Tableau, Part 2ВидеоIdentify: Compelling visualizationsPLUGIN[Turkish learners ONLY] Identify: Compelling visualizations - TürkçePLUGINDrew: Explore the possibilities of dataВидеоActivity: Design a bar graph that tells a story in Tableau PublicЗадание
16Skill Assessment 43 материалов

Lesson

Practice for Advanced Data EngineeringЗаданиеLearner Expectation for AssessmentЧтениеCheckpoint 4 of 4: Advanced Data EngineeringЗадание
Different data perspectivesВидео
Step-by-Step: Even more data-cleaning techniquesЧтение
Even more data-cleaning techniquesВидео
Working with .csv filesЧтение
Hands-On Activity: Clean data with spreadsheet functionsЗадание
Develop your approach to cleaning dataЧтение
Test your knowledge on cleaning data in spreadsheetsЗадание
Defining data granularityВидео
Knowledge check: Introduction to cardinality and cross-filter directionЗадание
Additional resources: Introduction to cardinality and cross-filter directionЧтение
Why it is important to use Snowflake schemaВидео
Data View in Power BIЧтение
Resolving challenges in data modelsВидео
Knowledge check: Working with advanced data modelsЗадание
Additional resources: Working with advanced data modelsЧтение
Задание
Review: Splitting and ReplacingЧтение
Splitting and ReplacingВидео
Study guide: Advanced regular expressions Чтение
Practice Quiz: Advanced Regular Expressions Задание
Multiple Item SetsВидео
CASE STUDY: AprioriВидео
Markov ChainsВидео
CASE STUDY: Markov ChainsВидео
KEY TAKEAWAYS: Association MiningВидео
Time-Series Outlier ExampleВидео
KEY TAKEAWAYS: Outlier DetectionВидео
Видео
KEY TAKEAWAYS: Dimensionality ReductionВидео
Activity Exemplar: Design a bar graph that tells a story in Tableau PublicЧтение
Follow-along guide: Craft compelling stories with TableauЧтение
Craft compelling stories with TableauВидео
The top five data visualization resourcesЧтение
Follow-along guide: Present like a pro with TableauЧтение
Present like a pro with TableauВидео
Activity: Build an interactive dashboard in Tableau PublicЗадание
Activity Exemplar: Build an interactive dashboard in Tableau PublicЧтение
Test your knowledge: Advanced TableauЗадание
Glossary, Datasets & Additional ResourcesЧтение