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
- 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.