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

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

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

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

Automate, Analyze, and Database Administration

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

О курсе

Database failures can cost enterprises millions of dollars per hour, while poor capacity planning leads to unexpected outages and budget overruns. This Short Course was created to help data engineering professionals accomplish advanced database administration that ensures both reliability and optimal performance. By completing this course, you'll be able to implement bulletproof backup validation systems, quickly diagnose and resolve database performance issues that plague high-concurrency applications, and create accurate capacity forecasts that prevent infrastructure surprises. By the end of this course, you will be able to: - Apply automated backup and restore procedures with checksum verification - Analyze database performance to diagnose and resolve lock contention - Evaluate growth trends to produce capacity-planning forecasts This course is unique because it combines hands-on automation with real-world troubleshooting scenarios that mirror actual production environments. To be successful in this project, you should have a background in SQL fundamentals, database concepts, and basic system administration.

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

Capacity ManagementForecastingOperational DatabasesResource PlanningPerformance AnalysisDatabase Architecture and AdministrationTime Series Analysis and ForecastingDatabase ManagementDemand PlanningRelational DatabasesData AccessData IntegrityPerformance TuningData ValidationDisaster RecoveryCapacity PlanningData MaintenanceProblem Management

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

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

01Module 1: Apply Automated Backup and Restore Procedures with Checksum Verification6 материалов
When Database Failures Cost Millions: The Critical Need for Validated BackupsВидеоDatabase Backup Architecture: Automation, Validation, and Recovery StrategiesВидеоImplementing Checksum Validation in Database Backup SystemsЧтениеBuilding Automated Backup Scripts with Checksum ValidationВидео

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

Professionals in the Industry

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

Automate, Analyze, and Database Administration
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 3.4 ч

3 модулей

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

Субтитры: Арабский, Французский, Итальянский, Бразильский португальский, Корейский, Немецкий, Азербайджанский, Испанский, Японский

Часть программы вашего университета
Enterprise Backup Automation ImplementationЗадание
Automated Backup and Checksum Validation Knowledge CheckЗадание
02Module 2: Analyze Database Performance to Diagnose and Resolve Lock Contention6 материалов
Critical Performance Crisis: When Lock Contention Brings Systems DownDIALOGUE Database Lock Contention: Mechanisms, Detection, and Analysis StrategiesЧтениеDynamic Management Views for Lock Contention AnalysisВидеоDiagnosing Lock Contention Using SQL Server Management StudioВидеоLock Contention Diagnosis in Real SystemsЗадание Lock Contention Analysis and Resolution AssessmentЗадание
03Module 3: Evaluate Growth Trends to Produce Capacity-Planning Forecasts7 материалов
The $2 Million Storage Crisis: When Capacity Planning FailsВидеоStatistical Methods for Database Capacity ForecastingЧтение Building Growth Trend Analysis with SQL and ExcelВидеоCreating Capacity Forecasts with SQL Server and Excel IntegrationDIALOGUEBuilding Statistical Capacity Forecasts with ExcelЛабораторнаяCapacity Planning and Growth Trend Analysis AssessmentЗадание Comprehensive Database Administration AssessmentЗадание