SQL Server Integration Services (SSIS)

Join our instructor-led virtual classroom-based training course on SQL Server Integration Services (SSIS), where participants will gain comprehensive knowledge and practical skills in data integration and transformation utilizing SSIS. Throughout this immersive program, attendees will delve into SSIS concepts, learning how to design and execute SSIS packages effectively.

By the conclusion of the course, participants can expect to have acquired a solid understanding of SSIS principles and the ability to proficiently create SSIS packages. Through interactive sessions and hands-on exercises, learners will be equipped with the expertise needed to navigate data integration challenges and optimize workflows using SSIS. Join us and embark on a transformative learning journey that will empower you to excel in data integration with SSIS.

This course is designed for individuals with a foundational understanding of Microsoft SQL Server database and table design, as well as proficiency in SQL, T-SQL, and Stored Procedures.

1: Setting Up a SQL Server Environment

• Setting up Databases
• IF an object EXISTS

2: Multi-Table Queries

• Joining Tables
• INNER JOIN
• INNER JOIN with more than two Tables
• OUTER JOIN
• CROSS JOIN
• SELF JOIN

3: Aggregate Functions and Group by

• Using Aggregate Functions
• Using GROUP BY Clause
• Using HAVING Clause
• Aggregate Queries with Multiple Tables

4: Temporary Tables and Table Variables

• Using temporary tables
• Creating table variables

5: Common Table Expressions (CTE)

• Introduction to CTE
• Using CTE
• Multiple CTE in a single query

6: Logical Functions

• Using IIF Function
• Using CASE
• Using CASE WHEN

7: Local & Global variables

• Introduction to variables
• Variable data types
• Local variables
• Using Global variables

8: Control of Flow

• IF…ELSE
• BEGIN…END

9: User-Defined Functions – UDFs

• Introduction to UDFs
• Creating a Scalar-Valued Function

10: Stored Procedures

• Introduction to Stored Procedures
• Creating User Stored Procedures
• Stored Procedure with Parameters

Our aim is not just to get you the qualification but also guide you through all processes while you are applying for your SIA Licence. Following are some of the reasons why you should choose us as your training provider:

• Excellent Success Rate!
• Fully accredited and authorized training center in London!
• Most competitive prices with NO HIDDEN COSTS!
• Prices are all inclusive of tuition, handbook, notebook, exams and certificate costs!
• Nationally recognized and Ofqual accredited training course!
• Highly skilled and qualified trainers with a great wealth of practical knowledge & experience!
• Post-qualification email support while you are preparing to book your licence application!
• Free guidance session on how to apply and obtain a SIA Licence!