Implementing a SQL Data Warehouse Training from ICC Teleservices
Duration 40(Hrs)
Buy Now
COURSE OUTLINE
1 - INTRODUCTION TO DATA WAREHOUSING
- Gain an Introduction to Data Warehousing
- Consider Factors Involved in a Data Warehouse Solution
- Lab: Exploring a Data Warehouse Solution
2 - PLANNING DATA WAREHOUSE INFRASTRUCTURE
- Review Considerations for Building a Data Warehouse
- Plan Data Warehouse Hardware
- Lab: Planning Data Warehouse Infrastructure
3 - DESIGNING AND IMPLEMENTING A DATA WAREHOUSE
- Design Dimension Tables and Fact Tables
- Determine Physical Design for a Data Warehouse
- Lab: Implementing a Data Warehouse Schema
4 - COLUMNSTORE INDEXES
- Review Columnstore Indexes
- Create and Work with Columnstore Indexes
- Lab: Using Columnstore Indexes
5 - IMPLEMENTING AN AZURE SQL DATA WAREHOUSE
- Understand the Advantages of Azure SQL Data Warehouse
- Implement an Azure SQL Data Warehouse
- Develop an Azure SQL Data Warehouse
- Migrate to an Azure SQL Data Warehouse
- Copy Data with the Azure Data Factory
- Lab: Implementing an Azure SQL Data Warehouse
6 - CREATING AN ETL SOLUTION
- Gain an Introduction to ETL with SSIS
- Explore Source Data
- Implement Data Flow
- Lab: Implementing Data Flow in an SSIS Package
7 - IMPLEMENTING CONTROL FLOW IN AN SSIS PACKAGE
- Introduce Control Flow
- Create Dynamic Packages
- Adopt Containers
- Lab: Implementing Control Flow in an SSIS Package
- Lab: Using Transactions and Checkpoints
8 - DEBUGGING & TROUBLESHOOTING SSIS PACKAGES
- Debug an SSIS Package
- Log SSIS Package Events
- Handle Errors in an SSIS Package
- Lab: Debugging and Troubleshooting an SSIS Package
9 - IMPLEMENTING A DATA EXTRACTION SOLUTION
- Navigate Incremental ETL
- Extract and Load Modified Data
- Manage Temporal Tables
- Lab: Extracting Modified Data
- Lab: Loading Incremental Changes
10 - ENFORCING DATA QUALITY
- Apply Data Quality Services to Cleanse Data
- Use Data Quality Services to Match Data
- Lab: Cleansing Data
- Lab: De-Duplicating Data
11 - USING MASTER DATA SERVICES
- Become Familiar with Master Data Services
- Execute a Master Data Services Model
- Create a Master Data Hub
- Lab: Implementing Master Data Services
12 - EXTENDING SQL SERVER INTEGRATION SERVICES (SSIS)
- Utilize Custom Components in SSIS
- Perform Scripting in SSIS
- Lab: Using Scripts and Custom Components
13 - DEPLOYING AND CONFIGURING SSIS PACKAGES
- Review SSIS Deployment
- Deploy SSIS Projects
- Plan SSIS Package Execution
- Lab: Deploying and Configuring SSIS Packages
14 - CONSUMING DATA IN A DATA WAREHOUSE
- Understand Basic Concepts of Business Intelligence, Reporting and Data Analysis
- Analyze Data with Azure SQL Data Warehouse
- Lab: Using Business Intelligence Tools