Coursera

Level Up: Advanced SQL for Data Engineering 专项课程

Coursera

Level Up: Advanced SQL for Data Engineering 专项课程

Advanced SQL for Enterprise Data Engineering.

Learn production-grade SQL skills for building, securing, and optimizing enterprise data systems.

访问权限由 Coursera Learning Team 提供

深入学习学科知识
高级设置 等级

推荐体验

4 周 完成
在 10 小时 一周
灵活的计划
自行安排学习进度
深入学习学科知识
高级设置 等级

推荐体验

4 周 完成
在 10 小时 一周
灵活的计划
自行安排学习进度

您将学到什么

  • Build automated ELT pipelines with advanced SQL techniques and create enterprise-grade data architectures optimized for performance and cost.

  • Design lakehouse architectures with dimensional modeling, implementing star schemas and slowly changing dimensions for scalable analytics.

  • Implement comprehensive security frameworks, role-based access controls, and Infrastructure as Code for production data systems.

  • Develop data quality governance, automated testing frameworks, and disaster recovery strategies for enterprise data reliability.

要了解的详细信息

可分享的证书

添加到您的领英档案

授课语言:英语(English)
最近已更新!

March 2026

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

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

精进特定领域的专业知识

  • 向大学和行业专家学习热门技能
  • 借助实践项目精通一门科目或一个工具
  • 培养对关键概念的深入理解
  • 通过 Coursera 获得职业证书

专业化 - 5门课程系列

Advanced SQL for Data Pipeline Optimization

Advanced SQL for Data Pipeline Optimization

第 1 门课程, 小时

您将学到什么

  • Build automated ELT pipelines with parameterized SQL and create comprehensive data flow documentation for complex multi-stage processes.

  • Optimize pipeline performance through benchmarking, partitioning strategies, and automated testing to reduce processing time and costs.

  • Implement advanced SQL techniques including window functions, MERGE operations, and data validation frameworks for enterprise systems.

  • Design data reconciliation rules and slowly changing dimension logic to maintain data integrity across multiple source systems.

您将获得的技能

类别:JSON
类别:Dashboard
类别:Data Pipelines
类别:Dimensionality Reduction
类别:Extract, Transform, Load
类别:Data Validation
类别:Systems Integration
类别:Verification And Validation
类别:Data Quality
类别:Data Mart
类别:Data Transformation
类别:SQL
类别:Database Management
类别:Performance Tuning
类别:Data Integration
类别:Star Schema
类别:Data Warehousing
类别:Data Processing
Data Modeling and Lakehouse Architecture with SQL

Data Modeling and Lakehouse Architecture with SQL

第 2 门课程, 小时

您将学到什么

  • Design star and snowflake schemas with dimensional modeling principles, creating fact and dimension tables optimized for analytics.

  • Implement cost-effective data warehouse architectures with partitioning, clustering, and multi-cluster workload isolation strategies.

  • Build lakehouse data pipelines that integrate file-based storage with structured querying using external tables and modern formats.

  • Create semantic metrics layers and slowly changing dimension logic to ensure data consistency across enterprise analytics systems.

您将获得的技能

类别:Data Mart
类别:SQL
类别:Star Schema
类别:Performance Tuning
类别:Business Metrics
类别:Semantic Web
类别:Data Modeling
类别:Database Design
类别:Data Lakes
类别:Data Architecture
类别:Data Pipelines
类别:Issue Tracking
类别:Resource Utilization
类别:Data Warehousing
类别:Data Integrity
类别:Dimensionality Reduction
SQL Performance, Testing, and Data Integrity

SQL Performance, Testing, and Data Integrity

第 3 门课程, 小时

您将学到什么

  • Diagnose and resolve SQL query performance bottlenecks using execution plan analysis and advanced optimization techniques.

  • Implement comprehensive testing frameworks including unit tests, schema validation, and data quality checks for robust pipelines.

  • Build automated CI/CD workflows for database migrations and create custom functions to standardize business logic across teams.

  • Execute safe data modifications with audit trails and develop idempotent scripts that maintain data integrity in production.

您将获得的技能

类别:CI/CD
类别:Statistical Hypothesis Testing
类别:Database Architecture and Administration
类别:Plan Execution
类别:Data Migration
类别:Stored Procedure
类别:Unit Testing
类别:Performance Tuning
类别:Jest (JavaScript Testing Framework)
类别:Continuous Deployment
类别:Data Transformation
类别:Database Development
类别:Data Integrity
类别:SQL
类别:Database Management
类别:Query Languages
类别:Computer Graphic Techniques
类别:Verification And Validation
类别:Debugging
类别:Auditing
Cloud SQL Infrastructure, Security, and Reliability

Cloud SQL Infrastructure, Security, and Reliability

第 4 门课程, 小时

您将学到什么

  • 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.

您将获得的技能

类别:Business Continuity Planning
类别:Site Reliability Engineering
类别:Data Infrastructure
类别:Capacity Management
类别:Cloud Security
类别:Capacity Planning
类别:Cost Benefit Analysis
类别:Terraform
类别:Performance Analysis
类别:Infrastructure as Code (IaC)
类别:Security Requirements Analysis
类别:Data Integrity
类别:Cloud Infrastructure
类别:Resource Management
类别:Disaster Recovery
类别:Problem Management
类别:Performance Tuning
类别:Data Security
类别:Solution Architecture
类别:Database Architecture and Administration
SQL Data Quality, Security, and Governance

SQL Data Quality, Security, and Governance

第 5 门课程, 小时

您将学到什么

  • Build automated SQL validation frameworks to detect and resolve data quality issues in production pipelines.

  • Implement comprehensive data security controls including masking, monitoring, and compliance auditing practices.

  • Create strategic roadmaps and cost-benefit models to guide data infrastructure modernization decisions.

  • Develop performance dashboards and analytics to optimize data warehouse scaling and operational efficiency.

您将获得的技能

类别:SQL
类别:Dashboard
类别:Data Security
类别:Statistical Analysis
类别:Database Management
类别:Data Pipelines
类别:Data Management
类别:Data Warehousing
类别:Cost Benefit Analysis
类别:Data Migration
类别:Data Strategy
类别:Data Infrastructure
类别:Security Controls
类别:Data Quality
类别:Root Cause Analysis
类别:Data Integrity
类别:Correlation Analysis
类别:Auditing
类别:Data Governance
类别:Data Validation

获得职业证书

将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。

位教师

Professionals from the Industry
376 门课程54,291 名学生

提供方

Coursera

人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

自 2018开始学习的学生
''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情,我就可以学习。'

Jennifer J.

自 2020开始学习的学生
''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'

Larry W.

自 2021开始学习的学生
''如果我的大学不提供我需要的主题课程,Coursera 便是最好的去处之一。'

Chaitanya A.

''学习不仅仅是在工作中做的更好:它远不止于此。Coursera 让我无限制地学习。'