This five day course provides students with the knowledge and skills to develop Microsoft End to-End business solutions using SQL Server 2008 R2 in an integrated environment with Sql 2010 and Office 2010. The course introduces the students to Microsoft Unified Data Model, SQL 2008 R2 Analysis Services, Integration Services, Re-porting Services, Report Builder 3.0, Sql 2010 Integration, Reporting Services Content Types, PerformancePoint Services, Dashboard Designer, Excel Services, Power Pivot and Data Mining. The intention of this course is to allow a business to more accurately understand the scope of a BI project, the resources, the potential pitfalls, the state of the art and perhaps most importantly understand why it may produce for an organization an unmatched competitive edge.

SQL Training Audience:

Project mangers, developers, I.T. Professionals, end-user ombudsman, analyst

SQL Training Prerequisites

Understanding Of Relational Database Concepts and goals of Business Intelligence.

SQL Training Course duration

5 days

SQL Training Course outline

1. The Business Intelligence Stack

• SQL 2008R2 BI Platform
• Enterprise Extract Transform Load with Integration Services
• Analysis Server
• DBMS Management System
• Understanding Multidimensional Space Terminology
• Reporting Services
• Understanding Terminology
• Data Mining
• Dashboards/ Scorecards
• Sql 2010 Services 2010
• Web Server
• Content Database
• Web Application / Collection Tools