Outline for this course

Module 1: Introduction to Basic Database Concepts
Module 2: E-R Modeling and Diagram
Module 3: Normalization
Module 4: Introduction to SQL Server
Module 5: Introduction to SQL
Module 6: DDL and DML Statements
Module 7: Working with Queries (DQL)
Module 8: Aggregate Functions
Module 9: Joins and Set Operations
Module 10: Implementation of Data integrity
Module 11: Working with Constraints
Module 12: Implementing Views
Module 13: Data Control language (DCL)
Module 14: Working with Indexes
Module 15: Writing Transact-SQL (T-SQL)
Module 16: Working with Stored Procedures and Functions
Module 17: Implementing Triggers
Module 18: Working with Cursors
Module 19: Transaction Control Language (TCL)
Module 20: Backup and Restore
Module 21: Advance Features