Database Fundamentals

• Introduction
• Entity Releationship Diagram (ERD)
• ERD Mapping to Tables
• Structured Query Language(SQL)
• Data Manipulation Language(DML)
• SQL_other DB objects
• Normalization

Used Databases :

ITI.bak

Company_SD_Full.bak

Transact SQL queries using SQL server

• Introduction to SQL Server
• Database(Creation and Management)
• Join Operations and Data Integrity
• Functions,Subqueries and Set Operators
• EERD and SQL Server Security
• Transcat SQL