Loading Events

« All Events

  • This event has passed.

SSISE SQL Server Integration Services Essentials – Brisbane

October 10 @ 9:00 am - 5:00 pm UTC+11

$675.00
SQL Server Integration Services Essentials

This course is not currently scheduled. Please get in touch to book.
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.

This course is not currently scheduled. Please get in touch to book.

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   Contact Us

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:
October 10
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 Brisbane
Level 1, 164 Wharf Street
Spring Hill Brisbane, Queensland 4000 Australia
Phone:
1300 927 394

Tickets

Tickets are not available as this event has passed.