Become a Data Warehouse Engineer – (DW,SQL,ETL/SSIS,Azure)

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

Practical Data Warehousing: Data Warehouse Design,Azure Synapse, ETL, Ingesting and Consuming Data in a Data Warehouse

1 - Introduction to Data Warehouse

1 - Introduction

2 - What is a Data Warehouse

3 - Database vs Data Warehouse

4 - Standard Data Warehouse Vs Enterprise Data Warehouse

5 - Pro and cons of an SQL Server Data Warehouse.html

6 - Data warehousing concepts.html

7 - Data Warehousing Architecture.html

8 - Data Warehousing Tools.html

9 - Data Warehouse best practices.html

2 - Microsoft SQL Server Setup

10 - What is SQL Server

11 - SQL Server Editions

12 - Please Read.html

13 - Microsoft SQL Server Installation Requirements.html

14 - Download SQL Server

15 - Install SQL Server

16 - Install SQL Server Management Studio SSMS

17 - Connect SSMS to SQL Server

18 - Note on Databases.html

19 - Restoring Sample Data Warehouse Database

3 - SQL Server Data Warehouse Configurations

20 - Hardware requirements for Data Warehouse.html

21 - Enable SQL Server Agent

22 - Configure Database Settings for Data Warehouse

4 - Data Warehouse Design

23 - Logical Data Warehouse Design

24 - Physical Data Warehouse Design Part 1

25 - Physical Data Warehouse Design Part 2

26 - Designing Dimension Tables

5 - Visual Studio Setup

27 - What is Visual Studio.html

28 - Visual Studio Installation Requirements.html

29 - Installing Visual Studio

30 - Download SQL Server Data Tools SSDT for Visual Studio.html

31 - Installing SQL Server Data Tools SSDT

32 - Install SSDT Extensions

6 - Creating an ETL Solutions with SSIS

33 - What is ETL.html

34 - What is SSIS.html

35 - Introduction to ETL with SSIS

36 - Creating a new SSIS Project.html

37 - Exploring data source Part 1.html

38 - Exploring data source Part 2

39 - Introduction to control flow Part 1

40 - Introduction to control flow Part 2

41 - Implementing data flow Part 1

42 - Implementing data flow Part 2

43 - Debugging SSIS Package Part 1

44 - Debugging SSIS Package Part 2

45 - Logging SSIS Package Events

46 - Handling errors in an SSIS Package

7 - Implementing Incremental ETL Process

47 - Introduction to incremental ETL Process

48 - Extracting modified data Part 1

49 - Extracting modified data Part 2

50 - Extracting modified data Part 3

51 - Extracting modified data Part 4

52 - Loading modified data Part 1

53 - Loading modified data Part 2

54 - Working with changing dimensions

8 - SSIS Configuration and Deployment

55 - Integration services catalogs

56 - Deploying SSIS Solutions

57 - Execute a package with SQL Server Agent

58 - Configuring advanced SSIS Settings

9 - Enforcing Data Quality in a Data Warehouse

59 - Enforcing Data Quality.html

60 - Installing Data Quality Services

61 - Cleansing data with data quality services

62 - Detecting duplicate data Part 1

63 - Detecting duplicate data Part 2

64 - Using Data Quality Services in SSIS Data Flow

10 - Consuming Data in a Data Warehouse

65 - Consuming Data.html

66 - Introduction to Business Intelligence

67 - Creating a new SSRS Project

68 - Using SSRS in Data Warehouse Part 1

69 - Using SSRS in Data Warehouse Part 2

70 - Creating a new SSAS Project

71 - Data Analysis with SSAS Part 1

72 - Data Analysis with SSAS Part 2

73 - Using Adhoc SQLTSQL Queries.html

11 - Azure Data Warehouse

74 - What is Azure

75 - Create a free Azure Subscription Account

76 - How to access Azure Services

77 - What is Azure Synapse Analytics

78 - When to use Azure Synapse Analytics.html

79 - Common types of analytical techniques.html

80 - What is a dedicated SQL Pool

81 - Provision a dedicated SQL Pool for data warehouse

82 - Provision Azure Synapse Analytics workspace

83 - Explore Synapse Studio

84 - Ingest data with a pipeline

85 - Use a Serverless SQL Pool to analyse data

86 - Visualizing data with Synapse Studio

139,000 تومان

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

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

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

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