| Part- I |
| Lesson 1: SQL SERVER OVERVIEW |
| Lesson 2: USING MANAGEMENT STUDIO |
| Lesson 3: DESIGNING RELATIONAL DATABASES |
| Part- II |
| Lesson 1: WORKING WITH SINGLE TABLE QUERIES |
| Lesson 2: MERGING DATA WITH JOINS & UNIONS |
| Lesson 3: WORKING WITH SUBQUERIES |
| Lesson 4: AGGREGATING DATA |
| Lesson 5: USING FULL-TEXT SEARCH |
| Lesson 6: SELECTING DATA THROUGH VIEWS |
| Lesson 7: DISTRIBUTED QUERIES |
| Lesson 8: MODIFYING DATA |
| Part- III |
| Lesson 1: T-SQL & STORED PROCEDURES |
| Lesson 2: TRIGGERS & AUDIT TRAILS |
| Lesson 3: USER-DEFINED FUNCTIONS |
| Lesson 4: INDEXING FOR PERFORMANCE |
| Lesson 5: TRANSACTIONS, LOCKING & BLOCKING (33 min) |
| Lesson 6: INTRODUCTION TO OPTIMIZATION THEORY |