Font size:

Description:

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

Course Price
Implementing SQL Server 2008 Integration Services $74.95
Configuring SQL Server 2008 Integration Services Packages $74.95
Deploying SQL Server 2008 Integration Services Packages $74.95
Implementing SQL Server 2008 Reporting Services Solutions $74.95
Managing SSIS Packages in SQL Server 2008 $74.95

Bundle Price: $199.00
Total Savings: $175.75


Implementing SQL Server 2008 Integration Services

Microsoft SQL Server 2008 offers a combination of powerful Business Intelligence services to help clients develop and manage sophisticated business intelligence solutions. With the Database Engine at its core, SQL Server 2008 offers integration, reporting, and analysis tools to access and process the data necessary to create business solutions. This course gives an overview of the importance of business intelligence in today's competitive market and introduces the capabilities provided by SQL Server 2008 Integration Services, Reporting Services, and Analysis Services. It then focuses on the use of SQL Integration Services as a data integration solution and outlines the installation and configuration of this server component. The course also covers the key utilities used to configure and manage Integration Services, including the SQL Server Management Studio, Business Intelligence Development Studio, configuration wizards, and command-line tools. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 T'S: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
  • identify Business Intelligence technologies
  • recognize how to install Integration Services
  • recognize the features of SQL Server 2008 Integration Services
  • recognize the tools in the Integration Services studios
  • recognize how to create a data package
  • verify and manage a data package
  • use the SQL Server 2008 Integration Services tools

Configuring SQL Server 2008 Integration Services Packages

This course explores the various components that make up an SSIS package. This includes elements of package control flow, such as containers used to provide the structure in packages, the actual tasks that provide the package functionality, and precedence constraints that define the interconnection between tasks to create the control flow. For package data flow, the elements covered are the sources used to extract the data, transformations used to manipulate the data, and destinations responsible for loading the data. Paths are then used to connect the components to form the data flow. The course also covers Integration Services features that can be used to extend the functionality of packages, including event handlers, transactions, checkpoints, variables, expressions, and queries. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
  • recognize how the connection manager works
  • recognize how to work with control flows
  • recognize how event handlers and Integration Services variables are used in SQL Server 2008
  • recognize how to use Property Expressions in SQL Server 2008
  • use checkpoints and transactions in SQL Server 2008
  • recognize how to implement control flow
  • recognize how to implement data flow
  • create an SSIS solution
  • create an SSIS data package flow

Deploying SQL Server 2008 Integration Services Packages

This course discusses the deployment and execution of SQL Server Integration Services (SSIS) packages. Once packages have been created, they must be deployed to a production server. This course gives an overview of the package deployment options available, the preparations of packages for deployment using package configurations, and the creation of a deployment utility. It also covers the methods used to install packages once deployed to the server, including the use of the Package Installation Wizard. The course also discusses the methods for running packages from within BIDS and using the DTExec command utility, and outlines how to schedule package execution using SQL Server Agent jobs. Also discussed are the methods and tools available to monitor and secure Integration Services and SSIS packages. This includes an overview of the logging feature and how to use it to enable logging on packages, the event handling process in Integration Services, and the debugging options used. The course also describes best practices for securing packages during development, deployment, and operation using roles, package protection levels, and digital certificates. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
  • recognize how to create a package configuration
  • deploy SSIS packages
  • manually execute SSIS packages
  • schedule the execution of your SSIS packages
  • use the SQL Server Import and Export Wizard to create a simple package
  • set up the Deployment Bundle
  • install and run SSIS packages

Implementing SQL Server 2008 Reporting Services Solutions

SQL Server 2008 Reporting Services provides powerful and flexible solutions for enterprise reporting needs. This course introduces the reporting services functionality, tools, installation, and enhancements provided by SQL Server 2008. It outlines the fundamental tasks involved in authoring a basic report and explores the features available to customize and enhance report functionality. This includes understanding the Report Definition Language used with reports, the types of report objects and items that can be added to reports, defining and manipulating data sources and datasets, and formatting the appearance of reports. The course also covers the use of parameters and filters in manipulating report data sets, as well as the addition of user interactivity features such as drilldowns, document maps, and sorting. The course also discusses how the functionality of reports can be extended through the incorporation of expressions and custom code assemblies. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
  • recognize what SQL Reporting Services is used for
  • install Reporting Services
  • configure Reporting Services
  • recognize how to author SQL Server reports
  • format reports in SQL Server 2008
  • recognize how to filter data in SQL Server 2008 reports
  • add interactivity to reports
  • add expressions to reports
  • add custom code in reports
  • use reports in SQL Server 2008

Managing SSIS Packages in SQL Server 2008

This course discusses managing SQL Server Integration Services (SSIS) packages. Once packages have been created, they must be deployed to a production server and then managed by administrator and users. This course gives an overview of the logging feature and how to use it to enable logging on packages, the event handling process in Integration Services, and the debugging options used. The course also describes best practices for securing packages during development, deployment, and operation using roles, package protection levels, and digital certificates. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
  • recognize how to store information in a log file
  • recognize how to create a log on a server
  • configure a package to handle bad data
  • recognize how to perform debugging
  • recognize ways to secure SSIS packages
  • implement logging
  • debug SSIS packages
  • secure an SSIS package
Register Now
Microsoft SQL Server 2008: Business Intelligence Development and Maintenance Part 1 e-learning bundle
  • Course ID:
    252794
  • Duration:
    9 hours
  • Price:
    $199