| Chapter 1: Developing SQL Server | |
|---|---|
| 1.introduction | |
| 2.variables | |
| 3.transaction | |
| 4.locks | |
| 5.working With Locks | |
| Chapter 2: Working with Database | |
|---|---|
| How To Create Sql Server Database? | |
| Detaching And Attaching A Database | |
| The Data File And The Transaction Log In A Database | |
| Chapter 3: Reporting Services | |
|---|---|
| Introduction To Reporting Services | |
| Sql Server 2008 Reporting Services | |
| Reporting Services 2008 | |
| Reporting Services - Part 1 | |
| Reporting Services - Part 2 | |
| Chapter 4: Stored Procedures | |
|---|---|
| Stored Procedures - Part1 | |
| Stored Procedures - Part2 | |
| Stored Procedures - Part3 | |
| Stored Procedures - Part4 | |
| Chapter 5: Noramalization | |
|---|---|
| Normalization - Part1 | |
| Normalization - Part2 | |
| Normalization - Part3 | |
| Chapter 6: Triggers | |
|---|---|
| Triggers - Part 1 | |
| Triggers - Part 2 | |
| Triggers - Part 3 | |
| Chapter 7: Sub Strings | |
|---|---|
| Sub String - Part 1 | |
| Sub String - Part 2 | |
| Chapter 8: Functions | |
|---|---|
| Pl-sql Functions | |
| Sql Functions | |
| Chapter 9: Indexes | |
|---|---|
| How To Build An Index | |
| Introduction | |
| Indexing Part - I | |
| Indexing Part - Ii | |
| Indexing Part - Iii | |
| Indexing Part - Iv | |
| Chapter 10: Working with views | |
|---|---|
| Working With Views 1 | |
| Working With Views 2 | |
| Working With Views 3 | |
| Chapter 12: Joins | |
|---|---|
| Joins - Part 1 | |
| Joins - Part 2 | |
| Joins - Part 3 | |
| Chapter 13: Introduction | |
|---|---|
| Introduction- Part1 | |
| Introduction- Part2 | |