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

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

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

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

Database Design and Operational Business Intelligence

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

О курсе

Learn how to design scalable databases and integrate them with Power BI for impactful business intelligence. This course on Database Design and Operational Business Intelligence is designed to help you master the principles of relational database design, normalization, and schema optimization. You'll gain hands-on experience managing complex datasets and structuring databases that align with real-world business needs. Throughout this course, you'll delve into how Power BI and MS SQL Server are applied within specific industries. By the end of this course, you will be able to: 1. Compose different data models by re-structuring the data 2. Interpreting Data models 3. Create dashboards and Publish them on Service 4. Demonstrate machine learning and advanced features in Power BI Service 5. Analyze the scorecard and results from the binary prediction model 6. Implement best practices for visualization This long course is designed for Data Analyst, Data Engineer, Data Administrator, and Business Analyst seeking to enhance their analytical and design skills. Prior experience with MS Excel and RDBMS is beneficial but not mandatory for this course. Join us on this journey to enhance your Power BI and MS SQL Server skills and elevate your analytical and design capabilities.

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

Database ManagementData PresentationDashboard CreationData ManagementData Transformation

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

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

01Introduction to MS SQL Server56 материалов

Overview of MS SQL Server

Welcome to Database Design and Operational Business IntelligenceЧтениеCourse IntroductionВидеоYour Baseline Knowledge CheckDIALOGUEWhat is SQLВидео

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

Edureka

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

Database Design and Operational Business Intelligence
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 8.2 ч

4 модулей

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

Субтитры: Арабский, Испанский, Казахский, Венгерский

Часть программы вашего университета
Introduction to MS SQL ServerВидео
Installation of MS SQL ServerВидео
MS SQL Server Interface - IВидео
MS SQL Server Interface - IIВидео
Data Modeling: ER Diagram - IВидео
Data Modeling: ER Diagram - IIВидео
Introduction to Microsoft SQL ServerЧтение
Components of SQLОбсуждение
Introduce YourselfОбсуждение
MS SQL ServerЗадание
End Lesson Quiz: MS SQL ServerЗадание

ER Modeling in MS SQL Server

Cardinality in ER DiagramВидеоDegree of RelationshipsВидеоRelationships in Database ModelingВидеоComplexity of Entity RelationshipsВидеоER Modeling Sessions in Database DesignЧтениеER modeling ApproachesОбсуждениеER Modeling in MS SQL ServerЗаданиеEnd Lesson Quiz: ER Modeling in MS SQL ServerЗадание

Data Normalization

Operation on KeysВидеоNormalizationВидеоTypes of Normalization 1 NFВидеоTypes of Normalization 2 NFВидеоTypes of Normalization 3 NFВидеоTypes of Normalization 4 NFВидеоTypes of Normalization 5 NFВидеоUnderstanding Database Keys and NormalizationЧтениеNormalize DatabaseОбсуждениеData NormalizationЗаданиеEnd Lesson Quiz: Data NormalizationЗадание

SQL Commands

DDL CommandsВидеоDQL CommandsВидеоDML CommandsВидеоDCL CommandsВидеоTCL ComandsВидеоMerge StatementВидеоAlter StatementВидеоSQL Commands and StatementsЧтениеAggregate functionsОбсуждениеSQL CommandsЗаданиеEnd Lesson Quiz: SQL CommandsЗадание

Practice Session-Joins in Database

Join Part-IВидеоJoin Part-IIВидеоJoin Part-IIIВидеоJoin Part-IVВидеоJoin Part-VВидеоUnderstanding Joins in DatabasesЧтениеJoin PerformanceОбсуждениеJoins in DatabaseЗаданиеEnd Lesson Quiz: Joins in DatabaseЗадание

Module Wrap-up & Assessment

Summary of MS SQL ServerВидеоEnd Module Quiz: MS-SQL ServerЗадание
02Functions and Views33 материалов

Built-in Functions and T-SQL

What is T-SQL?ВидеоAggregate FunctionsВидеоConvenient Aggregate Functions MAX() and AVG()ВидеоConvenient Aggregate Functions MIN() and SUM()ВидеоStatistical Aggregate FunctionsВидеоUser Defined Aggregate FunctionsВидеоConvenient Aggregate Functions – COUNT() and COUNT_BIG()ВидеоExploring Built-in Functions and T-SQLЧтениеCreative ApproachesОбсуждениеBuilt-in Functions and T-SQLЗаданиеEnd Lesson Quiz: Built-in Functions and T-SQLЗадание

Practice Session - Functions

Querying using Built-in FunctionsВидеоComposing T-SQLВидеоUnderstanding SQL CommandsЧтениеComposing T-SQLЗаданиеEnd Lesson Quiz: Composing T-SQLЗадание

Queries and Views

Introduction to Sub-QueriesВидеоSQL Server Views - IВидеоSQL Server Views - IIВидеоCase ExpressionsВидеоStored ProceduresВидеоUnderstanding Queries and Views in DatabasesЧтениеConditional Logic

Practice Session - Views and Subqueries

Operating ViewsВидеоImplementing Stored ProceduresВидеоExecuting Stored ProceduresВидеоExploring Views and Subqueries in DatabasesЧтениеViews and SubqueriesЗаданиеEnd Lesson Quiz: Views and SubqueriesЗадание

Module Wrap-up & Assessment

Summary of Working with Advanced SQLВидеоEnd Module Quiz: Functions and ViewsЗадание
03 Data Connectivity with Power BI29 материалов

Introduction to Power BI

Applications of Power BIВидеоWorking with Power BIВидеоInstallation of Power BI Desktop and ServiceВидеоFeatures of Power BIЧтениеConnecting to Data SourcesОбсуждениеIntroduction to Power BIЗаданиеEnd Lesson Quiz: Introduction to Power BIЗадание

Integrating Power BI with MS SQL Server

Creating DatabaseВидеоBuilding TablesВидеоInserting DataВидеоConnecting to Power BIВидеоCreating ReportsВидеоPublishing ReportsВидеоManaging Gateways

Best Practices for Visualization

Phases for Optimal VisualsВидеоChart Types and ElementsВидеоCommon Refining TechniquesВидео Visual Perception of VariationВидеоExploring the DataЧтениеExploratory DataОбсуждениеExploring the Data

Module Wrap up & Assessment

Summary of Data Connectivity with Power BIВидеоEnd Module Quiz: Data Connectivity-Power BIЗадание
04Course Wrap up5 материалов
End Course Knowledge CheckpointDIALOGUEIncident Tracking ReportЧтениеDescribe Your Learning JourneyОбсуждениеDatabase Design and Operational Business Intelligence Course SummaryВидеоEnd Course Knowledge Check: Database Design and Operational Business IntelligenceЗадание
Обсуждение
Queries and ViewsЗадание
End Lesson Quiz: Queries and ViewsЗадание
Видео
Refresh gatewayВидео
Understanding Data PreprocessingЧтение
Categorical VariablesОбсуждение
Data PreprocessingЗадание
End Lesson Quiz: Data PreprocessingЗадание
Задание
End Lesson Quiz: Best Practices for VisualizationЗадание