Microsoft SQL Server Integration Services - Schulung in Hamburg

In this training, learn how to independently develop complex workflows with the Integration Services and use them in practice.

Description

< p>In this training, learn how to independently develop complex workflows with Microsoft Integration Services and use them in practice. After the training, you will master the connection of different data sources and the transformation of data according to your requirements.

Target group

Advanced users, Administrators, system builders

Duration

2 days

Content in detail

Introduction and Basics

• Basics of Microsoft SQL Server Integration Services ( SSIS)
• Introduction to the Visual Studio interface (SQL Server Data Tools)
• SSIS architecture and components

Introduction to ETL processes

• What is ETL?
• Importance of SSIS in ETL processes

Data sources and targets

• Setting up data connections (data sources and targets)
• Working with OLE DB, Flat files, Excel, etc.

Data flows and transformation

• Setting up file tasks
• Work with data flow tasks
• Data conversion, sorting, merging
• Lookup, aggregation and other transformations

Advanced Topics

• Sequence Containers
• Variables and Scopes
• Loops
• Executing SQL Statements

Working with SSIS packages

• Deployment and SQL Server Agent
< li>Job execution and logging
• Logging
• Event handler

ATVISIO consulting practice: "Best practice" and avoidable errors< /strong>

New: Book online training now

You will be contacted on the mutually agreed training days Your trainer and first mirrors his screen onto your computer - and vice versa if necessary. Ideally, you should have a second PC or laptop ready for your own exercises. Then the training can begin.

With online training you save time and travel costs and can use the hours gained productively for your day-to-day business.

For further information, call us.< /p>

Further information

For companies, this training can also be carried out as in-house training. Please contact Rebecca Schlesser about this - by email schlesser@atvisio.de or by phone 0631/4140140