Loading Events

« All Events

  • This event has passed.

SSISE SQL Server Integration Services Essentials – Online

June 12 @ 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 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, among other things:

  • 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 consistency 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 TSQL
  • Ideally know how to connect to an instance of SQL Server 2012 using the various connection dialog boxes in Management Studio and development tools

Details

Date:
June 12
Time:
9:00 am - 5:00 pm UTC+11
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

Online

Tickets

The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Tickets are no longer available