Implementing SQL Server 2008 Integration Services
by Skillsoft
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.Audience: IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developerObjectives: Implementing SQL Server 2008 Integration Services 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 Duration: 1.5
...