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

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

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

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

Database Administration, Security & Access Control

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

О курсе

Learn the core skills required to manage, secure, and optimize modern database environments through this comprehensive course in the Data Engineering Skill Path. You will develop essential competencies in monitoring database performance, analyzing execution plans, designing indexing strategies, tuning queries, automating maintenance tasks, and implementing strong security and access controls. Through hands-on practice with IBM Db2, PostgreSQL, Linux/Unix automation workflows, and Microsoft Power BI governance tools, you will learn how to maintain reliable, performant, and secure data systems across enterprise environments. This course brings together expertise from IBM and Microsoft, offering multiple perspectives on database administration—from foundational relational concepts and warehouse performance tuning to troubleshooting, backup strategies, RBAC configuration, and end-to-end governance. You will progress from understanding database structures and execution behavior to optimizing workloads, automating routine operations, and enforcing policies that protect sensitive data. Ideal for aspiring database administrators and data engineers, this course equips you with the practical skills and conceptual depth needed to manage mission-critical data infrastructure with confidence, precision, and security.

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

Shell ScriptDatabase TheoryData AccessData ModelingDatabase Management SystemsSnowflake SchemaStar SchemaDatabase ManagementData SecurityPerformance TuningIT AutomationPower BIData WarehousingIBM DB2PostgreSQLDatabase DesignRelational DatabasesDatabase Architecture and AdministrationRole-Based Access Control (RBAC)Database Administration

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

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

01Start Here: Get Oriented and Check Your Skills2 материалов
Start Here: How This Skill-Based Course WorksЧтениеSkill Diagnostic: Find Your Recommended Starting PointЗадание
02Monitoring and Optimization14 материалов

Monitoring and Optimization

Overview of Database MonitoringВидео

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

Professionals from the Industry

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

Database Administration, Security & Access Control
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 32.9 ч

10 модулей

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

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

Часть программы вашего университета
Monitoring Usage and Performance - Part 1Видео
Monitoring Usage and Performance - Part 2Видео
Optimizing DatabasesВидео
Optimizing QueriesВидео
Optimizing QueriesЧтение
Using IndexesВидео
Overview of SQLite and Key Concepts in Datasette PLUGIN
Reading: Improving Performance of Slow Queries in MySQLPLUGIN
Hands-on Lab: Improving Performance of Slow Queries in MySQLВнешний инструмент
Hands-on Lab: Monitoring and Optimizing your Databases in MySQLВнешний инструмент
Hands-on Lab: Monitoring and Optimizing your Databases in PostgreSQLВнешний инструмент
Summary & HighlightsЧтение
Practice Quiz: Monitoring and OptimizationЗадание
03Concepts for data modeling34 материалов

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ЧтениеAdditional resources: Concepts for data modelingЧтение

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Чтение
04Relational Database Concepts20 материалов

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Видео
05Designing, Modeling, and Implementing Data Warehouses17 материалов

Designing, Modeling and Implementing Data Warehouses

Overview of Data Warehouse Architectures ВидеоCubes, Rollups, and Materialized Views and TablesВидеоGrouping Sets in SQLЧтениеFacts and Dimensional ModelingВидеоHands-on Lab: Working with Facts and Dimension TablesВнешний инструментData Modeling using Star and Snowflake SchemasВидеоUnderstanding Slowly Changing Dimensions (SCD)ЧтениеData Warehousing with Star and Snowflake schemasЧтениеStaging Areas for Data WarehousesВидеоHands-on Lab: Setting up a Staging AreaВнешний инструментVerify Data QualityВидеоHands-on Lab: Verifying Data Quality for a Data WarehouseВнешний инструментPopulating a Data WarehouseВидеоHands-on Lab: Populating a Data Warehouse using PostgreSQLВнешний инструментQuerying the DataВидеоHands-On Lab: Querying the Data Warehouse using PostgreSQL (Cubes, Rollups, Grouping Sets and Materialized Views)Внешний инструментPractice Quiz: Designing, Modeling and Implementing Data WarehousesЗадание
06Troubleshooting & Automation9 материалов

Troubleshooting & Automation

Troubleshooting Common IssuesВидеоUsing Status Variables, Error Codes, and DocumentationВидеоUsing Logs for TroubleshootingВидеоHands-on Lab: Troubleshooting with PostgreSQLВнешний инструментOverview of Automating Database TasksВидеоAutomating Reports and AlertsВидеоHands-on Lab: Automating Tasks in MySQL using Shell ScriptsВнешний инструментSummary & HighlightsЧтениеPractice Quiz: Troubleshooting and AutomationЗадание
07Managing Databases22 материалов

