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

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

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

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

Relational Database Design and Advanced Querying

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

О курсе

Develop expertise in relational database design principles and implementation using SQL Server. This course teaches normalization techniques, entity-relationship modeling, and schema optimization to create efficient database structures. You'll use DDL (Data Definition Language) statements to build and modify database objects while enforcing data integrity through constraints. The advanced querying section covers complex joins, subqueries, CTEs, and aggregate functions that enable sophisticated data analysis. You'll also explore data warehousing concepts and learn to leverage GenAI to assist with complex query development from natural language descriptions. By the end of this course, you'll be able to design normalized databases from scratch and write advanced queries that extract meaningful insights from complex data structures.

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

Database DesignGenerative AISQLData IntegrityRelational DatabasesPerformance TuningPower BIQuery LanguagesBusiness Intelligence SoftwareDatabase TheoryDatabase ManagementData ModelingMicrosoft SQL ServersBusiness IntelligenceDatabase DevelopmentStar SchemaData Warehousing

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

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

01Fundamentals of Relational Database Design20 материалов

Lesson 1: Welcome to the Course

Welcome to Relational Database Design and Advanced QueryingВидеоCourse Structure and Learning OutcomesЧтениеCourse Accessibility InformationЧтениеSetting up SQL Server and SSMSЧтение

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

Microsoft

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

Relational Database Design and Advanced Querying
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 19.4 ч

4 модулей

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

Субтитры: Арабский, Французский, Узбекский, Итальянский, Бразильский португальский, Корейский, Немецкий, Пушту, Испанский, Дари, Японский, Казахский, Венгерский

Часть программы вашего университета
Setting Up the TechHealth DatabaseЧтение

Lesson 2: Introduction to Database Design

Real-World Impacts of Database DesignВидеоOverview of Relational Database DesignЧтениеDiscountTech Database Code FileЧтениеImplementing Relational Database Design ConceptsВидеоAnalyze TechHealth Analytics' Existing Database SetupЧтениеDatabase Design FundamentalsЗадание

Lesson 3: Key Constraints and Data Integrity

Understanding Key Constraints for Data IntegrityЧтениеDiscountTech Data Code FileЧтениеValidating Table Details and ConstraintsВидеоApplying Data Integrity with Key Constraints to TechHealth's DatasetsЧтениеUnderstanding and Applying Key ConstraintsЗадание

Lesson 4: Normalization in Databases

Normalization and its ApplicationsЧтениеApplying Normalization to TechHealth's DatasetsВидеоNormalize Sample Datasets from TechHealth AnalyticsЧтениеPrinciples of NormalizationЗадание
02Advanced Query Techniques16 материалов

Lesson 1: Advanced Joins and Subqueries

Leveraging Multi-Join SQL Queries to Gain Business InsightsВидеоLearn to Master Advanced SQL Joins and SubqueriesЧтениеBuilding Multi-Join Queries with Joins and SubqueriesВидеоUse Joins and Subqueries to Consolidate and Analyze TechHealth's DataЧтениеAdvanced Joins and Subqueries in SQLЗаданиеDiscuss Analytic Strategies Using Multi-Join QueriesDIALOGUE

Lesson 2: Aggregate Functions and Grouping Data

Using Aggregate Functions and Grouping for ReportingЧтениеApplying Aggregate Functions and GROUP BY for ReportingВидеоGenerate Data Summaries Using Aggregate Functions for TechHealth AnalyticsЧтениеAssessing Practical Usage of Aggregate FunctionsЗаданиеReflect on the Business Implications of Data SummariesDIALOGUE

Lesson 3: Query Optimization Techniques

SQL Query Optimization TechniquesЧтениеAnalyzing and Improving Query Execution PlansВидеоOptimize Queries to Improve the Performance of TechHealth's DatabaseЧтениеAssess the Principles of Query OptimizationЗаданиеReflect on Query Performance and Best PracticesDIALOGUE
03Designing and Implementing Database Schemas18 материалов

Lesson 1: Creating and Modifying Schemas

Creating Streamlined Data StructuresВидеоDDL Operations and Schema DesignЧтениеCreating and Modifying DiscountTech Database SchemasВидеоDesign and Modify a Schema for TechHealth's Operational NeedsЧтениеDDL Command Usage and Schema ManagementЗаданиеReflect on Maintaining Dynamic Database SchemasDIALOGUE

Lesson 2: Relational Constraints and Data Validation

Relational Constraints and their ApplicationsЧтениеImplementing Relational Constraints in SQL ServerВидеоApply Constraints to Enhance TechHealth Data IntegrityЧтениеTechniques for Relational Constraint ImplementationЗаданиеDiscuss the Balance in Applying Constraints for Data QualityDIALOGUE

Lesson 3: Advanced Schema Design with GenAI

Using GenAI for Innovative Database DesignВидеоThe Role of AI Tools in Database Schema DesignЧтениеApplying GenAI to Automate and Optimize Schema DesignВидеоAccessing GitHub for CopilotЧтениеDesign a Schema Using GenAI for TechHealth AnalyticsЛабораторнаяGenAI's Role in Modern Database Schema DesignЗадание
04Data Warehousing and Business Intelligence with SQL Server19 материалов

Lesson 1: Introduction to Data Warehousing

Transforming Data into Insights with Data WarehousingВидеоUnderstanding OLTP and OLAPЧтениеIntroduction to Star SchemaЧтениеBuilding a Data Warehouse in SQL ServerВидеоCreate a Star Schema and Run a Basic Extract, Transform, Load (ETL) ProcessЧтениеDatabase Systems and Star Schema FundamentalsЗаданиеDesigning Effective SchemasDIALOGUE

Lesson 2: Querying Data in a Warehouse Environment

Comprehensive Guide to Data Warehouse QueryingЧтениеSQL for Data Warehousing: From Basics to Advanced AnalyticsВидеоIntegrated Data Warehouse Query ChallengeЧтениеData Warehouse Querying, Time Analysis, and Techniques AssessmentЗаданиеStrategic SQL for In-Depth Data Warehouse AnalysisDIALOGUE

Lesson 3: Visualizing Business Intelligence with Power BI

Power BI: Visualizing and Presenting Data InsightsЧтениеConnecting to Power BIЧтениеPower BI Workflows: Connecting, Visualizing, and Presenting DataВидеоIntegrated Power BI ChallengeЧтениеPower BI Mastery AssessmentЗаданиеOptimizing Power BI for Business IntelligenceDIALOGUE

Lesson 4: Course Wrap-Up

Wrapping Up and Looking AheadЧтение
Reflect on the Effectiveness of AI in Database ManagementDIALOGUE