Learn Azure data factory and AWS GLUE (ETL)

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

Master ETL in cloud with AWS glue & Azure data factory lab

1. Introduction

1. Introduction

2. Course Curriculum

2. DEMO PROJECT

1. AWS GLUE PROJECT

2.1 source.zip

2. ADF PROJECT

3. AWS GLUE

1. Introduction ETL

2. WHAT IS GLUE

3. GLUE BENEFITS

4. GLUE USE CASE

5. GLUE TERMINOLOGY

6. GLUE ARCHITECTURE

7. GLUE DEMO LAB

8. GLUE TRANSFORMATION LAB

9. GLUE TANSFORMATION LAB - MULTIPLE SOURCE

10. PROJECT -1 END TO END REAL TIME PROJECT (GLUE+S3+LAMBDA)

11. PROJECT -2 END TO END REAL TIME PROJECT PARTITIONING

4. AWS (ATHENA)

1. Athena Introduction

2. how athena works

3. who is athena for and prereqisite

4. difference between sql server and athena

5. LAB-1 athena create table by crawler

6. Lab -2 create table without crawler and directly from s3

7. Project -1 superstore data analysis by using athena

8. Project -2 Partitioning using athena

5. ADF (COPY & DELETE activities)

1. Introduction- s3 to azure blob data pipeline

2. Setup- s3 to azure blob data pipeline

3. setup lab - s3 to azure blob data pipeline

4. pipeline- s3 to azure blob data pipeline

5. Introduction - blob to blob (copy & delete)

6. Setup - blob to blob (copy & delete)

7. Setup Lab - blob to blob (copy & delete)

8. pipeline blob to blob (copy & delete)

6. ADF ( SQL TO BLOB)

1. Introduction

2. SETUP

3. SETUP LAB

4. DATA PIPELINE

5. SQL table specific columns transfer to azure blob

6. Data Pipeline

7. ADF (CSV file to SQL table data pipeline)

1. Introduction and business use case

2. project setup lab

3. project create data pipeline

8. ADF (TRANSFORMATION)

1. Introduction- 2 azure blob storage to output

2. SETUP- 2 azure blob storage to output

3. Data pipeline

4. Introduction - Union

5. create data pipeline

6. Alter & filter

7. create data pipeline

9. ADF (INCREMENTAL LOAD)

1. introduction and business use case

2. setup lab

3. create data pipeline

10. ADF (Parameterization )

1. introduction and business use case

2. setup theory

3. setup lab

4. create data pipeline

11. ADF( SCD TYPE-1 & SCD TYPE 2)

1. Introduction -SCD TYPE-1

2. SETUP -SCD TYPE-1

3. PIPELINE -SCD TYPE-1

4. Introduction -SCD TYPE-2

5. SETUP -SCD TYPE-2

6. PIPELINE -SCD TYPE-2

12. ADF (FAILURE)

1. INTRODUCTION

2. PIPELINE

13. SQL

1. Introduction

2. sql commands

3. create table

4. alter

5. filter

6. delete drop

7. group by & having

8. aggregate funcion

9. update delete

10. sorting

11. between & in

12. like

13. distinct

14. union vs union all

15. join in sql

16. case satement

17. view

18. store procedure -1

19. store procedure -2

20. constrain in sql

21. constrain lab

22. row number, rank ,dense rank

139,000 تومان

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

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

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

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