The beginner section will help to get the insight of SQL Server versions and features, Database normalization, SQL Keys, SQL commands, and naming convention etc. By the end of this section, you will have a strong foundation in SQL Server.

Introduction to SQL Server

Shailendra Chauhan

Basics of SQL Commands

Shailendra Chauhan

Different Types of SQL Keys

Shailendra Chauhan

Understanding Database Normalization with Example

Shailendra Chauhan

SQL Server 2012 New Features and Programmability Enhancements

Shailendra Chauhan

Enable Intellisense in SQL Server 2005, 2008

Shailendra Chauhan

SQL Server Naming Conventions and Standards

Shailendra Chauhan

Download SQL Server Express Editions - 2017, 2014

Shailendra Chauhan

Sql Server 2019 New Features

Satyaprakash Samantaray

The intermediate section will help you to understand and writing the complex SQL queries using Joins, Union and case expression. Furthermore, you will learn how to use SQL database objects like functions, procedures, cursors etc.

SQL Integrity Constraints or Constraints

Shailendra Chauhan

Different Types of SQL Joins

Shailendra Chauhan

Different Types of views in sql server

Shailendra Chauhan

Different Types of stored procedure sql Server

Shailendra Chauhan

Exception Handling in SQL Server by TRY…CATCH

Shailendra Chauhan

Definition, Use of Group by and Having Clause

Shailendra Chauhan

Different Types of Triggers In SQL Server

Shailendra Chauhan

SQL Server System Defined Database

Shailendra Chauhan

SQL Server XML Data Type

Shailendra Chauhan

Different Types of SQL Server Functions

Shailendra Chauhan

Cursors In SQL Server

Shailendra Chauhan

Create a comma separated list from column using select statement

Shailendra Chauhan

Delete Duplicate Rows in SQL Server From a Table

Shailendra Chauhan

Remove unsent database email from SQL Server

Shailendra Chauhan

Get field name, data type and size of database table

Shailendra Chauhan

Get nth highest and lowest salary of an employee

Shailendra Chauhan

Difference between Stored Procedure and Function in SQL Server

Shailendra Chauhan

Inserted, Logical Deleted table in SQL Server,

Shailendra Chauhan

Difference between Primary Key and Unique Key

Shailendra Chauhan

Difference between Primary Key and Foreign Key

Shailendra Chauhan

Drop all tables, stored procedure, views and triggers

Shailendra Chauhan

Swap the values of two columns in SQL Server

Shailendra Chauhan

Clear List of Recent SQL Server Connection From SQL Server Management Studio

Shailendra Chauhan

Difference between inner join and equi join and natural join

Shailendra Chauhan

How to insert values to identity column in SQL Server

Shailendra Chauhan

Understanding SQL Server Case Expression with Example

Shailendra Chauhan

Calculate Running Total, Total of a Column and Row

Shailendra Chauhan

Difference between CTE and Temp Table and Table Variable

Shailendra Chauhan

The advanced section will help you to understand advanced topics of SQL Server like SQL Injection attacks, triggers, transactions, execution plan, and tips to improve SQL Server database design and performance etc.

SQL Server Exceptions Working

Shailendra Chauhan

SQL Server Insert, Retrieve, Update, Delete Operations using Stored Procedures

Shailendra Chauhan

SQL Server Transactions Management

Shailendra Chauhan

After Trigger, Instead of Trigger Example

Shailendra Chauhan

SQL Injection Attacks

Shailendra Chauhan

SQL Server XQuery Methods

Shailendra Chauhan

SQL Server Database Mail Setup

Shailendra Chauhan

Stored Procedure Plan Recompilation and Performance Tuning

Shailendra Chauhan

SQL Server Different Types of Cursors

Shailendra Chauhan

SQL Server Setting Triggers Firing Order

Shailendra Chauhan

SQL Server Alternatives Cursor

Shailendra Chauhan

Tips to improve SQL Server performance & database design

Shailendra Chauhan