View All

Corporate Training

Live Training

View All

SQL Server Tutorial | Learn SQL Server | SQL Server Tutorial for Beginners

SQL Server is the most popular RDBMS developed by Microsoft. SQL Server can run on the cloud, Windows, Linux and Docker containers. SQL Server supports the standard SQL language ANSI SQL as well as T-SQL as per SQL Server Tutorial.

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 | Learn SQL Server | SQL Server Tutorial for Beginners

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 views in sql server

Different Types of stored procedure sql Server

Exception Handling in SQL Server by TRY…CATCH

Definition, Use of Group by and Having Clause

Different Types of Triggers In SQL Server

SQL Server System Defined Database

SQL Server XML Data Type

Different Types of SQL Server Functions

Cursors In SQL Server

Create a comma separated list from column using select statement

Delete Duplicate Rows in SQL Server From a Table

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

Tips to improve SQL Server performance & database design

Top 20 SQL Server Interview Questions and Answers