Zenler Player
Your course is loading. Hang tight.
SQL Server Integration Services for Developers and DBAs
Back to curriculum
0% Complete
0% Complete
Who is this course for?
Who is Greg?
What will I learn in this course?
Configuring your lab environment
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
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
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
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
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
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
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
Summary and further steps
Module 0: Getting started
Who is this course for?
Preview
Who is Greg?
Preview
What will I learn in this course?
Preview
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
×
This is an unpublished lesson. This lesson will not be shown for students unless you set it as Public.
Back to Dashboard
No contents are available in this lesson!
No lessons available !
Back to Dashboard
Lesson contents locked
Enroll to unlock this lesson.
Enroll to unlock
Next Lesson