| Course Contents | Durations (in Minutes) |
| Understanding the structure and design of MS SQL Database | 60 |
| Understanding of database normalization using MS SQL Server. | 60 |
| Installation and configuration of MS SQL Database. | 60 |
| Creation of various database objects using MS SQL Server. | 450 |
| a. Table Creation | |
| b. View Creation | |
| c. Index Creation | |
| d. SP Creation | |
| e. Trigger Creation | |
| f. Cursor Creation | |
| Understanding various database index and subsequent usage in MS SQL Server. | 30 |
| Understanding of various constraints in MS SQL Server. | 60 |
| Understanding of different queries and functions on MS SQL Server. | 30 |
| Different type of joining | 60 |
| Understanding of Sub Queries | 60 |
| Understanding of Loop function | 30 |
| Understanding query optimization using MS SQL Server | 60 |
| Practical on the above topics | 120 |
| Test on the above topics | 120 |
| Total Minutes | 1200 |
| Total Hours | 20 |