Auldhouse Anywhere

Auldhouse Anywhere

Our range of Auldhouse Anywhere courses enable you to join live classroom training online – saving you time and money on travel.

Find out More
E-Learning

E-Learning

Discover the benefits of taking a course online at your own pace.

Find out More
Webinars

Webinars

Auldhouse deliver a number of vendor specific webinars. Webinars give you an effective training option with the freedom to attend from virtually anywhere.

Find out More

SQL Server Integration Services

Code:
SSIS
Days:
3 Days
Price:
$2,100 excl GST
Code:
SSIS
Days:
3 Days
Price:
$2,100 excl GST
Overview:
This three day course has been created for SQL users, who would like to focus on creating packages for data extraction, transformation and loading (ETL) using integration services over a 3 day period.
Download Course Outline
Course Outline (PDF)

Objectives:

This course is designed to provide training on how to implement Extract, Transform and Load (ETL) using Microsoft SQL Server and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

After completing this course, participants will be able to:

  • Describe data warehouse concepts and architecture considerations
  • Implement Data Flow in an SSIS Package
  • Implement Control Flow in an SSIS Package
  • Debug and Troubleshoot SSIS packages
  • Implement an SSIS solution that supports incremental data warehouse loads and changing data
  • Implement data cleansing by using Microsoft Data Quality Services
  • Implement Master Data Services to enforce data integrity
  • Deploy and configure SSIS packages

Target Audience:

This course is intended for IT Professionals.

Prerequisites:

Before attending this course, student should have:

At least 2 years' experience of working with relational databases, including:

  • Designing a normalized database.
  • Creating tables and relationships.
  • Querying with Transact-SQL.
  • Some exposure to basic programming constructs (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable

 

Register now for this course

Please take special note of the course prerequisites as it is important that you meet these requirements before attending the course. If you have any questions about dates or locations please dont hesitate to make an enquiry contact us on 0800 835 835.

No classes currently scheduled in your location?Enquire about this course

Interested in a private class? Enquire about a private class