Loading Events

« All Events

SSISE SQL Server Integration Services Essentials – Melbourne

December 2 @ 9:00 am - 5:00 pm UTC+11

$675.00
SQL Server Integration Services Essentials

This one-day hands-on, instructor led course guides you through the numerous features of SQL Server Integration Services (SSIS) using real-world exercises structured around the components provided by the SQL Server Data Tools development environment.  You will learn a practical approach to solving real-world problems using SSIS, which will provide you the ability to collect enterprise data from various sources such as SQL Server OLTP databases, Access databases, Excel worksheets and more, and transform the data for OLAP analysis, mining, and reporting.

Overview

This one-day hands-on, instructor led course guides you through the numerous features of SQL Server Integration Services (SSIS) using real-world exercises structured around the components provided by the SQL Server Data Tools development environment.  You will learn a practical approach to solving real-world problems using SSIS, which will provide you the ability to collect enterprise data from various sources such as SQL Server OLTP databases, Access databases, Excel worksheets and more, and transform the data for OLAP analysis, mining, and reporting.

Download Course Outline   View Schedule/Book Online

Who Should Attend

This course is designed for anyone who wants to use SQL Server Integration Services (SSIS) to develop extract, transform and load (ETL) solutions. This includes developers and database administrators, business analysts and anyone that designs and builds ETL solutions

Course Objectives

After completing this course, participants will be able to:

  • Describe key features of SSIS
  • Explore source data for an ETL solution
  • Implement a data flow by using SSIS
  • Implement control flow with tasks and precedence constraints
  • Create dynamic packages that include variables and parameters
  • Use containers in a package control flow
  • Enforce consistencey with transactions and checkpoints
  • Describe considerations for SSIS deployment
  • Deploy SSIS projects
  • Plan SSIS package execution

Course Prerequisites

Before attending this course, participants should have:

  • An understanding of SQL Server 2012
  • Experience in creating, retrieving, updating and deleting queries using T-SQL
  • Ideally know how to connect to an instance of SQL Server using the various connection dialog boxes in Management Studio and development tools

Details

Date:
December 2
Time:
9:00 am - 5:00 pm
Cost:
$675.00
Event Categories:
, ,

Organizer

WARDY IT Solutions Training
Phone:
1300 WARDY IT (927 394)
Email:
training@wardyit.com
Website:
https://www.wardyit.com/training/

Venue

WARDY IT Solutions Melbourne
Level 23, HWT Tower, 40 City Road
Southbank Melbourne, Victoria 3006 Australia

Tickets

8 available
SQL Server Integration Services Essentials$675.00 + GSTThis one-day hands-on, instructor led course guides you through the numerous features of SQL Server Integration Services (SSIS) using real-world exercises structured around the components provided by the SQL Server Data Tools development environment.