• Introduction to Database Management System (DBMS)
• Understand and Use Databases
• Data Models
• Relational Database Management System (RDBMS)
• How Primary Key works
• How Composite Key works
• How Foreign Key works
• Structured Query Language (SQL)
• Type of Relationships e.g. One to One relationship , One to Many relationship and Many to Many Relationship
• Step by Step guide to install Microsoft SQL Server
• Create new Database by using Microsoft SQL Server Management Studio
• CRUD Operations
• Selection of DISTINCT Records
• Writing SQL Queries to learn different type of SQL Joins
• SQL Development by using Microsoft SQL Server
• Database Development
• Definition of Aggregate Functions
• Count function
• Min Aggregate function
• Max Aggregate function
• Sum Aggregate Function
• Different variations of Group By Clause
• Converting values in Upper case
• Converting values in Lower Case
• Substring function
• TOP keyword
• Understand and Use SQL with Database
   

Who this course is for:

• Anyone with basic knowledge of computer
• Any One willing to learn SQL Server