Cloud SQL Infrastructure, Security, and Reliability

本课程是 Level Up: Advanced SQL for Data Engineering 专项课程的一部分

位教师：Professionals from the Industry

访问权限由 Coursera Learning Team 提供

10个模块

深入了解一个主题并学习基础知识。

高级设置等级

推荐体验

1 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

10个模块

深入了解一个主题并学习基础知识。

高级设置等级

推荐体验

1 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

您将学到什么

Build automated cloud data warehouses using Infrastructure as Code while implementing role-based access controls for enterprise security.
Diagnose and resolve database performance issues through lock contention analysis and systematic root cause investigation techniques.
Design cross-region disaster recovery architectures with automated failover capabilities to meet stringent business continuity requirements.
Optimize infrastructure costs by analyzing performance benchmarks and forecasting capacity needs for scalable data operations.

您将获得的技能

您将学习的工具

Terraform

要了解的详细信息

可分享的证书

添加到您的领英档案

作业

19 任务¹

AI 评分请参见免责声明

授课语言：英语（English）

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

积累特定领域的专业知识

本课程是 Level Up: Advanced SQL for Data Engineering 专项课程专项课程的一部分

在注册此课程时，您还会同时注册此专项课程。

向行业专家学习新概念
获得对主题或工具的基础理解
通过实践项目培养工作相关技能
获得可共享的职业证书

该课程共有10个模块

You'll gain the expertise to architect, secure, and optimize enterprise-grade cloud data warehouses that perform reliably at scale. This comprehensive course integrates critical infrastructure management skills—from automated resource provisioning to disaster recovery planning—preparing you for senior data engineering and platform engineering roles.

You'll apply Infrastructure as Code to build production systems, implement role-based access controls to protect sensitive data, and conduct root cause analysis to prevent costly system failures. What makes this course unique is its focus on real-world operational challenges: you'll diagnose performance bottlenecks, forecast capacity requirements, and design cross-region backup strategies that meet stringent business continuity standards. By combining hands-on technical skills with strategic planning capabilities, you'll be equipped to drive both system reliability and cost optimization—competencies that are increasingly valuable as organizations scale their data operations in the cloud.

You will learn the foundational skills needed to configure and monitor SQL warehouse resource pools that prevent query bottlenecks and ensure consistent performance across diverse workloads.

涵盖的内容

3个视频1篇阅读材料1个作业1个非评分实验室

3个视频总计16分钟

The Cost of Resource Contention: When Dashboards Break Production3分钟
SQL Warehouse Resource Pool Architecture and Configuration Principles8分钟
Configuring SQL Warehouse Resource Pools for Multi-Workload Environments6分钟

1篇阅读材料总计12分钟

Enterprise Resource Pool Implementation Strategies and Best Practices12分钟

1个作业总计5分钟

Resource Management Knowledge Check5分钟

1个非评分实验室总计18分钟

Configure and Monitor SQL Warehouse Resource Pools18分钟

You will develop expertise in conducting systematic security audits of data permissions to identify and remediate security vulnerabilities in enterprise database environments.

涵盖的内容

2个视频1篇阅读材料2个作业

2个视频总计22分钟

Database Permission Structures and Security Analysis Techniques11分钟
Conducting Database Permission Audits Using SQL Analysis Tools11分钟

1篇阅读材料总计8分钟

Permission Audit Methodologies and Risk Assessment Frameworks8分钟

2个作业总计23分钟

Enterprise Permission Audit and Risk Assessment Project20分钟
Data Security Analysis Knowledge Check3分钟

You will learn systematic post-mortem analysis techniques to evaluate system failures and develop actionable prevention strategies that strengthen infrastructure reliability.

涵盖的内容

2个视频1篇阅读材料3个作业

2个视频总计15分钟

When Everything Falls Apart: The Anatomy of a Cascade Failure4分钟
Post-Mortem Analysis Frameworks for Infrastructure Reliability Engineering10分钟

1篇阅读材料总计12分钟

Systematic Root Cause Analysis Methodologies for Data Infrastructure Failures12分钟

3个作业总计38分钟

Comprehensive Post-Mortem Analysis and Prevention Strategy Development20分钟
Root Cause Analysis Knowledge Check3分钟
Root Cause Analysis Assessment15分钟

You will implement and validate automated database backup systems with integrity verification to ensure reliable data protection in production environments.

涵盖的内容

