Duration
Data Warehouse Developer-SQL Server/ETL/SSIS
2 days
What you'll learn
- Design a data warehouse
- Implement a data warehouse
- Create ETL Solution with SSIS
- Troubleshoot and Debug SSIS package
- Deploying SSIS Solution
- Enforce Data Quality
- Cleanse data
- Exploring Data Sources
- Extracting modified data
- Loading and modifying data
- Consuming data in Data Warehouse
Outline
SQL Server Setup
Introduction
- What is SQL Server
- SQL Server Download
- Install SQL Server
- Install SSMS
- Connecting SSMS to SQL Server
Visual Studio Setup
- What is Visual Studio
- Minimum Visual Studio Installation Requirements
- Installing SQL Data Tools with Visual Studio
- Download and install Visual Studio
- Install SQL Server Data Tools - SSDT
- Install SSDT Designer Templates
Designing a Data Warehouse
- What is data warehouse
- Database vs Data Warehouse
- Data Warehouse Vs Enterprise Data Warehouse
- Hardware requirements for Data Warehouse
- Enabling SQL Server Agent
- Configure Database Settings for Data Warehouse
- FTDW Sizing Tool
- Logical Design of Data Warehouse
- Physical Design of Data Warehouse
- Designing Dimension Tables
Creating an ETL Solution with SSIS
- What is ETL
- What is SSIS
- Introduction to ETL with SSIS
- Creating a new SSIS Project
- Exploring data source
- Introduction to control flow
- Implementing data flow
- Debugging SSIS Package
- Logging SSIS Package Events
- Handling errors in an SSIS Package
Implementing an Incremental ETL Process
- Introduction to incremental ETL Process
- Extracting modified data
- Loading modified data
- Working with changing dimensions
Deploying and Configuring SSIS
- Integration services catalogs
- Deploying SSIS Solutions
- Execute a package with SQL Server Agent
- Configuring advanced SSIS Settings
Enforcing Data Quality in Data Warehouse
- Installing Data Quality Services
- Cleansing data with data quality services
- Find duplicate data
- Using data quality services in SSIS data flow
Programme scope, delivery arrangements and suitability are confirmed during enquiry.