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

Focused View

247 Learning

7:03:40

107 View

1 - Introduction to Data Warehouse

1 - Introduction.mp4

00:20

2 - What is a Data Warehouse.mp4

03:06

3 - Database vs Data Warehouse.mp4

03:15

4 - Standard Data Warehouse Vs Enterprise Data Warehouse.mp4

01:54

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.mp4

02:57

11 - SQL Server Editions.mp4

04:45

12 - Please Read.html

13 - Microsoft SQL Server Installation Requirements.html

14 - Download SQL Server.mp4

04:31

15 - Install SQL Server.mp4

09:43

16 - Install SQL Server Management Studio SSMS.mp4

05:48

17 - Connect SSMS to SQL Server.mp4

02:16

18 - Note on Databases.html

19 - Restoring Sample Data Warehouse Database.mp4

05:49

3 - SQL Server Data Warehouse Configurations

20 - Hardware requirements for Data Warehouse.html

21 - Enable SQL Server Agent.mp4

02:33

22 - Configure Database Settings for Data Warehouse.mp4

06:38

4 - Data Warehouse Design

23 - Logical Data Warehouse Design.mp4

04:14

24 - Physical Data Warehouse Design Part 1.mp4

09:55

25 - Physical Data Warehouse Design Part 2.mp4

11:42

26 - Designing Dimension Tables.mp4

10:14

5 - Visual Studio Setup

27 - What is Visual Studio.html

28 - Visual Studio Installation Requirements.html

29 - Installing Visual Studio.mp4

08:15

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

31 - Installing SQL Server Data Tools SSDT.mp4

04:09

32 - Install SSDT Extensions.mp4

06:21

6 - Creating an ETL Solutions with SSIS

33 - What is ETL.html

34 - What is SSIS.html

35 - Introduction to ETL with SSIS.mp4

02:41

36 - Creating a new SSIS Project.html

37 - Exploring data source Part 1.html

38 - Exploring data source Part 2.mp4

04:36

39 - Introduction to control flow Part 1.mp4

09:55

40 - Introduction to control flow Part 2.mp4

08:21

41 - Implementing data flow Part 1.mp4

09:44

42 - Implementing data flow Part 2.mp4

09:32

43 - Debugging SSIS Package Part 1.mp4

07:20

44 - Debugging SSIS Package Part 2.mp4

06:53

45 - Logging SSIS Package Events.mp4

10:18

46 - Handling errors in an SSIS Package.mp4

08:00

7 - Implementing Incremental ETL Process

47 - Introduction to incremental ETL Process.mp4

05:36

48 - Extracting modified data Part 1.mp4

04:53

49 - Extracting modified data Part 2.mp4

07:47

50 - Extracting modified data Part 3.mp4

05:28

51 - Extracting modified data Part 4.mp4

07:19

52 - Loading modified data Part 1.mp4

07:31

53 - Loading modified data Part 2.mp4

07:25

54 - Working with changing dimensions.mp4

07:38

8 - SSIS Configuration and Deployment

55 - Integration services catalogs.mp4

08:19

56 - Deploying SSIS Solutions.mp4

11:52

57 - Execute a package with SQL Server Agent.mp4

10:58

58 - Configuring advanced SSIS Settings.mp4

05:19

9 - Enforcing Data Quality in a Data Warehouse

59 - Enforcing Data Quality.html

60 - Installing Data Quality Services.mp4

12:05

61 - Cleansing data with data quality services.mp4

11:27

62 - Detecting duplicate data Part 1.mp4

11:11

63 - Detecting duplicate data Part 2.mp4

09:07

64 - Using Data Quality Services in SSIS Data Flow.mp4

09:34

10 - Consuming Data in a Data Warehouse

65 - Consuming Data.html

66 - Introduction to Business Intelligence.mp4

04:15

67 - Creating a new SSRS Project.mp4

01:56

68 - Using SSRS in Data Warehouse Part 1.mp4

08:12

69 - Using SSRS in Data Warehouse Part 2.mp4

07:00

70 - Creating a new SSAS Project.mp4

01:36

71 - Data Analysis with SSAS Part 1.mp4

09:27

