MS SQL Server Course Index — Dataplexa
Home › Learning Hub › MS SQL Server
MS SQL Server

MS SQL Server
Course Index

40 Lessons · 4 Levels

Complete MS SQL Server roadmap — SQL fundamentals, querying, joins, indexes, stored procedures, triggers, security and SQL Server in Azure cloud.

Start Course → ← Back to Learning Hub
40Lessons
4Levels
1Project
FreeAccess
Level I Foundations Level Lessons 1–10
Lesson 01
Introduction to Databases
Lesson 02
SQL vs NoSQL Databases
Lesson 03
What is MS SQL Server
Lesson 04
SQL Server Editions & Use Cases
Lesson 05
Installing SQL Server & SSMS
Lesson 06
SQL Server Architecture
Lesson 07
Databases & File Structure
Lesson 08
Tables, Rows & Columns
Lesson 09
SQL Server Data Types
Lesson 10
Creating Databases & Tables
Level II Core SQL & Data Operations Lessons 11–22
Lesson 11
Constraints & Keys
Lesson 12
Identity Columns
Lesson 13
INSERT Data
Lesson 14
SELECT Queries
Lesson 15
WHERE & Filtering
Lesson 16
ORDER BY, OFFSET & FETCH
Lesson 17
UPDATE Data
Lesson 18
DELETE Data
Lesson 19
Aggregate Functions
Lesson 20
GROUP BY
Lesson 21
HAVING Clause
Lesson 22
NULL Handling
Level III Relationships, Joins & Performance Lessons 23–32
Lesson 23
Table Relationships
Lesson 24
INNER JOIN
Lesson 25
LEFT, RIGHT & FULL JOIN
Lesson 26
Subqueries
Lesson 27
Views
Lesson 28
Indexes
Lesson 29
Transactions & ACID
Lesson 30
Locks & Concurrency
Lesson 31
Query Optimization
Lesson 32
Execution Plans
Level IV Enterprise & Administration Lessons 33–40
Lesson 33
Stored Procedures
Lesson 34
User-Defined Functions
Lesson 35
Triggers
Lesson 36
SQL Server Security & Roles
Lesson 37
Backup & Restore
Lesson 38
SQL Server Monitoring
Lesson 39
SQL Server in Cloud (Azure SQL)
Lesson 40
Mini Project
Ready to Start?
MS SQL Server Course Index
Start Course → ← Back to Learning Hub