This 3 days course designed to teach you SSIS inside-out. You will learn SSIS and using it pragmatically in your everyday job of BI, ETL, or SSIS development. You will learn simple to complex scenarios of working with SSIS tasks and components. At the end of this course you will be able to implement any data transformation scenarios with SSIS.
This is not a regular Microsoft Certification training. You will learn SSIS 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 SSIS solutions.
Instructor
Reza Rad worked with SSIS from the first day SSIS has 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
- Getting Started with SQL Server Integration Services
- Control Flow Tasks
- Data Flow Tasks Part 1 – Extract and Load
- Data Flow Tasks Part 2 – Transformations
- Data Flow Tasks Part 3 – Advanced Transformations
- Parameters, Expressions, and Dynamism
- Containers and Precedence Constraints
- Scripting
- Deployment
- Debugging, Troubleshooting, and Migration
- Event Handling and Logging
- Execution
- Restart-ability and Robustness
- Performance Tips and Tricks
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 in PDF format, 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