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

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

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

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

Security, Maintenance & Integration with BI Tools

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

О курсе

Develop essential database administration skills focusing on security, maintenance, and business integration. This final course teaches you to implement SQL Server security through authentication, authorization, and data encryption while ensuring data integrity through validation constraints and auditing. You'll learn critical maintenance tasks including backups, recovery, and index maintenance to ensure database reliability and performance. The course also covers integrating SQL Server with Power BI for creating interactive dashboards and reports that transform raw data into actionable insights. Additionally, you'll explore modern application integration patterns and API connectivity. By completing this course, you'll possess the comprehensive skill set needed to securely manage database environments and bridge the gap between data storage and business intelligence.

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

Microsoft SQL ServersData MaintenanceData IntegrationPower BIData SecurityDatabase ManagementBusiness IntelligenceData ValidationSystems IntegrationDatabasesInteractive Data VisualizationRole-Based Access Control (RBAC)Dashboard CreationDatabase Architecture and AdministrationRelational DatabasesApplication Programming Interface (API)Database AdministrationData IntegrityDashboardData Quality

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

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

01Ensuring Database Security19 материалов

Lesson 1: Welcome to the Course

Welcome to Security, Maintenance, and Integration with BI ToolsВидеоCourse Structure and Learning OutcomesЧтениеCourse Accessibility InformationЧтениеSetting up SQL Server and SSMSЧтение

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

Microsoft

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

Security, Maintenance & Integration with BI Tools
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 14.6 ч

4 модулей

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

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

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

Lesson 2: Importance and Principles of Database Security

A Database Breach Case StudyВидеоPrinciples and Importance of Database SecurityЧтениеDiscountTech Database Code FileЧтениеIdentifying Security VulnerabilitiesВидеоActivity: Assess TechHealth Analytics' Current Security PostureЧтениеSecurity Concepts and PrinciplesЗадание

Lesson 3: Implementing Role-Based Access Control

Role-based Access Control MethodologiesЧтениеConfiguring RBAC in SQL ServerВидеоActivity: Design an RBAC Model for TechHealth AnalyticsЧтениеRole-Based Access Control Knowledge CheckЗадание

Lesson 4: Data Encryption Techniques

Data Encryption Techniques in SQL ServerЧтениеImplementing Encryption in SQL ServerВидеоActivity: Apply Encryption to Secure TechHealth Analytics' DataЧтениеKnowledge Check on Encryption TechniquesЗадание
02Ensuring Data Integrity and System Reliability16 материалов

Lesson 1: Data Validation Techniques

Ensuring Data IntegrityВидеоData Validation Techniques and Best PracticesЧтениеConfiguring Validation Rules in SQL ServerВидеоActivity: Create Validation Rules for TechHealth Analytics' DatasetsЧтениеData Validation Knowledge CheckЗаданиеReflect on the Role of Validation in Data IntegrityDIALOGUE

Lesson 2: Database Maintenance Strategies

Database Maintenance Tasks and ToolsЧтениеPerforming Maintenance Tasks in SQL ServerВидеоActivity: Test Maintenance Strategies for TechHealth AnalyticsЧтениеDatabase Maintenance Knowledge AssessmentЗаданиеDiscuss Maintenance Challenges and SolutionsDIALOGUE

Lesson 3: Backup and Auditing Mechanisms

Backup and Auditing in SQL ServerЧтениеSetting up Backups and Audits in SQL ServerВидеоActivity: Design a Backup and Audit Plan for TechHealth AnalyticsЧтениеBackup and Auditing Strategies Knowledge CheckЗаданиеReflect on the Importance of Backups and AuditsDIALOGUE
03Integrating SQL Server with BI Tools18 материалов

Lesson 1: Introduction to BI Tools Integration

Transforming Data into Insights with Power BIВидеоBI Tools and SQL Server Integration OverviewЧтениеSetting up the DiscountTechDW Data WarehouseЧтениеConnecting SQL Server to Power BIВидеоSetting Up the TechHealth Data WarehouseЧтениеActivity: Integrate TechHealth Analytics Data with Power BIЧтениеBI Tools Integration Knowledge CheckЗаданиеReflect on the Power of Data Visualization in BI ToolsDIALOGUE

Lesson 2: Creating Dynamic Reports and Dashboards

Creating Effective Reports and DashboardsЧтениеDesigning Interactive Dashboards in Power BIВидеоActivity: Build a TechHealth Analytics DashboardЧтениеReporting and Dashboard Designing Skills AssessmentЗаданиеReflect on the Impact of Dynamic Reports on Decision MakingDIALOGUE

Lesson 3: Real-time Data Analysis and Visualization

Real-time Data Analysis and Visualization TechniquesЧтениеSimulating Real-Time Data Updates in Power BI with SQL ServerВидеоActivity: Create Real-Time Visualizations for TechHealth AnalyticsЧтениеReal-time Data Analysis Knowledge CheckЗаданиеReflect on the Advantages of Real-Time Data AnalysisDIALOGUE
04Data Integration and Management Challenges18 материалов

Lesson 1: Data Integration Challenges and Solutions

Overcoming Data SilosВидеоChallenges and Solutions in Data IntegrationЧтениеImplementing Data Integration SolutionsВидеоActivity: Identify Integration Challenges in TechHealth AnalyticsЧтениеData Integration Challenges Knowledge AssessmentЗаданиеReflect on the Impact of Integration on Data FlowDIALOGUE

Lesson 2: Designing Data Integration Workflows

Workflow Design for Data IntegrationЧтениеBuilding Integration Workflows with SQL ServerВидеоActivity: Develop Integration Workflows for TechHealth AnalyticsЧтениеWorkflow Design and Integration Knowledge CheckЗаданиеExplore Best Practices in Workflow DesignDIALOGUE

Lesson 3: Managing Multi-Source Data Streams

Managing Multi-Source Data StreamsЧтениеFlat File for DiscountTech WorkflowЧтениеHandling Data Streams in SQL ServerВидеоActivity: Manage Multi-Source Data for TechHealth AnalyticsЧтениеMulti-source Data Stream Management Knowledge AssessmentЗаданиеDiscuss Strategies for Managing Diverse Data StreamsDIALOGUE

Lesson 4: Course Wrap-Up

Wrapping Up and Congratulations!Чтение