Module 1: Introduction to Basic Database Concepts ➢ What is Data, Field, Record and database? ➢ Limitations of File Management System. ➢ Basic Concepts of Advantages of DBMS. ➢ Exploring Relational DBMS ➢ Understanding Client and Server Module 2: E-R Modeling and Diagram ➢ Analyzing the Requirement ➢ Identify Entities and their Relationships ➢ Drawing E-R Diagram ➢ Conversion of E.R. Diagrams into Tables Module 3: Normalization ➢ First Normal Form ➢ Second Normal Form ➢ Third Normal Form Practically Normalizing Tables Module 4: Introduction to SQL Server ➢ What is SQL Server Version history and different editions ➢ Basic Features Components and Tools ➢ Starting and Stopping SQL Server Instances / Services ➢ Introduction to Management Studio ➢ Types of System Databases in SQL Module 5: Introduction to SQL ➢ Basics of SQL Types of SQL Statements ➢ DDL, DML, DQL, DCL and TCL ➢ Create Database using Management Studio ➢ Datatypes in SQL Server ➢ Exploring DDL Statements on Table using Management Studio Module 6: DDL and DML Statements ➢ Why write statements in Frontends? ➢ Create, Alter and Drop Table Insert, ➢ Update and Delete Statement Truncate Statement Module 7: Working with Queries (DQL) ➢ Understanding Select Statement ➢ Usage of Top, Distinct, Null etc...keywords ➢ Using String and Arithmetic Expressions ➢ Exploring Where Clause with Operators ➢ Using Advanced Operators ➢ Sorting data using Order By clause ➢ Working with basic of Sub Queries Module 8: Aggregate Functions ➢ Using functions in Queries ➢ Count, Sum, Min, Max, Avg Group By and Having Clause ➢ Using Group By with Rollup and Cube Module 9: Joins and Set Operations ➢ Introduction to Joins Cross Joins ➢ Inner Join ➢ Outer Join ➢ Self Join ➢ Co-related Sub Queries ➢ Set Operations using Unions, Intersect and Except Module 10: Implementation of Data integrity ➢ Entity integrity ➢ Domain integrity ➢ Referential integrity ➢ Types of constraints Module 11:Working with Constraints ➢ Unique ➢ Not NULL ➢ Primary Key ➢ Default Check Foreign Key