Student? Switch to our Career Center Site →
Contact Us

DP-203T00 Data Engineering on Microsoft Azure

In this course, the student will learn how to implement and manage data engineering workloads on Microsoft Azure, using Azure services such as Azure Synapse Analytics, Azure Data Lake Storage Gen2, Azure Stream Analytics, Azure Databricks, and others. The course focuses on common data engineering tasks such as orchestrating data transfer and transformation pipelines, working with data files in a data lake, creating and loading relational data warehouses, capturing and aggregating streams of real-time data, and tracking data assets and lineage.
Select Class Date
Course Details

Price:

Days:

4

Location:

Virtual

Course Overview

In this course, the student will learn how to implement and manage data engineering workloads on Microsoft Azure, using Azure services such as Azure Synapse Analytics, Azure Data Lake Storage Gen2, Azure Stream Analytics, Azure Databricks, and others. The course focuses on common data engineering tasks such as orchestrating data transfer and transformation pipelines, working with data files in a data lake, creating and loading relational data warehouses, capturing and aggregating streams of real-time data, and tracking data assets and lineage.
  • Scroll right to view Objectives, Prerequisites, and Agenda

Successful students start this course with knowledge of cloud computing and core data concepts and professional experience with data solutions. AZ-900T00 Microsoft Azure Fundamentals DP-900T00 Microsoft Azure Data Fundamentals

1 – Introduction to Transact-SQL

  • Work with schemas
  • Explore the structure of SQL statements
  • Examine the SELECT statement
  • Work with data types
  • Handle NULLs

2 – Sort and filter results in T-SQL

  • Sort your results
  • Limit the sorted results
  • Page results
  • Remove duplicates
  • Filter data with predicates

3 – Combine multiple tables with JOINs in T-SQL

  • Understand joins concepts and syntax
  • Use inner joins
  • Use outer joins
  • Use cross joins
  • Use self joins

4 – Write Subqueries in T-SQL

  • Understand subqueries
  • Use scalar or multi-valued subqueries
  • Use self-contained or correlated subqueries

5 – Use built-in functions and GROUP BY in Transact-SQL

  • Categorize built-in functions
  • Use scalar functions
  • Use ranking and rowset functions
  • Use aggregate functions
  • Summarize data with GROUP BY
  • Filter groups with HAVING

6 – Modify data with T-SQL

  • Insert data
  • Generate automatic values
  • Update data
  • Delete data
  • Merge data based on multiple tables
Select Class Date
Class Dates & Times
Filters Sort results
Reset Apply
No results found. Clear filters and try again?
— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.