Course Outline

  • ETL and SSIS
  • Packages
  • Control Flow
  • Workflow
  • Constraints
  • Data Flows
  • Variables
  • Containers
  • Transactions
  • Errors and Debugging
  • Logging
  • Slowly Changing Dimensions
  • Deploying a Package
  • Security
  • Scripting
  • Best Practices

Requirements

Prior experience with SQL Server 2012
  28 Hours
 

Need help picking the right course?
Call us +971 4871 6715

Testimonials

I really was benefit from the exercises.

Fabrice Limbourg

The thorough / hands-on knowledge the trainer has.

Pieter Peirs

Related Courses

Administering in Microsoft SQL Server

  21 hours
The course is designed for administrators, developers and database developers. The objectives of the training: acquire and strengthen the skills to create and manage databases knowledge of the syntax and use SQL to retrieve and modify
Read More...

Microsoft SQL Server 2008/2012 (MSSQL)

  14 hours
This course has been created for delegates already acquainted with SQL in Microsoft SQL Server Environment 2008/2012. The course focuses on set-based querying and query tuning, working with indexes and analyzing execution plans. The training also
Read More...

Database Administration Fundamentals for MS SQL Server

  35 hours
After completing this course, students will be able to: Understand Core Database Concepts Create Database Objects Manipulate Data Understand Data Storage Administer a
Read More...

MS 20761 : Querying Data with Transact SQL

  35 hours
The SQL 2016 Querying course 20761 aims to impart skills on writing queries for Transact-SQL language. This SQL 2016 Querying certification training is the basic foundation for SQL Server-related disciplines such as Database Administration, Business
Read More...

MS SQL Server 2016

  14 hours
As a core of the Microsoft data platform, SQL Server is a leading operational database management system.
Read More...

Learning SQL with Microsoft SQL Server

  21 hours
Microsoft SQL Server is a relational database management system (RDBMS) for storing and retrieving data. In this instructor-led, live training (onsite or remote), participants will learn the essentials of the SQL language needed to query a
Read More...

Business Intelligence in MS SQL Server 2008

  14 hours
Training is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008. Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008. Gain knowledge of
Read More...

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

  14 hours
The aim of this course is to provide a clear understanding of the advanced use of (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL. For more in depth coverage of the topics this course can be run as a three day
Read More...

MS 20764C:Administering a SQL Database Infrastructure

  35 hours
Administering an SQL Database Infrastructure MOC 20764-C course imparts skills and knowledge to manage and maintain SQL Server databases while operating on a SQL database infrastructure. This Microsoft SQL Server 2016 Training is for individuals who
Read More...

T-SQL Fundamentals with SQL Server Training Course

  14 hours
This SQL training course is for people who want to acquire basic skills to deal with SQL Server Databases. Course will help the members to learn: How to work with SQL Server and SQL Server Management Studio. Meaning of Databases, SQL and
Read More...

SQL language in MSSQL

  14 hours
The course answers questions How to build a query? What opportunities have SQL? What is a relational database? What is the structure and SQL commands?
Read More...

SQL in SQL Server

  14 hours
This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn: how to write SQL queries what relational databases are and how we can
Read More...

Transact SQL Advanced

  7 hours
Delegates will gain an understanding of some of the more advanced features of Transact SQL as well as being able to do each of the following: Use queries to return complex result sets Manage database objects to aid query performance Tune
Read More...

Transact SQL Basic

  14 hours
Delegates will gain an understanding of the basic principles of Structured Query Language as well as being able to do each of the following: Construct queries to extract and filter data from an SQL Server database Create summarised
Read More...

Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012

  21 hours
This course is divided into 3 main sections and is made up of a mixture of presentations and practical exercises. VB.NET Language in Visual Studio 2012 VB.NET Object Orientation VB.NET and Sql Server
Read More...