Description

Duration

5 Days

30 CPD hours

This course is intended for

The primary audience for this course is database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.

Overview

Create sophisticated SSIS packages for extracting, transforming, and loading data Use containers to efficiently control repetitive tasks and transactions Configure packages to dynamically adapt to environment changes Use Data Quality Services to cleanse data Successfully troubleshoot packages Create and Manage the SSIS Catalog Deploy, configure, and schedule packages Secure the SSIS Catalog

SQL Server Integration Services is the Community Courseware version of 20767CC Implementing a SQL Data Warehouse. This five-day instructor-led course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server. This course is similar to the retired Course 20767-C: Implementing a SQL Data Warehouse but focuses more on building packages, rather than the entire data warehouse design and implementation.

Prerequisites

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.

1 - SSIS Overview

Import/Export Wizard

Exporting Data with the Wizard

Common Import Concerns

Quality Checking Imported/Exported Data

2 - Working with Solutions and Projects

Working with SQL Server Data Tools

Understanding Solutions and Projects

Working with the Visual Studio Interface

3 - Basic Control Flow

Working with Tasks

Understanding Precedence Constraints

Annotating Packages

Grouping Tasks

Package and Task Properties

Connection Managers

Favorite Tasks

4 - Common Tasks

Analysis Services Processing

Data Profiling Task

Execute Package Task

Execute Process Task

Expression Task

File System Task

FTP Task

Hadoop Task

Script Task Introduction

Send Mail Task

Web Service Task

XML Task

5 - Data Flow Sources and Destinations

The Data Flow Task

The Data Flow SSIS Toolbox

Working with Data Sources

SSIS Data Sources

Working with Data Destinations

SSIS Data Destinations

6 - Data Flow Transformations

Transformations

Configuring Transformations

7 - Making Packages Dynamic

Features for Making Packages Dynamic

Package Parameters

Project Parameters

Variables

SQL Parameters

Expressions in Tasks

Expressions in Connection Managers

After Deployment

How It All Fits Together

8 - Containers

Sequence Containers

For Loop Containers

Foreach Loop Containers

9 - Troubleshooting and Package Reliability

Understanding MaximumErrorCount

Breakpoints

Redirecting Error Rows

Logging

Event Handlers

Using Checkpoints

Transactions

10 - Deploying to the SSIS Catalog

The SSIS Catalog

Deploying Projects

Working with Environments

Executing Packages in SSMS

Executing Packages from the Command Line

Deployment Model Differences

11 - Installing and Administering SSIS

Installing SSIS

Upgrading SSIS

Managing the SSIS Catalog

Viewing Built-in SSIS Reports

Managing SSIS Logging and Operation Histories

Automating Package Execution

12 - Securing the SSIS Catalog

Principals

Securables

Grantable Permissions

Granting Permissions

Configuring Proxy Accounts

Additional course details:

Nexus Humans 55321 SQL Server Integration Services training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward.

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the 55321 SQL Server Integration Services course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Course Images

55321 SQL Server Integration Services

By Nexus Human

Booking options

Highlights

Description

Dates

About The Provider

Tags

Reviews