Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
SSIS Components $74.95
SSIS Solutions $74.95
Auditing, Logging, and Event Handling $74.95
SSIS Security $74.95
Designing a Fact Table $74.95
Troubleshooting Data Integration $74.95
SSIS Variables $74.95
Implementing Control Flow $74.95
Data Load Options $74.95

Bundle Price: $319.00
Total Savings: $355.55


SSIS Components

SSIS can be installed during the SQL Server installation or as a separate component. Before installation, there are a number of factors needing consideration, such as upgrade options and architecture. This course will cover SSIS components.

Learning Objectives
  • Start the course
  • Describe SSIS components
  • Prepare to install integration services
  • Recognize the various SSIS configurations
  • Install integration services using the setup wizard
  • Use the SSIS designer graphical tool
  • Describe when and how to use the development box and server
  • Install specifics for remote package execution
  • Plan for a 64-bit installation
  • Upgrade SSIS components
  • Provision accounts
  • Create the catalog
  • Describe catalog object identifiers
  • Configure a catalog
  • Install integration services using the setup wizard

SSIS Solutions

SSIS consists of several layers, including package properties and centralized management, to provide a rich and flexible environment. This course covers SSIS catalog creation and package deployment.

Learning Objectives
  • Start the course
  • Understanding the SSIS catalog
  • Backup and restore the SSIS catalog
  • Upgrade the SSIS catalog
  • Create a deployment utility
  • Deploy SSIS packages using the deployment utility
  • Deploy SSIS packages to SQL or file system locations
  • Deploy packages on multiple servers
  • Validate deployed packages
  • Install custom components and tasks
  • Deploy SSIS packages using DTUTIL

Auditing, Logging, and Event Handling

SSIS and SSDT both offer tools and techniques to monitor and optimize SSIS solutions. In this course, you'll learn how to implement auditing, logging, and event handling.

Learning Objectives
  • Start the course
  • Audit package execution by using system variables
  • Propagate events
  • Use log providers
  • Log an SSIS execution
  • Create alerting and notification mechanisms
  • Use event handlers in SSIS to track ETL events and errors
  • Implement custom logging

SSIS Security

SSIS consists of several layers, including digital signatures and database roles, to provide a rich and flexible security environment. This course covers techniques and recommendations on how to secure an SSIS deployment.

Learning Objectives
  • Start the course
  • Describe the SSIS catalog database roles
  • Describe the parameters and package deployment model
  • Describe the parameters and project deployment model
  • Describe the different package protection levels
  • Describe options available in the Package and Project Protection Level dialog box
  • Configure secure deployments using project and package protection levels
  • Secure integration services packages deployed at the file system
  • Create sensitive parameters
  • Set parameter values post deployment
  • Implement SSIS security

Designing a Fact Table

Each data warehouse consists of at least one fact table, which contains fundamental measurements of the business. This course covers the implementation of fact tables using partitions, data compression, and columnstore indexes.

Learning Objectives
  • Start the course
  • Describe data warehousing and its many relationships
  • Appropriately index a fact table
  • Describe columnstore indexes
  • Demonstrate partitioning
  • Recognize when to use additive and nonadditive measures
  • Implement a fact table
  • Determine the loading method for fact tables
  • Design summary aggregation tables
  • Implement a data warehouse database in SQL Server 2014

Troubleshooting Data Integration

SSIS includes tools and features that can be used to troubleshoot data integration. In this course, you'll learn how to debug and troubleshoot packages at the design and production level using techniques such as data viewers.

Learning Objectives
  • Start the course
  • Recall considerations for troubleshooting and what to look for
  • Troubleshoot performance issues
  • Troubleshoot execution of a task or transformation failed
  • Troubleshoot logic issues
  • Demonstrate awareness of the new SSIS logging infrastructure
  • Troubleshoot SSIS package failure from an invalid datatype
  • Use break points
  • Use data viewers
  • Profile data with different tools
  • Troubleshoot SSIS packages in SQL Server 2014

SSIS Variables

SQL Server 2014 allows for the use of parameters, variables, and expressions to create dynamic packages. This course covers SSIS variable concepts, such as system variables, scope, parameterization of properties, and data types.

Learning Objectives
  • Start the course
  • Implement user variables
  • Define a variable scope
  • Describe data types
  • Implement parameterization of properties using variables
  • Use variables in precedence constraints
  • Refer to SSIS system variables

Implementing Control Flow

By using the control flow data flow task, data flow can be implemented into the SSIS package specifying the data source, data transformation, and data destination. This course shows how to implement control flow elements.

Learning Objectives
  • Start the course
  • Recognize when to use checkpoints
  • Debug control flow
  • Implement control flow to solve a problem
  • Use data profiling
  • Use sequence containers and loop containers
  • Manage transactions in SSIS packages
  • Manage parallelism
  • Use precedence to control task execution
  • Create package templates
  • Implement control flow using the execute package task
  • Implement control flow

Data Load Options

SSIS is an extensible platform for creating data integration and workflow solutions. In this course, you will explore various options to load data.

Learning Objectives
  • Start the course
  • Describe data loading
  • Perform an incremental data load strategy
  • Perform a full data load strategy
  • Describe data mart
  • Plan for an incremental update of the relational data mart
  • Plan for loads into indexed tables
  • Configure bulk load options
  • Select an appropriate load technique (SSIS Destination)
  • Select an appropriate load technique (T-SQL)
  • Select appropriate load partitioned tables
Register Now
Microsoft SQL Server 2014: Implementing a Data Warehouse e-learning bundle
  • Course ID:
    271435
  • Duration:
    n/a
  • Price:
    $319