This course is designed to help you understand all aspects of SQL Server Integration Services (SSIS), the ETL tool of choice for SQL Server users. We will use a variety of lab exercises and small projects to ensure you gain familiarity with how the design and execution of environments work, and prepare you to build your own real world applications using this SQL Server application. Students will learn real world uses for SSIS.
Director of Training
Devin Knight is our Training Lead, overseeing our workshops, boot camps, virtual training, webinars and corporate training programs. Devin is a Microsoft Most Valued Professional (MVP) and has authored numerous technical publications, including the books “Knight’s 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services”, “Knight’s Microsoft Business Intelligence 24-Hour Trainer” and “SharePoint 2010 Business Intelligence 24-Hour Trainer”. He has been selected as a speaker for conferences like PASS, SQLSaturdays and Code Camps for many years, and is the President of the SQL Server user group in Jacksonville, Florida (JSSUG).
What to Know Before the Class
This course assumes that you have no previous knowledge of SSIS. In some of the scripting modules, it is useful (but not mandatory) that attendees have some Visual Basic experience. You will need to know how to run a query inside of SQL Server.