This 2 days advanced course designed for you to learn how to implement ETL common but still challenging scenarios with SSIS in an efficient and high performance best practice approach. At the end of this course you will learn best SSIS ETL approaches to implement SCD, Inferred Dimension Member, Incremental Load and etc.
This is not a regular Microsoft Certification training. You will learn SSIS best practices to implement ETL solutions through this course by doing the work, and you will learn pragmatic approaches. You will be able to go to your work straight after this course and create complex real-world ETL solutions with SSIS.
Instructor
Reza Rad worked with SSIS from the first day that it born in 2005 and even before that with DTS in SQL Server 2000. Reza is author of the book Microsoft SQL Server 2012 Integration Services; An Expert Cookbook. Reza is also author of SSIS tutorial videos on Channel9. Reza is an international speaker in conferences such as PASS Summit, SQL Rally, Business Analytics, TechEds, and many other conferences and SQL Saturdays. Reza has 10 years’ experience in SSIS training to clients all around the world.
Agenda
- Overview of SSIS Tasks and Components
- Incremental Load Approaches and Best Practices
- Best practices of Implementing Slowly Changing Dimension
- Dealing with Inferred Dimension Members
- Integrating SSIS with MDS, Challenges and Solutions
- Transactions and Rollback Scenarios
- Data Reconciliation
- SSIS Catalog, and advanced Logging
- SSIS ETL Execution Framework
- Dealing with Bad Data Rows
- SSIS and Data Flow Performance Tuning
Online Course
This course has an online version named: ETL Design Patterns with SSIS. Course split in five consecutive days; 2 hours in each day. Agenda:
- Slowly Changing Dimension
- Inferred Dimension Member
- Incremental Load
- Rollback
- Logging and Troubleshooting
- SSIS Catalog
- Performance Tuning
- SSIS 2016 new features
- Temporal Tables in SQL Server 2016
Prerequisite
You need to be fully familiar with SSIS to start this course. If you are not, register Learning Pragmatic SQL Server Integration Services (SSIS) 3 days course first.
Schedule of This Course
Check our course schedule here
Frequently Asked Questions
Q: What I would get as part of this training?
A: You will get a hard copy of Microsoft SQL Server 2012 Integration Services: An Expert Cookbook, plus presentation materials of the course, plus codes and scripts for all demos in the course, plus a year subscription to all paid training videos of RADACAD, PLUS an hour of direct phone or Skype discussion with Instructor for Free.
Q: Is this in-person training?
A: Yes.
Q: Where is the venue of the training?
A: After registering for the event, you will be notified about the exact location of the venue. You will be contacted after registration to advice for any accommodation requirement if you need any.
Q: Will I be able to discuss specific scenarios with Instructor?
A: Of Course, but not during course time. Instructor would be more than happy to answer your specific scenario questions in break times, or in the direct hour of discussion offered as part of this course.
Q: Would be meal and refreshment provided through the course?
A: All of our daily courses included morning and afternoon refreshments and lunch.
Q: What is refund and cancellation policy?
A: If you cancel your registration up to 4 weeks before the course start date you will be fully refunded minus administration fee. If you cancel in less than 4 weeks to start date of the course 50% of amount minus administration fee will be refunded. If you register but not show in the course nothing would be refunded.
If RADACAD cancel the course you will be 100% refunded of then amount you paid. (Administration fee will be refunded as well).
Q: How can I convince my boss to pay for this course?
A: We have written it for you; Letter to convince your boss
Q: Would there be hands on lab?
A: All of our courses include hands on lab. We believe that you learn tips and techniques of the course best with hands on lab.
Q: Will I learn new features in SSIS 2014 and 2016?
A: Definitely. Our courses designed with the latest available technologies.
Q: Do you have any other questions?
A: Don’t hesitate to contact us: training@radacad.com