Microsoft Data & Power BI
SQL Server Integration Services (SSIS) 55321
Build ETL solutions with SQL Server Integration Services.
5 daysIntermediate11 modules
About this course
Build ETL solutions with SQL Server Integration Services. Over five days you will create packages, control flow and data flow, use sources, destinations and transformations, handle errors, use variables and deploy and run packages.
What you'll learn
- Create sophisticated SSIS packages for extracting, transformation, and loading data
- Use containers to control repetitive tasks and transactions efficiently
- Configure packages to dynamically adapt to environment changes
- Cleanse data using Data Quality Services for business intelligence accuracy
- Troubleshoot and debug packages for reliable package execution
- Create, manage, and secure the SSIS Catalog
- Deploy, configure, and schedule packages for automated execution
Curriculum
11 modules
- Import/Export Wizard and Exporting Data
- Common Import Concerns and Quality Checking Data
- SQL Server Data Tools Overview
- Understanding Solutions, Projects, and Visual Studio Interface
- Working with Tasks, Precedence Constraints, and Connection Managers
- Annotating, Grouping, and Managing Package/Task Properties
- Favorite Tasks for Common Scenarios
- Analysis Services Processing and Data Profiling
- Execute Package/Process Tasks and Expression Tasks
- File System, FTP, and Hadoop Tasks
- Script Task Basics, Send Mail, Web Service, and XML Tasks
- Data Flow Task and SSIS Toolbox Overview
- Working with Data Sources and Destinations (Databases, Flat Files, Excel)
- Configuring Transformations to cleanse and shape data
- Parameters (Package, Project, SQL) and Variables
- Using Expressions in Tasks and Connection Managers
- Post-Deployment Dynamic Configurations
- Sequence Containers, For Loops, and Foreach Loops
- Error Handling: Redirecting Rows, Logging, Event Handlers
- Using Breakpoints, Checkpoints, and Transactions
- Managing MaximumErrorCount for Stability
- Understanding the SSIS Catalog and Deployment Models
- Deploying Projects, Managing Environments, and Executing Packages (SSMS, Command Line)
- Installing and Upgrading SSIS
- Managing the Catalog, Built-in Reports, Logging, and Operation Histories
- Automating Package Execution
- Principals, Securables, and Permissions Management
- Granting Permissions and Configuring Proxy Accounts
Who it's for
Database and BI developers who build data integration solutions.
Before you start
- Working knowledge of T-SQL and SQL Server Agent jobs is helpful, but not required.
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of relational databases.
- Some experience with database design.
Related courses
More in Microsoft Data & Power BI →IntermediateAZ-500T00
Microsoft Azure Security Technologies (AZ-500T00)
Microsoft Azure
View course →IntermediateSC-200
SC-200: Defend Against Cyberthreats with Microsoft's Security Operations Platform
Microsoft Security
View course →IntermediateSC-300T00
SC-300T00 Microsoft Identity and Access Administrator
Microsoft Security
View course →Intermediate
55128 Writing Reports with Report Builder and SSRS Level 2
Microsoft Data & Power BI
View course →Intermediate
55232 Writing Analytical Queries for Business Intelligence
Microsoft Data & Power BI
View course →Foundation
55315 Introduction to SQL Databases
Microsoft Data & Power BI
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.