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.
Duration
2 days
Schedule
9h to 16h
Regular fee
$1,035
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$930
Objectives of the training
To provide the knowledge and skills required to make effective use of MS SQL Server Integration Services (SSIS).Targeted audience
ETL developers.Prerequisite
None.Trainers
Course architecture
Training eligible for SCALE AI grants
- 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
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quoteDuration
2 days
Schedule
9h to 16h
Regular fee
$1,035
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$930
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote