MICROSOFT TECHNOLOGIES

SQL Server 2005

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

 

Note : The duration of the course is 20+ sessions of each one hour.