| | | |
|
More about MCTS: SQL Server 2005 Business Intelligence Boot Camp Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 Business Intelligence (MCTS: SQL Server 2005 BI) typically pursue careers as database administrators, database developers, or business intelligence developers. They have thorough knowledge of the Microsoft SQL Server 2005 Business Intelligence Development tool suite. This includes knowledge of database schemas, debugging, monitoring, and troubleshooting Business Intelligence solutions, and working with the Microsoft .NET Framework. They can write database queries, use SSAS data mining algorithms, and create and deploy SQL Server Reporting Services (SSRS) reports. Additionally, they author and deploy SQL Server Integration Services (SSIS) packages.
|
|
|
Prerequisites
The prerequisite for the MCTS: SQL Server 2005 Business Intelligence Boot Camp is the 6-day official MCTS: SQL Server 2005 boot camp
In addition, students attending this boot camp must also have:
- Conceptual understanding of OLAP Solutions
- Experience navigating a Windows Server Environment, including Windows services
- Exposure to enterprise data import and export scenario
- Exposure to creating reports in Microsoft Access or similar 3rd-party product, like Crystal Reports
- Conceptual understanding of the push and pull distribution subscription paradigm
|
Professional Certification:
This 6-Day Official MCTS: SQL Server 2005 Business Intelligence Boot Camp is the prerequisite for the 6-day Official MCITP: Business Intelligence Developer Boot Camp.
|
Courses Included:
- Course 2791: Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services (3 days)
- Course 2792: Implementing and Maintaining Microsoft SQL Server 2005 Integration Services (3 days)
- Course 2793: Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services (3 days)
| |
Exams Included:
Exam
70-445: Microsoft SQL Server 2005 Business Intelligence - Implementation and Maintenance |
|
|  |