SQL Server Integration Services for Developers and DBAs
Move, transform, and clean data. Combine information from multiple systems. Need to populate data warehouses? No problems.
Enroll now for $295 USD !Course Summary
Learn to use SQL Server Integration Services effectively
- Do you need to move data between systems?
- Do you need to transform or clean the data?
- Do you need to integrate data from different systems?
- Are you assembling a data warehouse and need to populate it efficiently?
- Would you like to learn to build Integration Services packages properly, using professional standards?
- Have you built packages in the past but you aren’t sure if you are doing it properly?
- You want to learn from an expert
If any of these apply to you, this course is for you! And as well as detailed instruction, the course also offers optional practical exercises and quizzes to reinforce your learning.
Enroll now for $295 USD !
Modules and Lessons
Module 0: Getting started
Who is this course for?
Who is Greg?
What will I learn in this course?
Configuring your lab environment
Module 1: Overview of SSIS
What is SSIS?
Typical role for SSIS
Common sources of data
Common integration challenges
Tooling for building SSIS packages
SSIS project system
What are packages?
SSIS toolbox
SQL Server Management Studio
Lab 1a: Installing Integration Services Projects
Lab 1b: Overview of SSIS
Lab 1b: Walkthrough
Quiz 1: Overview of SSIS
Module 2: Working with control flow
What is control flow?
Precedence constraints
Task disable and execute
Naming annotating and grouping
Visual layout controls
Commonly used tasks
Other built-in tasks
Variables
Expressions
Parameters
Script task
Containers
Task breakpoints
Lab 2: Working with control flow
Lab 2: Walkthrough
Quiz 2: Working with control flow
Module 3: Working with data flow
What is the data flow?
Typical data flow
Built-in data sources
Setting component properties
Normal flow vs error flow
Built-in data destinations
Bit bucket destination
Built-in transformations
Multi-output transformations
Script component
Data type conversions
Data paths
Lab 3: Working with data flow
Lab 3: Walkthrough
Quiz 3: Working with data flow
Module 4: Configuration and deployment
Earlier version configuration
Project configuration
Property expressions
Default parameter values
SSIS catalog
Project deployment
Target versions
Environments
SSIS Catalog programmability
Deploying to Azure Data Factory
Lab 4: Configuration and deployment
Lab 4: Walkthrough
Quiz 4: Configuration and deployment
Module 5: Scheduling and security
Scheduling package execution
Monitoring and logging
Advanced package logging
Credentials and proxy accounts
Lab 5: Scheduling and security
Lab 5: Walkthrough
Quiz 5: Scheduling and security
Module 6: Advanced tasks and transforms
Data profiling task
Lookup transform
Cache transform
Fuzzy lookup and fuzzy grouping transforms
Bulk insert task
Pivot and unpivot transforms
Slowly-changing dimension wizard
Change data capture integration
Quiz 6: Advanced tasks and transforms
Module 7: Reliability and performance
Designing for reliability
Designing for restartability
Avoid built-in checkpoints
Blocking transformations
T-SQL vs SSIS
Avoiding index overhead
Overhead from constraints
Incremental data loads
Quiz 7: Reliability and performance
Module 8: Next steps
Summary and further steps
Enroll now for $295 USD !