SQL Server database Overview

• RDBMS Overview and types
• Features

Installations and configuration of SQL server

• System Requirements
• Editions in sql server
• Installing the sql server
• Upgrading the latest versions
• Verifying the installation

User logins and schema

• Introduction to schema
• Logins types

Introduction to Data Definition Language(DDL)

• CREATE statement
• AlTER statement
• DROP statement

Introduction to Data Definition Language(DML)

• INSERT statement
• UPDATE statement
• DELETE statement
• MERGE Statement

SQL Functions

• SQL Functions overview
• Character functions
• Non-Character functions

Joins

• Overview
• Equijoins
• Inner Joins
• Outer Joins
• Cross Joins

Triggers

• DDL Triggers
• DML Triggers
• Logon Triggers

Statements in SQL query

• Operators
• Aggregates
• Where
• Group by
• Having
• Distinct, Top

Stored procedure in SQL

• Functions in SQL
• Ranking Functions
• Scalar Functions
• Date functions
• User Defined Functions

Advanced Concepts

• Case Statement
• Exception handling
• Temp tables
• Table Variables
• Usage of While loop & if conditions
• Transactions
• Sub Queries
• Views
• CTE
• Cursor