Request a callback
Email us

Business Booking Details

Payment Of Invoices

For bookings from established businesses, we do not require payment at the point of booking.

We will send you an invoice which you can submit to your accounts payable system.

Purchase Orders

If your employer uses a purchase order (P.O.) system to manage supplier invoices that is no problem.

  • If you already have a P.O. number when booking add it to the PO number box on the booking form, and we will include it on your invoice.
  • If you need an invoice to generate a P.O. number in your accounts system, please book the course as normal and add a note in the PO number box – to be provided
  • We will send you an invoice (without a P.O.) which you can use to generate a P.O..
  • We will then re-issue your invoice with your P.O. included when you provide us with it

PAYMENT METHODS:

You are not able to pay directly online at the time of booking, we issue an invoice for all bookings.

We accept payment either via direct bank transfer or card

Our invoices contain our bank details if you would like to pay by bank transfer and there is also information on how to pay by card.

Please note, if you are using a business card there is a surcharge of 2% to cover the payment processing charges.

MS SQL Server Integration Services (“SSIS”) Course

MS SQL Server Integration Services (“SSIS”) Course

4.88
8 reviews
feefo award

Master Microsoft SQL Server Integration Services (‘SSIS’) with this 4-day course. Learn how to implement and use SSIS for data transfer and ETL (Extract, Transform and Load) operations.

This is a hands-on course. It includes lots of time to practise what you are being taught, try things out for yourself and ask questions.

By the time you finish, you’ll be comfortable working with all of SSIS’s main features.

✔ A complete SSIS course that covers all of this tool.
✔ Plenty of one to one attention and time to ask questions.
✔ Friendly expert trainers, small groups and a comfortable place to learn.
✔ All the materials and extras that you’ll ever need.
✔ Ongoing support and help with issues you have after the course.

What Will I Learn?

During this course you will learn all about:

  • Using the SQL Server Data Tools (“SSDT”) development environment to create SSIS projects and packages.
  • Working with Control Flow Tasks.
  • Designing Data Flows using a variety of transformations and data sources/destinations (including SQL Server databases, flat files, and Excel).
  • SSIS project and package management, deployment, debugging, error handling, and logging techniques.

Am I Ready For This Course?

This 4 day course is intended for IT professionals, business analysts, and developers who need to implement data transfer, or ETL (Extract, Transform, and Load), solutions using Microsoft SQL Server Integration Services (“SSIS”).

The Training Day

Our courses run from 9.30am to roughly 4.15pm with refreshments throughout the day and a break for lunch.

We offer a relaxed, supportive learning environment, fully air-conditioned training facilities and some of the nicest instructors on the planet.

Also, you’ll receive:

✔ A full-colour manual which covers everything in the course.
✔ Your course exercises so that you can practice at home.
✔ A Certificate of Attendance.

 

Course Details

Download full course details Download full course details
  • Overview of SSIS
  • Using the Import/Export Data Wizard
  • Using SSDT to Explore a Package
  • Exploring the SSDT Development Environment
  • Creating a New SSIS Project and Package in SSDT Connection Managers
  • Introduction to Control Flow Tasks
  • Precedence Constraints
  • File System Task
  • Script Task
  • Execute SQL Task
  • Execute Process Task
  • Expression Task
  • Send Mail Task
  • FTP Task
  • Execute Package Task
  • Using the Data Flow Task
  • Introduction to Data Flow Transforms and Components
  • Exploring Data Sources
  • Exploring Data Destinations
  • Data Conversion Transform
  • Derived Column Transform
  • Implementing Data Viewers
  • Aggregate Transform
  • Sort Transform
  • Lookup Transform
  • Row Count Transform
  • Union All Transform
  • The Script Component
  • Conditional Split Transform
  • OLE DB Command Transform
  • Fuzzy Lookup Transform
  • Fuzzy Grouping Transform
  • Implementing Variables and Expressions
  • Implementing Parameters
  • Sequence Container
  • Loop Container
  • Foreach Loop Container
  • Logging Package Execution
  • Using Event Handlers
  • Implementing Breakpoints
  • Create and Configure the SSIS Catalog Project Deployment
  • Configure Deployed Projects and Packages Securing SSIS Packages
  • Running Packages
  • Scheduling Package Execution
  • Master Packages Restarting Packages
  • Package Transactions & Checkpoints
  • Data Warehousing Basics
  • The Data Profiling Task
  • Loading Dimension Tables
  • Using the Slowly Changing Dimension Transform
  • Loading Fact Tables
  • Loading Data Incrementally
  • Using SSIS CDC Components
  • Introducing Data Quality Services (DQS)
  • Introducing Master Data Services (MDS)

Online Training Requirements

To attend this MS SQL Server course online, you will need:

✔ MS SQL Server Management Studio connected to a SQL database on your Windows PC/laptop with a camera, speakers & microphone
✔ A stable internet connection capable of running Zoom
✔ To be a confident computer user and able to use Zoom

If you have access to a second screen, we would encourage you to use it as it improves the experience.