SQL Server

SQLSERVER

1. Basics of DBMS

2. Basics of RDBMS

3. Data Models

4. What is SQL server

5. Introduction to SQL Server 2005

6. Tools of SQL Server 2005

7. Security

8. Authentications

A. Windows

B. SQL Server

9. Data types

10. TSQL Introduction

11. Database designing

12. Files and File groups

13. Data Definition language

14. Data Manipulation Language

15. Data Retrieval Language

16. Transactions in SQL Sever 2005

A. Commit

B. Roll back

17. Operators

18. Functions

A. Number Functions

B. Character Functions

C. Date time Functions

D. Aggregate Functions

19. Clauses

A. Group By

B. Having

C. Order by

20. Set Operators

21. Joins

A. Inner Join

B. Outer Join(3)

C. Non Equi Join

D. Self Join

E. Cross Join

22. Sub Queries

23. Copying table concept

24. Constraints

A. Primary key

B. Unique

C. Foreign key

D. Check Constraint

E. Not Null

F. Default

25. Views

26. Indexes

27. Synonyms

28. Snapshots

29. Locks in SQL Server 2005

30. Introduction to Programming

31. Batches and Basic programs

32. If. Else, While

33. Cursors

34. User Defined Functions

35. Stored Procedures

36. Triggers

37. Architecture of SQLSERVER 2005

38. SQLSERVER 2008 Features