• 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