Training: SQL Integration Services Essentials (SSIS) Online Feb 13

[SQL SSIS Training]

Learn SSIS from the Experts
Designed For ETL and Data Professionals


SSIS Essentials Training  Online Feb13
Early Pricing $425





A one-day course designed for SQL professionsals dealing with Bulk-Data manipulations and ETL processes.  This hands-on class will feature techniques on how to get the most our of SQL Server Integration Services using BEST-PRACTICE methods.

Course Topics:

    Data Importing
     Managing delimited files
     Data type matching
     Handling missing and errors records
     Correction and resubmission of errors
     Variable columns
     Memory managment
 

    Data Manipulation
     Custom transformations
     Terniary syntax for derived columns
     Lookup vs Join vs Merge
     Correcting errors on input and output
     DQS integration
 

    Looping
     Iterating over datasets and objects
     Iterating over files 
     File manipulation through variables
     Data driven data-flow
 

    Transactions, Checkpoints and Restart-Ability
     Using SQL and SSIS transactions via SCOPE shapes
     Determining restart locations
     Rollback and compensation
 

    Error Handling and Status Logging
     Managing automated SSIS tasks
     Handling specific errors 
     Retry and restart based on errors and state
 

    Deployment 
     Managing DEV, PROD and QA
     Data driven execution with parameters
     Driving packages from SQL tables
 



Find Out More

Unsubscribe
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/pkg-zope-developers/attachments/20190202/ca4d2984/attachment.html>