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

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

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

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

Foundational Data Design and AI Development

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

О курсе

Learn how to design structured datasets and leverage generative AI tools to support data engineering workflows in this foundational course within the Data Engineering Skill Path. You will develop essential competencies including translating business requirements into well-structured tables, applying First Normal Form (1NF) to organize data, performing basic structural transformations using SQL, generating synthetic data for testing, and using AI tools to produce or explain code for pipeline tasks. Through hands-on practice with relational databases, SAS PROC SQL, Microsoft Fabric environments, and generative AI platforms, you will gain the skills needed to design, refine, and augment early-stage data engineering solutions. This course combines expertise from IBM, SAS, Whizlabs, and IBM AI specialists, offering multiple perspectives on data modeling, SQL transformation, Lakehouse-oriented design, and AI-assisted development. You will progress from foundational relational modeling to applying SQL transformations, to structuring Lakehouse data using normalization principles, and finally to using AI tools to enhance productivity and support pipeline development. The curriculum balances conceptual understanding with practical exercises, preparing you to confidently design data structures and incorporate AI into modern data engineering workflows. Perfect for aspiring data engineers and learners seeking foundational skills in data design, modeling, and AI-supported development.

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

SAS (Software)Relational DatabasesDatabase ManagementQuery LanguagesData ModelingData TransformationSQLResponsible AIData EthicsGenerative AIDatabase DesignExtract, Transform, LoadData LakesData PipelinesDiagram Design

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

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

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 Concepts22 материалов

Module Introduction

Introduction to Relational Database ManagementВидео

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

Professionals from the Industry

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

Foundational Data Design and AI Development
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 22.3 ч

7 модулей

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

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

Часть программы вашего университета
Helpful Tips For Course CompletionPLUGIN

Fundamental Relational Database Concepts

Review of Data Fundamentals ВидеоInformation and Data ModelsВидеоERDs and Types of RelationshipsВидеоMapping Entities to TablesВидеоData TypesВидеоRelational Model ConceptsВидеоHands-on Lab: Relational Model ConceptsPLUGINSummary 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Задание
03PROC SQL Fundamentals50 материалов

Generating Simple Reports

Filtering Rows Using the WHERE ClauseВидеоActivity 2.01ЗаданиеSpecial WHERE Operators: Missing ValuesВидеоActivity 2.02ЗаданиеDate, Time, and Datetime ValuesЧтениеAdditional Special WHERE OperatorsВидеоSorting the Output with the ORDER BY ClauseВидеоActivity 2.03ЗаданиеOrdering Columns by PositionВидеоEnhancing ReportsВидеоActivity 2.04ЗаданиеDemo: Creating Simple ReportsВидеоCreating a New ColumnВидеоActivity 2.05ЗаданиеSubsetting Calculated ValuesВидеоAssigning Values Conditionally with the CASE ExpressionВидеоDemo: Assigning Values ConditionallyВидеоLevel 1 Practice: Querying a TableЗаданиеLevel 2 Practice: Working with Datetime ValuesЗадание

Summarizing and Grouping Data

Eliminating Duplicate Rows with the DISTINCT KeywordВидеоActivity 2.06ЗаданиеSummarizing DataВидеоCommonly Used Summary FunctionsЧтениеDemo: Using Summary Functions to Analyze a TableВидеоSummarizing Data Using the COUNT FunctionВидео

Creating and Managing Tables

Creating TablesВидеоCreating Tables from a QueryВидеоActivity 2.09ЗаданиеCreating Table StructuresВидеоInserting Rows into TablesВидеоDropping Tables in PROC SQLВидеоActivity 2.10

Using DICTIONARY Tables

ScenarioВидеоDICTIONARY TablesВидеоActivity 2.11ЗаданиеDemo: Using DICTIONARY TablesВидеоPractice Level 1: Counting the Number of Tables in a LibraryЗаданиеPractice Level 2: Counting the Number of Tables in All LibrariesЗадание

Module Review

