Extract, transform and load. With this training you will see the selection of information coming from heterogeneous data sources of the company (Extract), the consolidation of these elements in order to make the whole coherent (Transform) and finally the recording of the data thus constituted (Load) in a repository which can thereafter be used as a support of analysis for the decision-making.
Objectives
To provide the knowledge and skills required to make effective use of MS SQL Server Integration Services (SSIS).
Is it for you ?
ETL developers.
Prerequisite
None.
Your benefits
Content
- SSIS Architecture and the SSIS development environment
- Key SSIS concepts: containers, tasks, precedence constraints, data streams, connectivity, variables, and package configurations
- Creation of a control stream and package data
- Component connection and data streams
- Designing high-performance, extensible packages
- Designing packages for complex tasks
- Debugging SSIS packages: executing a package, defining breakpoints, adding a data inspector
- Controlling the progress of data streams
- Configuring and deploying SSIS packages
- Switching between project mode and package mode
- Deploying packages to SSIS databases
- Using SSIS ETL features (Extract, Transform and Load)
- Using transformations: derived columns, slowing changing dimensions, fuzzy lookups and fuzzy grouping
💡 Useful information
Our training sessions are offered in Montreal or Quebec City, in person or in virtual format. Dates and locations are provided when you select your session below. If you have any questions regarding registration, schedules, the language of instruction, or cancellation policies, please consult our FAQ .
Trainers
Private or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quote