Data Warehouse Design with Microsoft SQL Server and SSIS course

Data Warehouse Design with Microsoft SQL Server and SSIS

$280.00
8 hours
Beginner to Intermediate
Instructor Led Classroom Training

Course Overview

Our SQL Server Integration Services (SSIS) is an instructor-led classroom based training course that teaches attendees how to perform data integration and transformation by using SSIS. At the end of this course attendees will have a good understanding of SSIS concepts and creating SSIS packages.

Skills Required

This course is suitable for those who already have basic knowledge on Microsoft SQL Server database and table design, SQL, T-SQL and Stored Procedure. Our Database Design with Microsoft SQL Server Training Courses cover all of the prerequisites.

Booking Request

Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to:

book a course on different dates
book for a group of delegates
book corporate training
book a customised training
book a one-on-one training

The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below:

How many hours you want book?

Booking for how many people?

Here is the total cost of booking:

Price per person for this course:

Preferred Dates and Times

Any other information

You must need to Register / Sign In first to submit this booking request form.

Career Path

This is a possible career path after completing this course:
BI Developer / Data Warehouse Developer > Senior BI Developer / Integration Consultant

Introduction to SSIS
- SSIS Basics
- SSDT Introduction
- Connection Managers
- Basic SSIS Package
Control Flow
- Control Flow Basics
- Tasks
- Precedence Constraint
- Containers
Containers
- Four types of container
- Basic FOR loops
- Foreach loops
- Looping over files
- Looping over records
- Other foreach loops
Data Flow – I
- Data Flow Basics
- Data Sources - I
- Data Sources – II
- Excel, XML, Raw File
- Data Destinations
- OLEDB, Excel, Flat File
Data Flow – II
- Data Flow Transformation – Introduction
- Row Transformation
- Character Map, Copy Column
- Aggregate, Sort
- Split and Join Transformations
- Conditional Split, Multicast, Union All, Merge Join
Data viewers
- Attaching data viewers
- Using dead-end destinations

Younus Kazi

Younus has over 18 years experiences in working and teaching IT in both public and private organisations. His specialities include Web design, development, software development and project management. He graduated from London Metropolitan University in Computing and Information Systems. He is also a Microsoft Certified Application Developer (MCAD).

Related Courses

SQL Server Reporting Services (SSRS)

$280
SQL for Beginners

$280

Data Warehouse Design with Microsoft SQL Server and SSIS Training Course