Introduction to Basic Database Concepts

E-R Modelling and Diagram

Normalization

DDL and DML Statements

Working with Queries (DQL)

Aggregate Functions

Joins and Set Operations

Implementation of Data integrity

Working with Constraints

Data Control language (DCL)

Writing Transact-SQL (T-SQL)

Working with Stored Procedures and Functions

Implementing Triggers