This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Find out more here                     
decoration
decoration
decoration

From Zero to SSIS

5th March 2012 - 9th March 2012

Who is it for?

From Zero to SSIS is designed to train technology professionals in the fine art of using SQL Server Integration Services (SSIS) to build data integration and Extract-Transform-Load (ETL) solutions. The course is focused around labs and emphasizes a hands-on approach. 

The target audience for this training is database professionals, application developers, and business intelligence practitioners interested in acquiring or expanding their existing SSIS skill set. No experience with SQL Server or SQL Server Integration Services is required before attending this training. It is helpful (but not required) that students possess some knowledge of and experience with relational databases. SQL Server knowledge/experience will be more helpful than experience and knowledge with other technologies.

What you will learn

The course agenda is as follows:

DAY 1

Introduction - Training Overview, Expectations, and Introductions  

Lesson 1:  Creating Your First SSIS package -  Introduction to Business Intelligence Development Studio     

  • Visual Studio tips and tricks, menu contents and locations    
  • Exercise: Create an SSIS Project    

Lesson 2:  Introduction to the Data Flow Task     

  • Connection Manager and Data Flow Task basics: source and destination adapters    
  • Exercise: Straight to the Data Flow   

DAY 2 

Lesson 3: Data Flow Task 201 - Intermediate Data Flow Concepts     

  • Building re-executable data loaders    
  • Exercise: Create a Real Data Flow, Parts 1 and 2   

Lesson 4: Data Flow Task 202 - Advanced Data Flow Concepts     

  • Building and tuning robust incremental loader     
  • Exercise: Create a Real Data Flow, Parts 3 and 4

Lesson 5: Data Flow Task 301- Data Cleansing Basics.     

  • Building an incremental loader for real-world data    
  • Exercise: Data Cleansing, Part 1   

DAY 3

Lesson 6: The Control Flow - Containers, Precedence, and Workflow    

  • Transactions, restart-ability, and blocking    
  • Exercise: Sequence Containers   

Lesson 7: Loop Containers -  Using For Loop and For Each Loop Containers.     

  • Exercise: Loading Multiple Source Files  

Lesson 8: Data Flow Task 302 - Intermediate Data Cleansing. Managing real-world changes to data sources.    

  • Exercise: Data Cleansing, Part 2  

DAY 4

Lesson 9: Data Flow Task 303 - Advanced Data Cleansing     

  • Loading uneven flat file sources    
  • Exercise: Design Pattern: Loading Variable-Length File Sources.   

Lesson 10: Event Handlers, Logging, and Configurations  - Survey of SSIS Event Handlers Focusing on OnError and OnInformation Events     

  • Using SSIS’s built-in logging facility to capture package execution details and statistics, and built-in package configurations to externalize variable values     
  • Exercise: Trapping and Logging Errors, Part 1   

Lesson 11: Security, Deployment, and Execution - SSIS Package Deployment Options and Security Implications     

  • Execution options    
  • Exercise: Package Execution Options   

DAY 5

Lesson 12: ETL Design Patterns  - Leveraging Less-Documented Features of SSIS with the Parent-Child Design Pattern to Achieve “hands-free” Custom Logging and Creative Custom Configuration.     

  • ETL Instrumentation
  • Exercise: Trapping and Logging Errors, Part 2   

Lesson 13: Enterprise Execution Patterns - Leveraging the Parent-Child design pattern to build a metadata-driven SSIS execution engine.  

Lesson 14: SSIS Performance Demonstrations of common SSIS performance-killers and “SSIS deadlocks”. A methodology for troubleshooting SSIS performance.

 

Key benefits

This course will give you a comprehensive introduction to SQL Server Integration Services, not only in how it works but what the best practices for implementing it are. Experienced SSIS professionals who attend the advanced section will deepen their knowledge of SSIS, learning new design patterns and performance tuning tips and tricks.

Partial attendance

Attendees can choose to attend either the full five days, or just the introductory section (days 1-3) or just the advanced section (days 4-5). The cost is as follows:

  • To attend the full five days: £1248+VAT
  • To attend just the introductory section: £749+VAT
  • To attend just the advanced section: £499+VAT

A 10% discount will be applied to all group bookings of 4 or more people.

Cost: £1248 +VAT
decoration

Trainer

Andy Leonard is a consultant, trainer and author with decades of ETL experience and years of SQL Server Integration Services experience. He regularly provides advice and free instruction at his blog at SQLBlog.com and on Twitter (@AndyLeonard).

decoration

Location

LMG Training and Development
15 Risborough Street
Southwark
SE1 0HG
decoration

legal disclaimer

Cancellations must be submitted in writing, either via email or by post. Registrants whose cancellations are received at least 2 weeks before the beginning of the course are entitled to a full refund minus a £80 processing fee plus any credit card charges incurred. No refunds will be given to registrants who cancel less than 2 weeks before the beginning of the course or who fail to attend.

In the extraordinary case where the course is cancelled a full refund will be given to all paid registrants. Crossjoin Consulting will not refund any other amount paid by registrants to other companies, including travel expenses and hotel reservations.

decoration
decoration decoration decoration decoration
decoration
decoration