SQL Server Integration Services Core Skills (2 days)


SQL Server Integration Services is Microsoft's primary tool for ETL (Extract-Transform-Load) processing. This course is designed to take you through the most important aspects of SSIS, with just the right amount of depth, within two days.

The course is most suitable for developers that need to learn to work with the Microsoft BI platform or for existing SQL Server developers and DBAs that want to cross-train into BI work. The course can also help business analysts and project managers that need a solid understanding of the technologies involved. While not essential to complete the labs (as full detailed instructions are provided), some knowledge of T-SQL would be helpful.

The course looks at what's involved in creating a data model that is suitable for analysis and reporting. During the first day, you'll gain confidence in using the tooling provided by SQL Server Integration Services for ETL (Extract-Transform-Load) processing. In the second day, you'll learn about how to use these tools to load a dimensional model and how to optimise the performance of your ETL processing.

While our courses are based on SQL Server 2017, we realise that many customers are not yet running that version. Rather than provide you a course that only covers a single version of SQL Server, our courses are designed to be relevant (wherever possible) to a range of SQL Server versions including SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 and SQL Server 2016. Where there are differences between versions, the differences are clearly highlighted.

 CITY DATES COURSE PRICE EARLY BIRD PRICE
On-demand Please contact us


DAY 1 IS201 OVERVIEW OF SQL SERVER INTEGRATION SERVICES
Integration Services Features Overview
Working with SQL Server BI Tooling
Creating SSIS Projects and Packages
LAB: Creating SSIS Projects and Packages
DAY 1 IS202 WORKING WITH SSIS CONTROL FLOW
Introduction to Control Flow Tasks and Precedence Constraints
Working with Containers
Passing Information Between Tasks with Variables and Expressions
LAB: Working with SSIS Control Flow
DAY 1 IS203 WORKING WITH SSIS DATA FLOW
Introduction to Data Flow Data Sources, Destinations and Assistants
Transforming Data
Debugging Using Data Viewers and Breakpoints
LAB: Working with SSIS Data Flow
DAY 1 IS204 SSIS CONFIGURATION, DEPLOYMENT, SCHEDULING AND LOGGING
Project and Package Configurations
Deploying Projects or Packages
Scheduling Package Execution
Logging Package Activity
LAB: SSIS Configurations, Deployment, Scheduling and Logging
DAY 2 IS301 SSIS CASE STUDY: DIMENSIONAL MODELLING CORE CONCEPTS
Why Implement Dimensional Models?
Fact Table Core Concepts
Dimension Table Core Concepts
Profiling Incoming Data
LAB: Dimensional Modelling Core Concepts
DAY 2 IS302 LOADING DIMENSION TABLES
Issues with Loading Dimension Tables
Implementing Slowly-Changing Dimensions
Implementing Inferred Members
Useful Additional Transformations
LAB: Loading Dimension Tables
DAY 2 IS303 LOADING FACT TABLES
Issues with Loading Fact Tables
Working with Granularity and Calculations
Useful Additional Transformations
LAB: Loading Fact Tables
DAY 2 IS304 DESIGNING FOR RELIABILITY AND PERFORMANCE
Designing for Reliability
Improving SSIS Package Performance
Incremental Data Loads
LAB: Designing for Reliability and Performance