Posted - 02/19/2010 : 16:11:20
I am a newbie on this forum and am looking for some advice and direction please.
I will shortly be attending a Microsoft - MCTS/MCITP SQL Server 2008 Business Intelligence intense training course.
Unfortunately my knowledge of SQL is limited and I would like to prepare with some reading and some online training.
I would therefor be grateful if you could recommend any books or sites that I could benefit from.
I have listed below the course prerequisites and content and would appreaciate any help with this.
Working knowledge of theMicrosoft .NET Framework
Experience developing SQL Server 2005 BI components
Experience using the Business Intelligence Development Studio (BIDS)
Knowledge of relational and multi-dimensional database schemas
Full understanding of T-SQL
SQL Server 2008 BI Course Content
Module 1: Introduction to SQL Server 2008 Integration Services, Developing Integration Services Solutions, Implementing Control Flow, Implementing Data Flow, Implementing Logging, Debugging and Error Handling, Implementing Checkpoints and Transactions, Configuring and Deploying Packages, Managing and Securing Packages
Module 2: Introduction to Microsoft SQL Server Analysis Services, Creating Multidimensional Analysis Solutions, Working with Cubes and Dimensions, Working with Measures and Measure Groups, Querying Multidimensional Analysis Solutions, Customizing Cube Functionality, Deploying and Securing an Analysis Services Database
Module 3: Maintaining a Multidimensional Solution, Introduction to Data Mining, Introduction to Microsoft SQL Server Reporting Services, Authoring Basic Reports, Enhancing Basic Reports, Manipulating Data Sets, Using Report Models Publishing and Executing Reports, Using Subscriptions to Distribute Reports, Administering Reporting Services, Programming Reporting Services
Module 4: Exam Preperation, Exam 70-448
Module 5: Designing An Integration Services Solution, Designing A Reporting Services Solution, Designing An Analysis Services Solution
Module 6: Designing A BI Architecture
Module 7: Exam Preperation, Exam 70-452