DP-203 : Microsoft Certified Azure Data Engineer Associate

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

Pass Microsoft certified DP-203: Data Engineering on Microsoft Azure with 22+ Hours of HD video & 100+ Hands-on Labs

1. Introduction

1. Course Introduction

2. Basics of Data

1. Structured vs Unstructured vs Semi-Structured Data

2. Batch vs Streaming Data

3. OLTP vs OLAP

4. Data Lake vs Data Warehouse

5. Data Engineering Workflow

3. Azure Basic Services

1. Create Azure Account

2. Account, Subscription, Resources Groups & Resources

3. Different Ways to Access Azure

4. Azure Portal Walkthrough

5. Getting Ready with Azure CLI

6. Azure Cloud Shell

7. Create VM from Portal

8. Create VM From CLI

4. Azure Storage

1. Different Services for Azure Storage

2. Azure Storage Platform

3. Provision Azure Storage Account

4. Explore Azure Storage Account

5. What is Azure Blob Storage

6. Explore Azure Blob Storage Part 1

7. Explore Azure Blob Storage Part 2

8. Data Replication in Storage

9. Manual Failover

10. Blob Access Tier

11. Secure Storage Account

12. Azure Table

13. Azure Queue

14. Azure File Share

15. Azure Disk Storage

16. Introduction to Azure Data Lake Gen 2

17. Lifecycle Management

18. Azure Storage Explorer

5. Azure SQL Database

1. Introduction to Azure SQL Database

2. Azure SQL IaaS & PaaS Offering

3. Different Paas Deployment

4. [Hands-On] Azure SQL Database Part 1

5. [Hands-On] Azure SQL Database Part 2

6. [Hands-On] Azure SQL Database Part 3

7. [Hands-On] Azure SQL Database Part 4

8. SQL Pricing Model & Service Tier

6. Azure NoSQL Solution CosmosDB

1. Introduction to Azure Cosmos DB

2. APIs in Azure Cosmos DB

3. Azure Cosmos DB for NoSQL

4. Components of Azure Cosmos DB for NoSQL

7. Azure NoSQL Solution CosmosDB Part 2

1. Lab1 Creating Azure Cosmos DB Account for NoSQL Part 1

2. Lab1 Creating Azure Cosmos DB Account for NoSQL Part 2

3. Lab1 Creating Azure Cosmos DB Account for NoSQL Part 3

4. Overview Azure Cosmos DB Account for NoSQL

5. Lab 2 Creating a Database Part 1

6. Lab 2 Creating a Database Part 2

7. Lab 3 Creating a Container

8. Lab 4 Adding Items to Container

9. Request Units

10. Understand Throughput

11. Cost Management

12. Cosmos DB - Horizontally Scalable

13. Partition and Partition Key

14. Single vs Cross Partition

15. Avoid Hot Partitions

16. Time-to-Live (TTL)

17. Serverless Capacity Mode

18. Serverless vs Provisioned Throughput

19. Autoscale vs Standard Throughput

20. Azure CosmosDB Pricing

8. Azure Data Factory Getting Started

1. Introduction to Azure Data Factory

2. Create Data Factory Account

3. Azure Data Factory Studio Overview

4. Pipelines and Activities

5. Create Storage Account & Containers

6. Introduction to Linked Services & Dataset

7. Create Pipeline Copy Data Activity Part 1

8. Create Pipeline Copy Data Activity Part 2

9. Debug & Trigger Pipeline

10. Prefix , Wildcard, List of Files

11. Triggers Introduction

12. Schedule Trigger

13. Storage Event Trigger

14. Integration Runtime Introduction

15. Azure Integration Runtime

16. Self-Hosted Integration Runtime Part 1

17. Self-Hosted Integration Runtime Part 2

18. Sharing Self-hosted Integration Runtime

19. Pipeline Parameters and Variables Introduction

20. Parameterize Pipelines & Datasets

21. Parameterize Linked Services

22. System Variables

23. Connectors

24. Copy Data Activity General, Mapping

25. Copy Data Activity Settings and User Properties

26. Delete Activity

9. Azure Data Factory Control Flow Activities

1. Set Variable Activity

2. Append Variable Activity

3. Get Metadata Activity

4. Execute Pipeline Activity

5. Fail Activity

6. Wait Activity

7. For Each Activity

8. If Condition activity

9. Web & WebHook Activity

10. Switch Activity

11. Validation & Lookup Activity

12. Filter Activity

13. Until Activity

14. Set Pipeline Return Value Activity

10. Azure Synapse Analytics Getting Started

1. Introduction to Azure Synapse Analytics

2. Create Azure Synapse Analytics Workspace

3. Azure Synapse Studio Overview Part 1

4. Azure Synapse Studio Overview Part 2

5. Basic Concepts in Azure Synapse Analytics Part 1

6. Basic Concepts in Azure Synapse Analytics Part 2

7.1 employee.csv

7.2 nyctripsmall.zip

7.3 sql script 1.zip

7.4 sql script 2.zip

7.5 sql script 3.zip

7.6 sql script 4.zip

7.7 sql script 5.zip

7. Analyze Data with a Serverless SQL Pool Part 1

8. Analyze Data with a Serverless SQL Pool Part 2

9. Analyze Data with a Serverless SQL Pool Part 3

10. Analyze Data with a Serverless SQL Pool Part 4

11. Analyze Data with a Serverless SQL Pool Part 5

12.1 nyctripsmall.zip

12.2 sql script 1.zip

12.3 sql script 2.zip

12. Analyze Data with Dedicated SQL Pool Part 1

13. Analyze Data with Dedicated SQL Pool Part 2

14. Analyze Data with Dedicated SQL Pool Part 3

15. Analyze Data with Dedicated SQL Pool Part 4

16.1 notebook 1.zip

16.2 nyctripsmall.zip

16. Analyze data with Serverless Spark Pool Part 1

17. Analyze data with Serverless Spark Pool Part 2

18. Analyze data with Serverless Spark Pool Part 3

19.1 notebook 2.zip

19. Analyze Data in Storage Account

20.1 notebook 3.zip

20. Integrate with Pipelines Part 1

21. Integrate with Pipelines Part 2

22. Monitor Synapse Workspace Part 1

23. Monitor Synapse Workspace Part 2

24. Explore Synapse Knowledge Center

11. Thanks you & Way Forward

1. Way Forward

139,000 تومان

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

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

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

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