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

Created by: 247 Learning
An investment in knowledge pays the best interest

What Will I 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

Requirements

• Basic knowledge of Database Concepts advised
• Required Software will be covered in the course.

Target audience

• Beginner Data Warehouse Engineers
• Beginner Data Warehouse Developers
• Beginner Data Analyst
• Beginner Data Engineers
• Beginner Data Science