SQL Server Tutorial - For Beginners & Professionals

SQL Server is the most popular RDBMS developed by Microsoft. Now, SQL Server can run on the cloud, Windows, Linux and Docker containers. SQL Server supports the standard SQL language ANSI SQL aswell as T-SQL. SQL Server is widely used for scalability, performance, and developing intelligent applications. The SQL Server learning path goal is to make you expert in designing, managing and querying the SQL Server database.

Beginner

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.

SQL Server Tutorial - For Beginners & Professionals

Introduction to SQL Server

Basics of SQL Commands

Different Types of SQL Keys

Understanding Database Normalization with Example

SQL Server 2012 New Features and Programmability Enhancements

Enable Intellisense in SQL Server 2005, 2008

SQL Server Naming Conventions and Standards

Download SQL Server Express Editions - 2017, 2014

Sql Server 2019 New Features

SQL Integrity Constraints or Constraints

Different Types of SQL Joins

Different Types of SQL Server Views

Different Types of SQL Server Stored Procedures

SQL Server Exception Handling by TRY…CATCH

Definition, Use of Group by and Having Clause

Different Types of SQL Server Triggers

SQL Server System Defined Database

SQL Server XML Data Type

Different Types of SQL Server Functions

SQL Server Basics of Cursors

Create a comma separated list from column using select statement

Remove duplicate records from a table in SQL Server

Remove unsent database email from SQL Server

Get field name, data type and size of database table

Get nth highest and lowest salary of an employee

Difference between Stored Procedure and Function in SQL Server

Inserted, Deleted Logical table in SQL Server

Difference between Primary Key and Unique Key

Difference between Primary Key and Foreign Key

Drop all tables, stored procedure, views and triggers

Swap the values of two columns in SQL Server

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

Difference between inner join and equi join and natural join

How to insert values to identity column in SQL Server

Understanding Case Expression in SQL Server with Example

Calculate Running Total, Total of a Column and Row

Difference between CTE and Temp Table and Table Variable

SQL Server Exceptions Working

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

SQL Server Transactions Management

After Trigger, Instead of Trigger Example

SQL Injection Attacks

SQL Server XQuery Methods

SQL Server Database Mail Setup

Stored Procedure Plan Recompilation and Performance Tuning

SQL Server Different Types of Cursors

SQL Server Setting Triggers Firing Order

SQL Server Cursor Alternatives

Tips to improve SQL Server database design and performance