This training kit is designed for business intelligence developers and administrators who plan to take the Microsoft Certified Technical Specialist (MCTS) Exam 70-445, Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance. The primary objective of this exam is to certify that business intelligence developers and administrators know how to implement and maintain solutions built on the SQL Server™ 2005 business intelligence platform that includes SQL Server 2005 Integration Services (SSIS), SQL Server 2005 Analysis Services (SSAS), and SQL Server 2005 Reporting Services (SSRS). We assume that before you begin using this kit, you have experience developing or implementing business intelligence solutions. We also assume that you have experience managing or supporting business intelligence projects' security, deployment, and maintenance. The Preparation Guide for Exam 70-445 is available from http://www.microsoft.com/learning/exams/70-445.mspx. The labs in this training kit will use Microsoft SQL Server 2005 Enterprise Edition or Microsoft SQL Server 2005 Developer Edition, and a 180-day evaluation edition is included on the companion DVD. If you do not have access to this software, you can download a 180-day trial of SQL Server 2005 from http://www.microsoft.com/sql/downloads/trial-software.mspx. You can also consider purchasing SQL Server 2005 Development Edition, which contains all required features.
By using this training kit, you will learn how to:
-
Install and configure the SQL Server 2005 business intelligence components.
-
Work with the design and management tools in SQL Server 2005 for business intelligence.
-
Develop and deploy SSIS projects.
-
Develop and deploy SSAS solutions.
-
Implement, configure, and deploy SSRS reports.
-
Secure, manage, and troubleshoot SSIS packages.
-
Secure SSAS cubes and dimensions.
-
Manage and secure SSRS report servers.
About the Author
The mentors at Solid Quality Learning combine deep technical expertise and real-world implementation experience to provide advanced solutions and training for the Microsoft SQL Server database platform. |
