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