DP-203 - Data Engineering on Microsoft Azure

This chapters looks into understanding data

This chapters looks into a lab on Azure storage accounts

This chapters looks into Azure Data Lake Gen-2 storage accounts

This chapters looks into a Lab on creating Azure Data Lake Gen2 storage accounts

This chapters looks into using Power BI to view your data

This chapters looks has all the code for this section

This chapters looks into the section introduction

This chapters looks into the internals of a database

This chapters looks into setting up a new Azure SQL database

This chapters looks into the T-SQL Select clause

This chapters looks into the T-SQL Where clause

This chapters looks into the T-SQL Order by clause

This chapters looks into the T-SQL Aggregate functions

This chapters looks into the T-SQL Group by clause

This chapters looks has all the code for this section

This chapters looks into the Section introduction

This chapters looks into Azure Synapse Analytics

This chapters looks into creating an Azure Synapse workspace

This chapters looks into the different compute options

This chapters looks into a lab on external tables - Part 1

This chapters looks into a lab on external tables - Part 2

This chapters looks into creating a SQL Pool

This chapters looks into loading data into a Dedicated SQL Pool

This chapters looks into  copying data using the COPY command

This chapters looks into copying data using the COPY command with Parquet data

This chapters looks into designing a data warehouse

This chapters looks into dimension tables

This chapters looks into building a fact table

This chapters looks into building a dimension table

This chapters looks into transferring data into the SQL Pool

This chapters looks into Power BI for the star schema

This chapters looks into understanding Azure Synapse Architecture

This chapters looks into understanding table types

This chapters looks into hash-distributed tables

This chapters looks into creating replicated tables

This chapters looks into designing your tables

This chapters looks into surrogate keys for dimension tables

This chapters looks into slowly changing dimensions

This chapters looks into the case statement

This chapters looks into the Spark pool

This chapters looks into a section introduction

This chapters looks into the Extract, Transform and load process

This chapters looks into Azure Data Factory

This chapters looks into starting with Azure Data Factory

This chapters looks into loading a csv file into Azure Synapse via Azure Data Factory

This chapters looks into generating a parquet file

This chapters looks into a review on what has been done so far

This chapters looks into using a query for data transfer

This chapters looks into Mapping Data Flow

This chapters looks into mapping data flow for a fact table

This chapters looks into mapping data flow for the Dimension Customer table

This chapters looks into mapping data flow for the Dimension Product table

This chapters looks into Surrogate keys

This chapters looks into converting parquet files to JSON files

This chapters looks into loading JSON data into the SQL Pool

This chapters looks into the self-hosted integration runtime

This chapters looks into setting up nginx for the self-hosted runtime environment

This chapters looks into setting up the runtime

This chapters looks into the copy activity

This chapters looks into the mapping data flow for the copy activity

This chapters looks into Batch and Real-time processing

This chapters looks into Azure Event Hubs

This chapters looks into creating an Event Hub instance

This chapters looks into Azure Stream Analytics

This chapters looks into a Stream Analytics job

This chapters looks into a review on what we have seen so far

This chapters looks into timing windows

This chapters looks into adding multiple outputs

This chapters looks into reference data

This chapters looks into Power BI Output

This chapters looks has all the code for this section

This chapters looks into creating a Spark Pool

This chapters looks into working with Notebooks

This chapters looks into writing data into the Spark Pool

This chapters looks into sharing tables

This chapters looks into column-level security

This chapters looks into row-level security

This chapters looks into Data Masking

This chapters looks into Azure AD Authentication

This chapters looks into creating an admin

This chapters looks into creating a user

This chapters looks into best practices for your data lake

This chapters looks into workload management