X
ODT

Advanced SSIS
On-Demand Training

Starting At: $395.00
On-Demand Training
Call Us At: (904) 413-1911

Pragmatic Works On-Demand Training gives you the ability to learn from industry experts at your own pace. Our courses cover a variety of topics including Business Intelligence, Business Analytics, Big Data, SQL Server Optimization and more.

Unlimited Elite Pack
$995
Per User Per Year
Free Trial
3:13
3:13
2:00

Thanks for reporting a problem. We'll attach technical data about this session to help us figure out the issue. Which of these best describes the problem?

Any other details or context?

Cancel
message

Course Details

For the advanced ETL developer and the SSIS user looking to become more effective, our Advanced SSIS course teaches how to use SSIS in your enterprise to solve common extract, transform and load (ETL) challenges. Much of this course focuses on implementing common real-world SSIS patterns taught from the experts of SSIS. Be prepared for in-depth SSIS training with advanced discussion in many areas.

What Will You Learn?

  • Performance tuning for SSIS
  • How to extend SSIS using script tasks and components
  • SSIS integration with SSAS and DQS
  • Data warehouse loading patterns

Prerequisites


This class assumes you know the basics of SSIS and takes you from the novice level to a more effective, advanced ETL developer level. We recommend our Introduction to SSIS for those new to SSIS. Having an understanding of Visual Basic is helpful, but not required, for this course.

System Requirements


  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014 (Many features discussed are Enterprise/Developer edition only)
    • SQL Server Database Engine
    • SQL Server Integration Services

    • SQL Server Analysis Services (Optional)

    • SQL Server Data Tools (SQL 2012/2014) or Business Intelligence Development Studio (SQL 2008/2008R2)

    • SQL Server Management Studio

    • Data Quality Services (SQL 2012/2014 only)

    • Data Quality Client (SQL 2012/2014 only)

    • Follow this installation guide: (https://file.ac/CtasreVWQEA/Pragmatic%20SSIS%20Master%20Installation%20Guide.docx)

  • AdventureWorks2008R2 or AdventureWorks2012 databases installed on the instance

  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance

  • HigherEd and HigherEdDW databases should be restored on the instance. The HigherEd database backup files can be found in the class download in C:\SSISMaster\databases

Curriculum For This Course

Image

Brian Knight

CEO

Brian Knight is the owner and founder of Pragmatic Works and is a serial entrepreneur, starting up other companies throughout his prolific career. Brian is a contributing columnist at several technical magazines and also does regular webcasts. He is the author of more than 15 technical books.



Related Courses

Course Info
12 Comprehensive Modules
28 Effective Quizzes
Access on Mobile and TV
Certificate of Completion
Duration:
8h 30m
Download Syllabus
Enrollment Price:
$395/Year
Share this course with your friends