SQL Order of Execution Cheat Sheet (optional)ЧтениеLearning More (optional)Чтение
04Prepare Data [Get, Transform, Query and Analyze data]20 материалов

Create Objects, Copy and Transform Data in Microsoft Fabric

Overview of Prepare Data [Get, Transform, Query and Analyze data]ЧтениеData Ingestion - DemoВидеоCreate and manage shortcuts - DemoВидеоFile partitioning for analytics workloads - DemoВидеоFunctions, and stored procedures - OverviewВидеоEnrich data by adding new columns or tables - DemoВидеоData CopyingВидеоAdding stored procedures, notebooks, and dataflows to a data pipelineВидеоSchedule data pipelines - DemoВидеоSchedule dataflows and notebooks - DemoВидеоCreate Objects, Copy and Transform Data in Microsoft Fabric - Practice AssignmentЗадание

Prepare and Transform Data in the Lakehouse

Data Cleansing - DemoВидеоDenormalize data - OverviewВидеоAggregate or de-aggregate data - DemoВидеоMerge or join data - OverviewВидеоData types Conversion - DemoВидеоData Filtering - DemoВидео
05Use of Generative AI for Data Engineering22 материалов

Generative AI for ETL and Data Repositories

Demo: Generative AI for Data Pipelines and ETL WorkflowsВидеоHands-on Lab: Generative AI for Data Pipelines and ETL Workflows Внешний инструментDemo: Generative AI for Data Repository Maintenance and AdministrationВидеоHands-on Lab: Generative AI for Data Repository Maintenance and Administration Внешний инструментDemo: Generative AI for Querying DatabasesВидеоHands-on Lab: Generative AI for Querying DatabasesВнешний инструментDemo: Generative AI for Data Mining and AnalysisВидеоHands-on Lab: Generative AI for Data Analysis and Mining Внешний инструментGenerative AI for Data LakehouseВидеоExpert's Viewpoint: AI's Role in Shaping Data RepositoriesВидеоSuccessful Implementations of Generative AI for ETL and Data Repositories  ВидеоHands-on Lab: Testing EnvironmentВнешний инструментPractice Quiz: Generative AI for ETL and Data Repositories Задание

Generative AI Considerations for Data Professionals

Considerations While Using Generative AI in IndustriesВидеоChallenges While Using Generative AIВидеоReading: Responsible Generative AI for Data ProfessionalsPLUGINCase Study: Considerations While Using Generative AI in HealthcarePLUGINHands-on Lab: Considerations for Data Professionals using Gen AIВнешний инструментPractice Quiz: Generative AI Considerations for Data ProfessionalsЗадание

Summary

Module Summary: Use of Generative AI for Data EngineeringЧтениеReading: Cheat Sheet: Use of Generative AI for Data EngineeringPLUGIN
06Data Engineering and Generative AI29 материалов

Welcome

Introduction to Generative AI in Data EngineeringВидеоReading: Course Syllabus and Prerequisites ЧтениеHelpful Tips for Course CompletionPLUGINMeet Your ExpertsВидео

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 Задание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
07Assessment2 материалов

Lesson

Learner Expectations for Skill AssessmentЧтениеSkill AssessmentЗадание
Activity 2.07Задание
Grouping DataВидео
Demo: Analyzing Groups of DataВидео
Summarizing Date and Time DataВидео
Activity 2.08Задание
Counting Rows Using a Boolean ExpressionВидео
Demo: Summarizing Data Using a Boolean ExpressionВидео
Level 1 Practice: Eliminating DuplicatesЗадание
Level 2 Practice: Grouping and Summarizing DataЗадание
Задание
Additional Statements to Maintain TablesЧтение
Identify Performance Bottlenecks - SQL ServerВидео
Resolve issues with Delta table file sizesВидео
Prepare and Transform Data in the Lakehouse - Practice AssignmentЗадание
Data Engineering |What are the key risks and challenges of using Generative AI for data professionals?Видео
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Задание