img
img

Data Warehouse Design with Microsoft SQL Server and SSIS Training Course

Data Warehouse Design with Microsoft SQL Server and SSIS

  • $280.00
  • 8 hours
  • Beginner to Intermediate
  • Instructor Led Classroom Training
  • Data Warehouse Design with Microsoft SQL Server and SSIS training course

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:

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

  1. Introduction to SSIS
    • SSIS Basics
    • SSDT Introduction
    • Connection Managers
    • Basic SSIS Package
  2. Control Flow
    • Control Flow Basics
    • Tasks
    • Precedence Constraint
    • Containers
  3. Containers
    • Four types of container
    • Basic FOR loops
    • Foreach loops
    • Looping over files
    • Looping over records
    • Other foreach loops
  4. Data Flow – I
    • Data Flow Basics
    • Data Sources - I
    • Data Sources – II
    • Excel, XML, Raw File
    • Data Destinations
    • OLEDB, Excel, Flat File
  5. 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
  6. Data viewers
    • Attaching data viewers
    • Using dead-end destinations
A photo of Younus

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).

Shares

Subscribe To Our Onlinesletter

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor

Copyright © 2022 LAIT.training. All rights reserved.