Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Overview/Description
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.
IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer
Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio