Monthly Subscription Starting at AED 99 + VAT

Data Warehousing with Microsoft Azure Synapse Analytics
  • Level Professional
  • Duration 15 hours
  • Course by Microsoft
  • Offered by

About

In this course, you will explore the tools and techniques that can be used to work with Modern Data Warehouses productively and securely within Azure Synapse Analytics. You will learn how Azure Synapse Analytics enables you to build Data Warehouses using modern architecture patterns and how the common schema is implemented in a data warehouse. You'll learn the best practices you need to adopt to load data into a data warehouse and the techniques that you can use to optimize query performance within Azure Synapse Analytics. This course is part of a Specialization intended for Data engineers and developers who want to demonstrate their expertise in designing and implementing data solutions that use Microsoft Azure data services for anyone interested in preparing for the Exam DP-203: Data Engineering on Microsoft Azure (beta). This is the fifth course in a program of 10 courses to help prepare you to take the exam so that you can have expertise in designing and implementing data solutions that use Microsoft Azure data services. The Data Engineering on Microsoft Azure exam is an opportunity to prove knowledge expertise in integrating, transforming, and consolidating data from various structured and unstructured data systems into structures that are suitable for building analytics solutions that use Microsoft Azure data services. Each course teaches you the concepts and skills that are measured by the exam. By the end of this Specialization, you will be ready to take and sign-up for the Exam DP-203: Data Engineering on Microsoft Azure (beta).

Modules

Welcome to the course

    • 1 Videos
    • 2 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Data retrieval

1 Videos

  • Introduction to the course

2 Readings

  • Course syllabus
  • How to be successful in this course

Build a modern data warehouse

    • 2 Videos
    • 2 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Knowledge check

2 Videos

  • Describe a modern data warehouse
  • Define a modern data warehouse architecture

2 Readings

  • Identify modern data warehouse architecture components
  • Design ingestion patterns for a modern data warehouse

Work with data in a modern data warehouse

    • 3 Videos
    • 2 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Knowledge check
  • Test prep

3 Videos

  • Understand data storage for a modern data warehouse
  • Understand file formats and structure for a modern data warehouse
  • Module summary

2 Readings

  • Prepare and transform data with Azure Synapse Analytics
  • Serve data for analysis with Azure Synapse Analytics

Design and implement data stores in a modern data warehouse

    • 3 Videos
    • 5 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Knowledge check
  • Test prep

3 Videos

  • Module introduction
  • Design and implement a star schema
  • Module summary

5 Readings

  • Create a star schema
  • Design and implement a snowflake schema
  • Create a snowflake schema
  • Design and implement a time dimension table
  • Create and populate a time dimension table

Use data loading best practices in Azure Synapse Analytics

    • 7 Videos
    • 3 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Knowledge check
  • Test prep

7 Videos

  • Lesson introduction
  • Understand data load design goals
  • Explain load methods into Azure Synapse Analytics
  • Manage source data files
  • Manage singleton updates and concurrent access to Azure Synapse Analytics
  • Implement workload management
  • Lesson summary

3 Readings

  • Set-up dedicated data load accounts
  • Implement workload management
  • Simplify ingestion with the Copy Activity

Optimize data warehouse query performance in Azure Synapse Analytics

    • 8 Videos
    • 3 Readings
    • 1 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Knowledge check
  • Test prep

8 Videos

  • Lesson introduction
  • Understand performance issues related to tables
  • Understand table distribution design
  • Use indexes to improve query performance
  • Improve query performance with materialized views
  • Use read committed snapshot for data consistency
  • Optimize common queries with result-set caching
  • Lesson summary

3 Readings

  • Understand performance issues related to tables
  • Use table distribution and indexes to improve performance
  • Create statistics to improve query performance

Integrate SQL and Apache Spark pools in Azure Synapse Analytics

    • 6 Videos
    • 4 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Knowledge check

6 Videos

  • Lesson introduction
  • Describe the integration methods between SQL and Spark pools in Azure Synapse Analytics
  • Understand the use-cases for SQL and Spark pools integration
  • Authenticate in Azure Synapse Analytics
  • Externalize the use of Spark pools within Azure Synapse Workspace
  • Lesson summary

4 Readings

  • Transfer data between SQL and Spark pool in Azure Synapse Analytics
  • Authenticate between Spark and SQL pool in Azure Synapse Analytics
  • Integrate SQL and Spark pools in Azure Synapse Analytics
  • Transfer data outside the Synapse workspace using the PySpark connector

Understand data warehouse developer features of Azure Synapse Analytics

    • 5 Videos
    • 5 Readings
    • 2 Assignment
Show info about module content

2 Assignment

  • Knowledge check
  • Test prep

5 Videos

  • Lesson introduction
  • Work with windowing functions
  • Work with approximate execution
  • Encapsulate transact-SQL logic with stored procedures
  • Lesson summary

5 Readings

  • Explore the development tools for Azure Synapse Analytics
  • Understand transact-SQL language capabilities for Azure Synapse Analytics
  • Work with windowing functions
  • Work with approximate execution
  • Work with JSON data in SQL pools

Manage and monitor data warehouse activities in Azure Synapse Analytics

    • 4 Videos
    • 3 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Knowledge check

4 Videos

  • Lesson introduction
  • Pause compute in Azure Synapse Analytics
  • Use Azure Advisor to review recommendations
  • Lesson summary

3 Readings

  • Scale compute resources in Azure Synapse Analytics
  • Manage workloads in Azure Synapse Analytics
  • Use dynamic management views to identify and troubleshoot query performance

Analyze and optimize data warehouse storage in Azure Synapse Analytics

    • 5 Videos
    • 7 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Knowledge check

5 Videos

  • Lesson introduction
  • Understand column store storage details
  • Describe the impact of materialized views
  • Understand rules for minimally logged operations
  • Lesson summary

7 Readings

  • Understand skewed data and space usage
  • Check for skewed data and space usage
  • View column store storage details
  • Understand the impact of wrong choices for column data types
  • Compare storage requirements between optimal and sub-optimal column data types
  • Improve the execution plan of a query with a materialized view
  • Optimize a delete operation

Secure a data warehouse in Azure Synapse Analytics

    • 8 Videos
    • 3 Readings
    • 2 Plugin
    • 2 Assignment
Show info about module content

2 Assignment

  • Knowledge check
  • Test prep

8 Videos

  • Lesson introduction
  • Understand network security options for Azure Synapse Analytics
  • Configure authentication
  • Configure authentication using keys and shared access
  • Manage authorization through column and row level security
  • Manage authorization through column and row level security - Permissions and Best practices
  • Implement encryption in Azure Synapse Analytics
  • Lesson summary

3 Readings

  • Configure conditional access
  • Manage authorization through column and row level security
  • Manage sensitive data with Dynamic Data Masking

Course Practice Exam

    • 1 Videos
    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Course practice exam

1 Videos

  • Course recap

1 Readings

  • About the practice exam

Course wrap up

    • 1 Videos
    • 1 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Reflect on learning

1 Videos

  • Course summary

1 Readings

  • Next steps

Auto Summary

Explore the tools and techniques for modern data warehousing with "Data Warehousing with Microsoft Azure Synapse Analytics." This professional-level course, led by Coursera, focuses on optimizing query performance and secure data handling within Azure Synapse Analytics. Ideal for data engineers and developers preparing for the Exam DP-203: Data Engineering on Microsoft Azure, this course is part of a 10-course specialization. Enhance your expertise in designing and implementing data solutions over 900 minutes of content with flexible subscription options.

Microsoft
Instructor

Microsoft