Course duration
- 5 days
Course Benefits
- Learn to describe the key elements of a data warehousing solution.
- Learn to describe the main hardware considerations for building a data warehouse.
- Learn to implement a logical design for a data warehouse.
- Learn to implement a physical design for a data warehouse.
- Learn to create columnstore indexes.
- Learn to implementing an Azure SQL Data Warehouse.
- Learn to describe the key features of SSIS.
- Learn to implement a data flow by using SSIS.
- Learn to implement control flow by using tasks and precedence constraints.
- Learn to create dynamic packages that include variables and parameters.
- Learn to debug SSIS packages.
- Learn to describe the considerations for implement an ETL solution.
- Learn to implement Data Quality Services.
- Learn to implement a Master Data Services model.
- Learn to describe how you can use custom components to extend SSIS.
- Learn to deploy SSIS projects.
- Learn to describe BI and common BI scenarios .
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private classes are delivered for groups at your offices or a location of your choice.
Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).
Course Outline
- Introduction to Data Warehousing
- Overview of Data Warehousing
- Considerations for a Data Warehouse Solution
- Lab: Exploring a Data Warehouse Solution
- Planning Data Warehouse Infrastructure
- Considerations for Building a Data Warehouse
- Data Warehouse Reference Architectures and Appliances
- Lab: Planning Data Warehouse Infrastructure
- Designing and Implementing a Data Warehouse
- Logical Design for a Data Warehouse
- Physical Design for a Data Warehouse
- Lab: Implementing a Data Warehouse Schema
- Columnstore Indexes
- Introduction to Columnstore Indexes
- Creating Columnstore Indexes
- Working with Columnstore Indexes
- Lab: Using Columnstore Indexes
- Implementing an Azure SQL Data Warehouse
- Advantages of Azure SQL Data Warehouse
- Implementing an Azure SQL Data Warehouse
- Developing an Azure SQL Data Warehouse
- Migrating to an Azure SQ Data Warehouse
- Lab: Implementing an Azure SQL Data Warehouse
- Creating an ETL Solution
- Introduction to ETL with SSIS
- Exploring Source Data
- Implementing Data Flow
- Lab: Implementing Data Flow in an SSIS Package
- Implementing Control Flow in an SSIS Package
- Introduction to Control Flow
- Creating Dynamic Packages
- Using Containers
- Lab: Implementing Control Flow in an SSIS Package and Lab: Using Transactions and Checkpoints
- Debugging and Troubleshooting SSIS Packages
- Debugging an SSIS Package
- Logging SSIS Package Events
- Handling Errors in an SSIS Package
- Lab: Debugging and Troubleshooting an SSIS Package
- Implementing an Incremental ETL Process
- Introduction to Incremental ETL
- Extracting Modified Data
- Temporal Tables
- Lab: Extracting Modified DataLab: Loading Incremental Changes
- Enforcing Data Quality
- Introduction to Data Quality
- Using Data Quality Services to Cleanse Data
- Using Data Quality Services to Match Data
- Lab: Cleansing DataLab: De-duplicating Data
- Using Master Data Services
- Master Data Services Concepts
- Implementing a Master Data Services Model
- Managing Master Data
- Creating a Master Data Hub
- Lab: Implementing Master Data Services
- Extending SQL Server Integration Services (SSIS)
- Using Custom Components in SSIS
- Using Scripting in SSIS
- Lab: Using Scripts and Custom Components
- Deploying and Configuring SSIS Packages
- Overview of SSIS Deployment
- Deploying SSIS Projects
- Planning SSIS Package Execution
- Lab: Deploying and Configuring SSIS Packages
- Consuming Data in a Data Warehouse
- Introduction to Business Intelligence
- Introduction to Reporting
- An Introduction to Data Analysis
- Analyzing Data with Azure SQL Data Warehouse
- Lab: Using Business Intelligence Tools
Class Materials
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Experience in the following is required for this SQL Server class:
- At least 2 years’ experience of working with relational databases, including:.
- Designing a normalized database.
- Creating tables and relationships.
- Querying with Transact-SQL.
- Some exposure to basic programming constructs (such as looping and branching).
- An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
Instructor-led courses are offered via a live Web connection, at client sites throughout Europe, and at our Geneva Training Center.