3个视频1篇阅读材料2个作业

3个视频总计26分钟

When Database Failures Cost Millions: The Critical Need for Validated Backups4分钟
Database Backup Architecture: Automation, Validation, and Recovery Strategies9分钟
Building Automated Backup Scripts with Checksum Validation13分钟

1篇阅读材料总计10分钟

Implementing Checksum Validation in Database Backup Systems10分钟

2个作业总计21分钟

Enterprise Backup Automation Implementation18分钟
Automated Backup and Checksum Validation Knowledge Check3分钟

You will systematically diagnose database performance issues by analyzing lock contention patterns and implementing targeted resolution strategies for high-concurrency environments.

涵盖的内容

2个视频1篇阅读材料2个作业

2个视频总计23分钟

Dynamic Management Views for Lock Contention Analysis10分钟
Diagnosing Lock Contention Using SQL Server Management Studio13分钟

1篇阅读材料总计10分钟

Database Lock Contention: Mechanisms, Detection, and Analysis Strategies10分钟

2个作业总计23分钟

Lock Contention Diagnosis in Real Systems20分钟
Lock Contention Analysis and Resolution Assessment3分钟

You will analyze historical database growth patterns and create data-driven capacity forecasts that support proactive infrastructure planning and budget decisions.

涵盖的内容

2个视频1篇阅读材料2个作业1个非评分实验室

2个视频总计12分钟

The $2 Million Storage Crisis: When Capacity Planning Fails4分钟
Building Growth Trend Analysis with SQL and Excel8分钟

1篇阅读材料总计10分钟

Statistical Methods for Database Capacity Forecasting10分钟

2个作业总计18分钟

Capacity Planning and Growth Trend Analysis Assessment3分钟
Comprehensive Database Administration Assessment15分钟

1个非评分实验室总计18分钟

Building Statistical Capacity Forecasts with Excel18分钟

You will learn the fundamentals of Infrastructure as Code by creating and deploying Terraform configurations that automatically provision complete cloud data warehouse environments with proper policies and security controls.

涵盖的内容

3个视频1篇阅读材料2个作业

3个视频总计11分钟

Why Infrastructure as Code Transforms Data Platform Management3分钟
Infrastructure as Code Fundamentals for Data Warehousing5分钟
Building Your First Terraform Configuration for Snowflake Provisioning3分钟

1篇阅读材料总计10分钟

Terraform Essentials for Cloud Data Warehouse Provisioning10分钟

2个作业总计21分钟

Deploy a Multi-Environment Data Warehouse Infrastructure with Terraform18分钟
Infrastructure as Code Fundamentals Assessment3分钟

You will learn systematic cost-performance analysis by executing TPC-DS benchmarks across different warehouse configurations and creating data-driven recommendations for optimal infrastructure sizing.

涵盖的内容

2个视频1篇阅读材料2个作业

2个视频总计14分钟

Performance Measurement and Cost Analysis Strategies7分钟
Executing TPC-DS Benchmarks for Infrastructure Comparison7分钟

1篇阅读材料总计10分钟

TPC-DS Benchmarking and Cost-Performance Analysis Fundamentals10分钟

2个作业总计23分钟

Comprehensive Cost-Performance Analysis for Data Warehouse Optimization20分钟
Cost-Performance Analysis and Benchmarking Assessment3分钟

You will architect comprehensive disaster recovery systems by implementing cross-region replication, automated failover mechanisms, and recovery procedures that meet stringent 15-minute Recovery Point Objectives for business continuity.

涵盖的内容

2个视频1篇阅读材料2个作业1个非评分实验室

2个视频总计10分钟

Why Disaster Recovery Architecture Protects Business Continuity3分钟
Disaster Recovery Architecture Patterns and Implementation Strategies7分钟

1篇阅读材料总计10分钟

Cross-Region Disaster Recovery Architecture Fundamentals10分钟

2个作业总计18分钟

Cross-Region Disaster Recovery Architecture Mastery Check3分钟
Cross-Region Disaster Recovery Architecture Mastery Assessment15分钟

1个非评分实验室总计20分钟

Cross-Region Disaster Recovery Architecture Design20分钟

You create a comprehensive cloud data warehouse infrastructure project that integrates security management, performance optimization, and disaster recovery planning. This project synthesizes advanced SQL infrastructure skills to build a production-ready data platform with automated backup systems and cross-region resilience.