SQL Server Management — Starter to Master

Almost every real C# application talks to a database. This module takes you from installing SSMS through writing production-quality T-SQL: schema design, queries, joins, stored procedures, indexing, and transactions.

1SSMS Interface Tour

A guided tour of SQL Server Management Studio and Object Explorer.

Beginner 15 min
11Free SQL Server Setup

Create a free cloud database with Aiven and connect it to Visual Studio.

Beginner 20 min
2Databases and Tables

Create databases and tables with primary keys and constraints.

Beginner 20 min
3Data Types & Constraints

Learn data types and constraints for data integrity.

Intermediate 20 min
4SELECT, WHERE, ORDER BY

Query data with SELECT, filter with WHERE, and sort with ORDER BY.

Intermediate 20 min
5Joins

Combine data from multiple tables with INNER, LEFT, RIGHT, and FULL joins.

Intermediate 25 min
6INSERT, UPDATE, DELETE

Add, modify, and remove data safely.

Intermediate 20 min
7Stored Procedures

Create reusable and secure stored procedures.

Advanced 25 min
8Functions & Views

Create scalar functions, table-valued functions, and views.

Advanced 25 min
9Indexes & Performance

Optimize query performance with indexes.

Advanced 25 min
10Transactions

Ensure data integrity with ACID transactions.

Advanced 25 min
Lessons
Test Your Knowledge - Take Quiz