Everything you need to know
This 5 day course will give delegates a thorough study on using SQL Integration Services (SSIS). The course will teach delegates how to build simple as well as complex data integration solutions using Microsoft SQL Server Integration Services. The course covers all aspects of development, deployment and administration of SSIS packages. The course is based on SQL Server 2019. The course will teach delegates how to implement SQL Server Integration Services (SSIS) to export and import data between mixed data sources.
Delegates will learn how to carry out data cleansing tasks such as de-duplicating & fuzzy lookups. Further tasks covered include converging heterogeneous data sources through transformations such as merge and union. We will also look at splitting single data sources into transformations such as conditional split, handle multiple import files with containers such as for and foreach loops, and much more.
In this course you will learn about the Microsoft SQL Server Visual Studio development environment for design, creation and management of SSIS packages, and work with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling, and logging techniques.
Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of SQL Integration Services.
Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects
Recommended Prerequisites: Basic knowledge of Business Intelligence and relational database systems.
Course Schedule: 5 Days, 40 Academic Hours
Introduction to SQL Server Integration Services (SSIS)
Introduction to Control Flow
Introduction to Data Flow
Variables and Configurations
How to make SSIS Packages Dynamic
Trouble Shooting SSIS
SSIS Package Deployment
Wrap up and Review
Our international certified trainers have highly experienced Microsoft BI practitioners who have real-world expertise.
I – Laptops will be provided for all candidates with pre-installed Microsoft SQL Server Integration Services.
II – Our training venue is based in Lekki, Lagos (Specific venue will be emailed on confirmation of a place on the course).
For more information on our training, please enquire using the form above or call +2348103382376
Everything you need to know
Find out the next available dates
Book or Enquire
We’re here to discuss your needs with a free consultation and to offer guidance on the best route forward for you or your team. We’re proud of our expert data courses and consultancy services, and we’re always happy to talk about them.