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).
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
See more
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.
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.
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 in-company 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.
By checking this box, I confirm that I have read and agree toTechnologia’s Privacy Policywhich provides information on how my personal information will be used following collection. In the event that you do not consent to the terms of the concerned Privacy Policy, Technologia will not have the information to assess your request, contact you to follow up on your request or provide you with the services.
I would like Technologia to send me commercial communications.
Learn more >
By checking this box, I agree that Technologia may use my personal information to send me commercial communications. I understand that I can withdraw my consent at any time by clicking on the unsubscribe link included in each communication. To learn more about how we manage your personal information, please consult our
Technologia’s Privacy Policy.