Complete SQL Server Tutorial for Beginners

Welcome to the SQL Server Tutorial. This is a simple step by step tutorial for beginners to learn all the features of the MS SQL Server. The tutorial also covers some of the advanced features

MS SQL Server is a relational database management system from Microsoft. The primary function of the SQL Server is to store and retrieve the data whenever a request comes from application.

Prerequisites 

This tutorial requires you to be familiar with the concepts of database. This tutorial is designed to help both beginners & professionals.

Table of Content

SQL Server Tutorial

Getting Started with SQL Server

  1. What is SQL Server? Introduction to SQL Server
  2. How to download & Install SQL Server
  3. Download & Install SQL Server Management Studio
  4. What is an SQL Server Instance
  5. Connect to SQL Server using SSMS

SQL Server Basics

  1. Regular & Delimited Identifiers
  2. Reserved Keywords
  3. What is SQL Server Database
  4. How to Create a Database
  5. Drop Database
  6. Create Table
  7. Fully Qualified Table Names
  8. Drop Table
  9. Adding a Row to a Table

SQL Server Joins

  1. SQL Join in SQL Server
  2. Join Types in SQL Server
  3. Inner Join in SQL Server
  4. Left Join in SQL Server
  5. Right Join in SQL Server
  6. Full Join in SQL Server
  7. Cross Join in SQL Server
  8. Self Join in SQL Server
  9. Difference between inner and outer joins (left, right and full)
Scroll to Top