About Lesson
| MODULE – 1 | Introduction to RDBMS. | 12 HOURS |
|---|---|---|
| a | Overview Of Database Management System | |
| b | Entity-Relationship Model | |
| c | Relational Model | |
| d | Structured Query Language | |
| e | Database Security Na Recovery |
| MODULE – 2 | Introduction to MS SQL Server | 8 HOURS |
|---|---|---|
| a | The Basic Architecture of SQL server. | |
| b | Versions editions and installation of MS SQL Server Express edition | |
| c | Getting started with SQL server management studio |
| MODULE – 3 | Introduction T-SQL | 24 HOURS |
|---|---|---|
| a | Sets, Predicate logic | |
| b | Creating tables using DML statements | |
| c | Writing simple select statements | |
| d | Filtering and sorting | |
| e | Eliminating duplicates | |
| f | Using exists, grouping, aggregate | |
| g | Using table aliases, writing case example | |
| h | Subqueries | |
| i | Union, except and intersect operators | |
| j | Joins, Inner and outer joins |
| MODULE – 4 | Advanced T-SQL | 12 HOURS |
|---|---|---|
| a | Creating stored procedures and triggers | |
| b | Passing parameters to stored procedures | |
| c | T_SQL error handling | |
| d | Backup and recovery |