72 - Data Analysis with SSAS Part 2.mp4

05:13

73 - Using Adhoc SQLTSQL Queries.html

11 - Azure Data Warehouse

74 - What is Azure.mp4

03:15

75 - Create a free Azure Subscription Account.mp4

05:43

76 - How to access Azure Services.mp4

01:45

77 - What is Azure Synapse Analytics.mp4

02:51

78 - When to use Azure Synapse Analytics.html

79 - Common types of analytical techniques.html

80 - What is a dedicated SQL Pool.mp4

01:48

81 - Provision a dedicated SQL Pool for data warehouse.mp4

09:35

82 - Provision Azure Synapse Analytics workspace.mp4

06:07

83 - Explore Synapse Studio.mp4

06:33

84 - Ingest data with a pipeline.mp4

09:34

85 - Use a Serverless SQL Pool to analyse data.mp4

07:20

86 - Visualizing data with Synapse Studio.mp4

02:16

Description

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

What You'll Learn?

Provision a dedicated SQL Pool for data warehouse
Provision Azure Synapse Analytics workspace
Ingest data with a pipeline
Use a Serverless SQL Pool to analyse data
Visualize data with Synapse Studio
Data Warehouse Design
Configure Database Settings for Data Warehouse
Designing Dimension Tables
Create an ETL Solutions with SSIS
Implement data flow
Debug SSIS Package
Implement Incremental ETL Process
SSIS Configuration and Deployment
Enforce Data Quality in a Data Warehouse
Consume Data in a Data Warehouse

Who is this for?

Beginner Data Warehouse Engineers

Beginner Data Warehouse Developers

Beginner Data Analyst

Beginner Data Engineers

Beginner Data Science

What You Need to Know?

Basic knowledge of Database Concepts advised

Required Software will be covered in the course.

More details

Description
ThisÂ course isÂ designed to equip you with an understanding of Data Warehousing concepts and practices, SQL programming, ETL processes using SQL Server Integration Services (SSIS), and Azure Synapse Analytics. This course aims to provide you with both theoretical knowledge and practical skills to become a proficient Data Warehouse Engineer.
As a part of this course, you will learn how to provision a dedicated SQL Pool for data warehouse use, critical for managing and running large scale analytical processing. You will also get hands-on experience in provisioning Azure Synapse Analytics workspace, Microsoft's integrated analytics service that accelerates your time to insight across data warehouses and big data systems.
The course will guide you through designing and building data ingestion systems using a pipeline. You will acquire practical skills on using a Serverless SQL Pool to analyze data, providing you the ability to query data on-demand with no infrastructure setup.
You will learn to effectively structure your data warehouse for optimal data retrieval and analysis. This includes learning how to configure database settings for a data warehouse and designing dimension tables - crucial aspects of building a functional, efficient data warehouse.
You will also dive deep into creating robust ETL solutions with SSIS, allowing you to manage and automate your data transformation processes. This includes learning to implement data flows, debug SSIS packages, and understand how to implement an incremental ETL process, keeping your data warehouse up-to-date without overloading your systems.
The course covers SSIS configuration and deployment, enabling you to effectively manage your ETL solutions in different environments. Ensuring data quality is a crucial aspect of any data warehouse system. You will learn strategies to enforce data quality in a data warehouse, ensuring reliable and accurate insights from your data.
Lastly, the course will also train you on how to consume data in a data warehouse. This involves not just extracting data, but also transforming it into useful insights and visualizations, which you will learn to create using Synapse Studio.
By the end of this course, you will have a solid foundation in data warehouse engineering, and be ready to take on roles in this exciting and growing field.

Who this course is for:
Beginner Data Warehouse Engineers
Beginner Data Warehouse Developers
Beginner Data Analyst
Beginner Data Engineers
Beginner Data Science

User Reviews

Rating

average 0

Total votes0

Focused display

Hello and welcome to 247 Learning.We create online courses that will help you acquire useful and productive technical skills that can be applied to real world jobs. We have over 18,000 students on Udemy that have signed up to our courses . We are continuously adding more courses to our course catalogues. We are looking forward to welcoming you to one or more of our courses.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.