Data Engineering on Microsoft Azure: The Definitive Guide

سرفصل های دوره

Hands-On Introduction to Azure Data Services. Learn Data Factory, Synapse Analytics, SQL Database, and more

01 - Introduction - Understanding Core Data Concepts

001 Introduction

002 What is Data - A simple definition

003 What is Structured Data

004 What is Non Relational Data

005 What is Data Ingestion

006 What is Data Processing

007 Batch Processing vs Stream Processing

008 What is Data Analytics

02 - Azure SQL - Introduction

001 Create a Single Instance Database

002 What is a Resource Group

002 weblinks.pdf

003 Azure Data Studio - Introduction

003 weblinks.pdf

004 Create a Virtual Machine

005 Connect to Azure Database from an Azure Virtual Machine

005 mssql-cli-guide.txt

006 Authentication and Authorization

007 Create a SQL Login and User

007 azsql-createuser.zip

008 SQL Server Management Studion - Introduction

008 weblinks.pdf

009 Understanding Tables and Views

010 How to Create a Database Diagram in SSMS

011 Azure Cost Management - How to Create a Budget in Azure

03 - Azure Blob Storage - Introduction

001 Introduction to Azure Storage

002 Create an Azure Storage Account

003 AzureStorage-WebResources.pdf

003 Upload Data using the Azure Portal

003 blobs.zip

004 Upload Data using Azure Storage Explorer

004 blobs.zip

005 AzureStorage-WebResources.pdf

005 Connect a Storage Account with a Shared Access Signature

006 AzureStorage-WebResources.pdf

006 Azure CLI - Generate a Shared Access Signature

006 generate-sas-cli.txt

007 AzureStorage-WebResources.pdf

007 Understanding Data Redundancy

008 AzureStorage-WebResources.pdf

008 Azure Storage Account - Redundancy Options

04 - Azure Data Factory - Core Concepts

001 Section Intro

002 Create Data Store and Target

002 wideworldimporters-standard.zip

003 Create Data Factory and Linked Services

003 Section-ADF-Important-Links.pdf

004 Create Datasets

005 Create Pipeline and Activities

006 Create Mapping Data Flow and Adding Sources

007 Mapping Data Flow - Joining Sources

008 Mapping Data Flow - Aggregate Data

009 Mapping Data Flow Execution

010 Mapping Data Flow and Apache Spark Execution

05 - Practice Section Build an ETL Pipeline with Azure Data Factory

001 Introduction

002 Cost Warning - Data Pipeline Pricing

003 BuildingEnd2EndPipelineResources.zip

003 IMPORTANT Download Resources Before Starting.html

004 Azure SQL - Contained Users

005 Azure Key Vault - Store SQL Server Secrets

006 Azure Key Vault - Linked Service

007 Create Azure Storage Account

008 Azure Managed Identity - Create a Linked Service To Azure Blob Storage

009 Azure Role Based Access Control - Grant Access To Managed Identity

010 Create a Dataset for the Lookup Activity

011 Azure Data Factory - Lookup Activity

012 Azure Data Factory - ForEach Activity And Pipeline Expressions

013 Azure Data Factory - ForEach Activity - Part II

014 Parameterize a Dataset Part I - Container Name

015 Parameterize a Dataset Part II - Directory Name

016 Parameterize a Dataset Part III - File Name

017 Mapping Data Flow - JSON Source

018 Mapping Data Flow - Parquet Source

019 Mapping Data Flow - JOIN And Derived Column Transformations

020 Mapping Data Flow - Aggregate Transformation

021 Mappind Data Flow - Parameterized CSV File Sink

022 Azure Data Factory - Store SAS In Azure Key Vault

023 Azure Data Factory - Copy Activity Merge Behaviour

024 Azure Data Factory - End To End Pipeline Execution

025 Azure Data Factory - Storage Event Triggers

06 - Azure Synapse Analytics - Serverless SQL pool

001 IMPORTANT Download Resources Before Starting.html

001 Section-6-Resources.zip

002 Data Processing - OLAP vs OLTP

003 Azure Synapse Analytics - Create a Synapse workspace

004 Azure Synapse Analytics - Serverless SQL Pool Introduction

005 Serverless SQL pool - Connect with Azure AD User And Azure Data Studio

006 Serverless SQL pool - Server Level Credential

007 Openrowset - Read Parquet Files

008 Openrowset - Read CSV Files

009 Openrowset - Read JSON - Line Delimited JSON

010 Openrowset - Read JSON - Array of Objects

011 Serverless SQL pool - Introduction to External Tables

012 Serverless SQL pool - Create External Table - Part I

013 Serverless SQL pool - Create External Table - Part II

014 Serverless SQL pool - Create External Table III - How to Handle Dirty Records

015 Serverless SQL pool - CETAS - Create External Table As Select

07 - Azure Synapse Analytics - Serverless Apache Spark pool

001 Apache Spark - Architecture

001 Spark-Architecture.pdf

001 useful-links.pdf

002 Create a Serverless Apache Spark Pool

003 Create and Run a Spark Notebooks

003 synapse-intro-notebook.zip

004 Scaling a Serverless Apache Spark Pool

005 Azure Synapse Analytics - Workspace Quotas

006 Working with Azure Data Lake Storage

007 Working with Azure Blob Storage

008 Working with Azure SQL

009 Practice - Configure your favorite IDE tool.html

08 - Azure Synapse Analytics - Dedicated SQL Pool

001 Dedicated SQL pool - Introduction

001 Dedicated-SQL-Pool-Uselful-Links.pdf

001 notebooks.zip

001 tpcds-onegb.zip

002 Synapse - Create a dedicated SQL pool

003 Load data - Copy Statement

004 Load data - CREATE TABLE AS SELECT (CTAS)

005 Star Schema - Architecture of a Data Warehouse

006 Hash-distributed table

007 Hash-distributed table - Choose the Distribution Column

008 Round-robin distributed table

009 Practice Create and Load Data into a Dedicated SQL Pool

010 Workload Management - How to managed query performance.html

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy