SQL Server Integration Services

Asseco Academy » Training » SQL Server Integration Services

Training MS 55321AC

SQL Server Integration Services

Rozwiązania IT Microsoft Dane, Analityka, AI i ML Infrastruktura on-prem Dane, Analityka, AI i ML Administrowanie bazami danych

Accreditation

Training

Price of training from PLN 3,555 ^net

Lowest price in the last 30 days: PLN 3,555 ^net

Language: polish

*the price depends, among others on the form of training and the date

Download PDF

Additional products

No additional books or exams are specified for this training.

Czas trwania: 40h dydaktycznych

Opis szkolenia

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.

Audience Profile

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.

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.

At Course Completion

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

Zakres

Module 1: SSIS Overview
Module 2: Working with Solutions and Projects
Module 3: Basic Control Flow
Module 4: Common Tasks
Module 5: Data Flow Sources and Destinations
Module 6: Data Flow Transformations
Module 7: Making Packages Dynamic
Module 8: Containers
Module 9: Troubleshooting and Package Reliability
Module 10: Deploying to the SSIS Catalog
Module 11: Installing and Administering SSIS
Module 12: Securing the SSIS Catalog

Training schedule

Filters:

Date guarantee

location:

Training: MS 55321AC

SQL Server Integration Services

Currently, there is no trainings in the selected form.

Filters:

Date guarantee

location:

Training: MS 55321AC

SQL Server Integration Services

Currently, there is no trainings in the selected form.

Filters:

Date guarantee

form:

Training: MS 55321AC

SQL Server Integration Services

Currently, there is no trainings in the selected form.

Szukasz szkolenia w innym terminie?

Co nowego?

Newest
Uncategorized

Dołącz do Membership

Cykl online’owych spotkań, podczas których przybliżamy nowe kierunki rozwoju metod zarządzania usługami IT, jak również najciekawsze zagadnienia obszaru programowania, zarządzania Read more

Jak ugryźć innowacyjność

Cykl online’owych spotkań, podczas których przybliżamy nowe kierunki rozwoju metod zarządzania usługami IT, jak również najciekawsze zagadnienia obszaru programowania, zarządzania Read more

Nowoczesne metody supportu – testowy wpis

Cykl online’owych spotkań, podczas których przybliżamy nowe kierunki rozwoju metod zarządzania usługami IT, jak również najciekawsze zagadnienia obszaru programowania, zarządzania Read more

Chcesz z nami porozmawiać?

Zadzwoń do nas: tel. 801 30 30 30