Regular Price: £280 Batch Price: From £280 📅 View Dates & Prices Group Booking Discount: From £160 per person 🧮 Calculate & Book 1-to-1 Training: £400 📋 Booking Request Form Course Overview This course will help students to build the SSIS packages to extract, transform and load operations for a data warehouse. It details the methodologies for managing high-volume, slowly changing dimensions and for handling XML files. In addition, it covers the design patterns to load data for dimension and fact tables. Also this course helps the students to deploy the packages to production and execute the packages. Requirements This course is suitable for those who already have basic knowledge of SQL Server Integration Services. Our SQL Server Integration Services (SSIS) Training Courses cover all of the prerequisites. Course Content Advanced Integration Services - I Advanced Control Flow Using XML Files Using Web Service in SSIS 32 bit Vs 64 Bit SQL Task to return single / multiple columns / record set Using SQL Task in Control flow Advanced Integration Services - II SSIS Expressions Expression Introduction Expression Builder & Functions Using expression in precedence constraint Operators and More Variables Variables Expression Usage Connection Manager SQL Statement Precedence Constraints Debugging SSIS Packages Debugging - Basics Breakpoints Debug Windows Script Task Debugging Script Component Debugging Data Viewer Using the Grid Viewer Logging & Error Handling in SSIS Packages Package Logging Different types of logging using SQL server, Flat file, XML Logging in Control flow and Script Task Error output in Data Flow task Transaction Support Checkpoints Package Execution Package execution utilities DTEXEC SQL Server Agent Introduction to Data Warehouse Data Warehouse Basics OLTP Vs OLAP Star Schema / Snow flake Schema Kimball Vs Bill Inmon ETL Vs BI ETL Tools Dimension Facts Summary Developing SSIS Packages for Data Warehouse - I ETL Design pattern Extract package Extracting to staging Load Patterns Fact extract for ongoing load Developing SSIS Packages for Data Warehouse - II Slowly changing dimension Dimension loading pattern for Type 0, Type 1 & Type 2 Dimension Load Design patterns Fact table load design pattern Course Dates, Prices & Enrolment All Training Physical Classes Virtual Classes UTC British Time (UK, Ireland, Iceland) Central European Time (France, Germany, Sweden) Eastern European Time (Finland, Cyprus) Eastern Time (New York, Toronto, Montreal) Central Time (Chicago, Houston, Winnipeg) Mountain Time (Calgary, Denver, Edmonton) Mountain Time (Phoenix) Pacific Time (Los Angeles, Seattle, Vancouver) Singapore Time Arabic Standard Time (Qatar, Saudi Arabia) Gulf Standard Time (UAE, Oman) Australian Eastern Time (Sydney, Melbourne) Western Australia Time (Perth) New Zealand Time China Standard Time (China, Taiwan, Hong Kong) Scroll right for more details There is no date for this course at this moment. Please complete the BOOKING REQUEST FORM below or come back to this page again later. Note: Online classes are usually delivered through Zoom video conferencing. Price Calculator & Booking Request Form Calculate prices for Corporate, 1-on-1 or group training and request a booking. Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to: book a course on different dates book for a group of delegates book corporate training book a customised training book a one-on-one training The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below: How many hours? How many people? Total Cost Price per person Preferred Dates and Times Any other information