MS SSIS

By attending MicroSoft SQL Server Integration Services (SSIS) workshop, Delegates will:

  • Learn ETL Concepts
  • Understand how to become SSIS developer
  • Learn tasks and precedence constraints
  • Learn working with event handlers
  • Learn working with Check Points
  • Learn working with Configuration files
  • Learn how to load facts and dimension tables

The MicroSoft SQL Server Integration Services (SSIS) training course is intended for Delegates who want to learn the important components of the Microsoft Business Intelligence Stack, SQL Server Integration Services. They learn to load and process SQL Server Analysis Server cubes and creates reporting solutions that will rapidly and accurately retrieve the correct data.

  • Delegates should have some basic knowledge of SQL language queries and experience using SSIS.

COURSE AGENDA

  • Architecture
  • Tools
  • Wizards
  • Packages
  • Control Flows
  • Data Flows
  • SSIS in operational/data warehousing environments
  • SSIS data types
  • SSIS transformation types
  • Containers
  • Precedence constraints
  • Variables
  • Expressions
  • Tasks
  • Connection Managers
  • Log providers
  • Containers
  • Precedence constraints
  • The data warehousing (DW) environment
  • The DW computing context
  • What is a data warehouse?
  • What is a data mart?
  • What is Business Intelligence (BI)?
  • How do OLTP & OLAP differ?
  • What is data mining?
  • Operational vs. historical data
  • Dimensional modelling
  • Some dimensional modelling characteristics
  • What is a star schema?
  • What is a snowflake schema?
  • What is metadata?
  • Types
  • How to alter and map
  • Parsing
  • Optimisation
  • Definition
  • Properties
  • Scope
  • Type
  • Namespaces
  • System
  • User
  • Execution behaviour
  • Definition
  • Elements
  • Property expressions
  • Variable expressions
  • Precedence constraint expressions
  • For Loop expressions
  • Concepts
  • Types (e.g., Foreach Loop)
  • Scoping
  • Properties
  • File System
  • Send Mail
  • Message Queue
  • WMI
  • Execute Package
  • Execute Process
  • Bulk Insert
  • Analysis Services
  • Data Mining
  • Execute SQL Agent Job
  • Update Statistics
  • Script Task
  • Source adapters (e.g., Raw Files)
  • Destination adapters (e.g., Data Reader)
  • Conditional Split
  • Multicast
  • Fuzzy Lookup/Fuzzy Grouping
  • Script component
  • OLE DB command
  • Union All
  • Sort
  • Merge/Merge Join
  • Lookup
  • Pivot/Unpivot (Excel worksheet)
  • Aggregate
  • Slowly Changing Dimension
  • Buffer architecture
  • Pipeline considerations
  • Synchronous vs. asynchronous
  • Blocking vs. semi-blocking vs. non-blocking
  • Execution trees interpretation and usage
  • Definition
  • When to consider
  • Checkpoints – how to implement and manage
  • Checkpoint files
  • Single Container and checkpoints
  • Multiple Containers and checkpoints
  • Single vs. multiple transactions
  • How to configure
  • How to set properties
  • Distributive transaction considerations
  • Scoping per container
  • Isolation levels
  • Snapshot isolation
  • Package configuration
  • What does the Deployment Wizard do?
  • When should the deployment utility be used vs. import/Export, XCopy, etc?
  • How to override configurations
  • How to deploy and account for security
  • How to optimise sources
  • How to optimise logging
  • How to optimise data flows
  • How to optimise error handling
  • How to optimise insert performance
  • Useful naming conventions
  • File watcher event
  • Custom logging
  • Best practices
  • Naming conventions (should adhere to Industry standard)