MS SQL Server Tutorial
Fiona Brown
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 | T-SQL Interview Questions — Top 50 T-SQL Server Interview Q & A |
| 👉 Lesson 7 | SQL Server Tutorial PDF — Download SQL Server Tutorial PDF for Beginners |
