• Introduction to Basic Database Concepts
• E-R Modeling and Diagram
• Normalization
• Fundamentals of SQL Server / SQL
• DDL and DML Statements
• Working with Queries (DQL)
• Aggregate Functions
• Joins and Set Operations
• Implementation of Data integrity
• Working with Constraints / Views / Indexes / T-SQL / Cursors
• Data Control language (DCL) / Transaction Control Language (TCL)
• Working with Stored Procedures / Functions and Triggers
• Backup / Restore and Advance Features