View All

Corporate Training

View All

SQL Server Tutorial - For Beginners & Professionals

SQL Server - SQL Commands, PL/SQL, Joins, Stored Procedures, Functions, Triggers, Data Import and Export

The beginner articles will help you to understand SQL Server version history and components, SQL commands, SQL Keys, naming convention etc.

The intermediate articles will help you to understand SQL Server intermediate concepts like Joins, SQL Queries, functions, writing queries, case expression etc.

SQL Integrity Constraints or Constraints

Shailendra Chauhan

Different Types of SQL Joins

Shailendra Chauhan

Different Types of SQL Server Views

Shailendra Chauhan

Different Types of SQL Server Stored Procedures

Shailendra Chauhan

SQL Server Exception Handling by TRY…CATCH

Shailendra Chauhan

Definition, Use of Group by and Having Clause

Shailendra Chauhan

Different Types of SQL Server Triggers

Shailendra Chauhan

SQL Server System Defined Database

Shailendra Chauhan

SQL Server XML Data Type

Shailendra Chauhan

Different Types of SQL Server Functions

Shailendra Chauhan

SQL Server Basics of Cursors

Shailendra Chauhan

Database Normalization Basics

Shailendra Chauhan

Create a comma separated list from column using select statement

Shailendra Chauhan

Remove duplicate records from a table in SQL Server

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, Deleted Logical 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 Case Expression in SQL Server 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

Advanced

The advanced articles 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 Cursor Alternatives

Shailendra Chauhan

Tips to improve SQL Server database design and performance

Shailendra Chauhan

Courses

Master ASP.NET MVC with linear and project-based courses. Get access to world-class Learning Platform to LEARN ASP.NET MVC to BUILD industry grade applications under our expert guidance. Our innovative hands-on training approach will EMPOWER you to take any future assignment with confidence.