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
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!