Course Outline:

Day-1
Introduction
Download & Install SQL Server
Connect to SQL Server
Understanding the RDBMS
Database Normalization
NoSQL database

Day-2
SQL Command
DDL Command: Create, Alter, Drop Database
DDL Command: Create, Alter, Drop table
DML Command: Insert, Update and Delete data in Database
Primary key & foreign key relationship

Day-3
Default Constraint
Cascading referential integrity constraint
Select record from table
Check Constraint
Identity column
Difference between Delete & Truncate command
Last generated column value

Day-4
Unique Key Constraint
Summary of Constraint
Select Statement
Order By
Distinct
TOP/Like

Day-5
Operators in SQL
SQL Arithmetic Operators
SQL Comparison Operators
SQL Logical Operators
Group by Clause
Having Clause

Day-6
Sql server join types
Inner join
Left Join
Right Join
Full Join
Cross Join
Merge Join
Self-Join
Pivot/Unpivot

Day-7
Different ways to replace NULL
COALESCE
Case Statement
Union and Union all
Difference between Join and Union
Estimated Execution Plan

Day-8
String Functions
LEFT, RIGHT, CHARINDEX, SUBSTRING
Wildcards
Date Functions
CAST
CONVERT

Day-9
Temporary Table / #Table
Clone Table
Sub Query
Aggregate function
Scalar function
Views
Trigger

Day-10
ALIASES
ISNULL Function
NULLIF
IF ELSE
WHILE LOOP
SELECT INTO
INSERT INTO SELECT

Day-11
Store Procedures
Store Procedures with basic parameters
Store Procedures with output parameters
Store Procedures with return values
Advantage of Store Procedures

Day-12
Indexing
Describing Index Structures
Clustered Indexes
Non clustered (NC) Indexes
SQL - Transactions

Day-13
DeadLock in SQL Server
How to Prevent Deadlock
SQL Injection
How to Prevent SQL Injection
SQL Cursor
SQL Cursor Implementation

Day-14
Database Backup/Restore
Database Maintenance
Job / Scheduling
Database Mail Configuring
Creating and Configuring Alerts

Curriculum