SQL Server Tutorial pdf free download for freshers and experienced pdf

1. Introduction

2. SQL
 Different roles of SQL

3. Features
 Enterprise Data Management
 Developer Productivity
 Business Intelligence

4. Data types

5. Database
 SQL Server System Databases

6.Tables
 Keys and Constraints
 Relationship between the tables
 Types of Relationships
 Table Creation

7. Clauses
 Select
 Distinct
 Into
 Where
 Group By
 Having
 Order By

8. Joins
 Types of joins

9. Views

10. Triggers
 The need and the usage
 Types of trigger events

11. Cursors
 Types of cursors
 Drawbacks of Cursors

12. CASE Statements

13. Temporary tables

14. Table variables
 Disadvantages of table variable over temporary table

15.Stored Procedure
 Benefits of Stored Procedure

16. Functions
 User Defined Functions
 Split function

17. Locking in SQL server

18. Index
 Types
 Index Architecture
 Index implementations
 Index Optimization Tips

19. Query Optimization Tips

20. SQL Syntax
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Control Language (DCL)

Posted in: SQL Server 2005 Study Material