Backup and Restore Databases

Introduction to Backup and RestoreВидеоTypes of BackupВидеоBackup PoliciesВидеоUsing Database Transaction Logs for RecoveryВидеоHands-on Lab: Upload and Export using DatasetteВнешний инструмент(Optional) Hands-on Lab: Upload and Export using Db2 on CloudPLUGINHands-on Lab: Backup and Restore using PostgreSQLВнешний инструментHands-on Lab: Backup and Restore using MySQLВнешний инструментReading: Perform Point-in-Time Backup and RestorePLUGINReading: Performing MySQL Physical Backup and RestorationPLUGINSummary & HighlightsЧтениеPractice Quiz: Back Up and Restore DatabasesЗадание

Security and User Management

Overview of Database SecurityВидеоUsers, Groups, and RolesВидеоManaging Access to Databases and Their ObjectsВидеоAuditing Database ActivityВидеоEncrypting DataВидеоHands-on Lab: MySQL User Management, Access Control, and EncryptionВнешний инструмент
08Security and monitoring32 материалов

Sharing information in Power BI

Safely sharing informationВидеоSharing via linksВидеоData sensitivity labelsВидеоExercise: Applying sensitivity labelsЧтениеSelf-review: Applying sensitivity labels ЗаданиеExemplar: Applying sensitivity labelsЧтениеLeaking of sensitive dataВидеоKnowledge check: Sharing information in Power BI ЗаданиеAdditional resources: Sharing information in Power BIЧтение

Organizations and permissions

Dataset permissionsВидеоConfiguring dataset permissionsВидеоPermissions cheatsheetЧтениеHow would dataset permissions impact different business departments?ОбсуждениеSharing outside your organizationВидеоKnowledge check: Organizations and permissions Задание

Row-level security

What is row-level security?ВидеоStatic versus dynamic row-level securityЧтениеConfiguring static row-level securityВидеоDynamic row-level security with DAXВидеоKnowledge check: Row-level security ЗаданиеAdditional resources: Row-level securityЧтение

Subscriptions and alerts

Subscribing to reports and dashboardsВидеоConfiguring data alertsВидеоExercise: Configuring a data alertЧтениеSelf-review: Configuring a data alert ЗаданиеExemplar: Configuring a data alertЧтениеHow data alerts prevented trading lossesВидео
09Performance and security23 материалов

Performance optimization

Introduction to the Performance analyzerВидеоTuning report performanceЧтениеResolving performance issues in DAXВидеоUsing variables for performanceВидеоActivity: Improving DAX performanceЗаданиеExemplar: Improving DAX performanceЧтениеKnowledge check: Performance optimizationЗадание

Working with sensitive data

Sharing information safelyВидеоSharing via linksВидеоData sensitivity labelsВидеоDataset permissionsВидеоPermissions cheat sheetЧтениеSharing outside your organisationВидеоActivity: Share information

Row-level security

What is row-level security?ВидеоStatic vs dynamic row-level securityВидеоConfiguring static row-level securityВидеоDynamic row-level security with DAXВидеоKnowledge Check: Row-level securityЗадание

Module wrap up

Summary: Performance and securityВидеоAdditional resources: Performance and securityЧтение
10Assessment2 материалов

Lesson

Learner Expectations for Skill AssessmentЧтениеSkill AssessmentЗадание
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Задание
Summary: Concepts for data modelingВидео
Additional resources: Working with advanced data modelsЧтение
PostgreSQLВидео
Reading: Deep Dive into Advanced Relational Model ConceptsPLUGIN
Reading: Advanced Relational Model ConceptsPLUGIN
Summary and HighlightsЧтение
Practice Quiz: Introducing Relational Database ProductsЗадание
Hands-on Lab: User Management and Access Control in PostgreSQLВнешний инструмент
(Optional) Reading: User Management with DB2PLUGIN
Summary & HighlightsЧтение
Practice Quiz: Security and User ManagementЗадание
Additional resources: Organizations and permissionsЧтение
Implementing Security measures and Alerting in a Power BI ReportDIALOGUE
Knowledge check: Subscriptions and alerts Задание
Summary: Security and monitoringВидео
Additional resources: Subscriptions and alertsЧтение
Задание
Exemplar: Share informationЧтение
Knowledge check: Working with sensitive dataЗадание