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.