Microsoft Business Intelligence (MSBI) Course

MICROSOFT

MICROSOFT BUSINESS INTELLIGENCE (MSBI) COURSE CONTENT

INTRODUCTION TO DATA SOTRE

• Different ways of storing Data

• • Books and Papers
  • Data Files
  • Database 

INTRODUCTION TO DBMS

• Understanding data storage in HDBMS
• Understanding data storage in NDBMS
• Introduction to RDBMS
• -Understanding Codd Rules
• -Understanding SEQUEL

INTRODUCTION TO SQL  SERVER

• Data Definition Language
• Using Constraints

• • Not Null, Unique, Primary, Check
  • Referential Integrity and Self
  • Referential Integrity
  • Using Cascading Rules
  • Performing DML Operations
  • Writing queries using
  • Functions
  • Single Row and Group
  • Operators

Conditional, Logical and Set

• • Clauses
  • Where, Group By, Having and order By
  • Sub-Queries
  • Correlated Sub-Queries
  • Join
• Transaction Control Language
• Creating tables from existing tables
• Managing Security with Data Control Language
  • User creation
  • Controlling the permission by Grant, Revoke and Deny

• Creating Views
• Understanding the Data Storage Architecture
• Creating Indexes
• Disadvantages of SQL and Introduction to PI/SQL

• • Writing Programs using PL/SQL
  • Understanding Cursors
  • Types of Cursors 

Introduction to Sub – Programs

Writing procedures

• • Handling Errors in Procedures
  • Transaction Management in Procedures
  • Writing User –Defined Functions
  • Disadvantages of Functions
  • Writing Triggers
  • Types of Triggers
  • DML and DDL Triggers (SQL Server 2005)

• Overview of new features in SQL Server 2005 

• Using Reporting Services

• Programming developing managed adding’s for outlook
• Advantages VSTO
• VSTO 2005 SE
• Runtime component 

ADDITIONAL NEEDED SERVICES IN WEB APPS (OPTIONAL)

• MSMQ in ASP.Net
• Its need in data transferring
• MSMQ – Its role in heterogeneous networks and systems
• Crystal Reports in ASP.Net

Designing Reports for Web Browsers