MS SQL Server Tutorial Summary


The SQL Server is a leading Relational Database Management System by Microsoft. This MS SQL Server tutorial teaches you basic to advance level concepts of SQL Server. In this Microsoft SQL Server Management Studio tutorial, we will learn all the MS SQL server basics and advanced concepts for SQL server.

What should I know?


This online SQL server administration tutorial is designed for beginners with little or no SQL Server experience. But knowledge of SQL before learning this MS SQL tutorial is a plus. The below MSSQL tutorials will help you learn all the MS SQL server basics. Moreover, this SQL server for beginners tutorial also contains SQL server interview questions.

MS SQL Server Course Syllabus

Introduction

Lesson 1 What is SQL Server? — Introduction, Version History
Lesson 2 How to Download and Install SQL Server — Step-by-step Installation Guide
Lesson 3 SQL Server Architecture Explained — Named Pipes, Optimizer, Buffer Manager
Lesson 4 SQL Server Management Studio — MS SSMS Download & Install

Advanced Stuff

Lesson 1 SQL Server Database — Create, Alter, Drop, Restore
Lesson 2 SQL Server DataTypes with Examples — Varchar, Numeric, DateTime in SQL
Lesson 3 SQL Server Variable — Declare, Set, Select, Global, Local [TSQL Examples]
Lesson 4 SQL Server Table — CREATE, ALTER, DROP [T-SQL Examples]
Lesson 5 SQL PRIMARY KEY — How to Create & Add to Existing Table
Lesson 6 SQL FOREIGN KEY — How to Create in SQL Server with Example
Lesson 7 SQL Server IF…ELSE Condition Statement — Learn with T-SQL Select Query
Lesson 8 CASE Statement & Nested Case in SQL Server — Learn with T-SQL Example
Lesson 9 Substring() in SQL Server — How to use Function with Example
Lesson 10 SQL SERVER JOINS Tutorial — INNER, LEFT, RIGHT, OUTER
Lesson 11 Create User Account in SQL Server — Create Login, User, assign Permission
Lesson 12 Oracle Vs. SQL Server — Key Differences
Lesson 13 SSIS Tutorial for Beginners — What is, Architecture, Packages

Must Know!

Lesson 1 SSIS Interview Questions — Top 40 SSIS Interview Questions and Answers
Lesson 2 SQL Server Reporting Services — SSRS Tutorial for Beginners
Lesson 3 SSRS Interview Questions — Top 20 SSRS Interview Questions & Answers
Lesson 4 SSAS Tutorial — What is, Architecture, SSAS Cube & Types
Lesson 5 SQL Server Interview Questions — Top 50 SQL Server Interview Q & A
Lesson 6 SQL Server Tutorial PDF — Download SQL Server Tutorial PDF for Beginners