SQL Server: Zero to Advanced
Write T-SQL with confidence in SQL Server Management Studio: from your first SELECT to joins, CTEs, window functions, views and stored procedures.
3 lessons available now
Module 1 · Getting started
📖
Welcome to the course
Free preview
▶️
📖
Install SQL Server and SSMS
Coming soon
Your first SELECT query
Free preview
Module 2 · Filtering and sorting
▶️
WHERE, AND, OR and IN
Coming soon
🧪
ORDER BY and TOP
Coming soon
📖
✅
Working with NULL
Coming soon
Check your understanding
Free preview
Module 3 · Joining tables
▶️
INNER JOIN
Coming soon
🧪
LEFT, RIGHT and FULL joins
Coming soon
✅
Check your understanding
Coming soon
Module 4 · Aggregation
▶️
GROUP BY and aggregate functions
Coming soon
🧪
HAVING
Coming soon
Module 5 · Subqueries and CTEs
▶️
Subqueries
Coming soon
🧪
Common table expressions
Coming soon
Module 6 · Window functions
▶️
ROW_NUMBER, RANK and DENSE_RANK
Coming soon
🧪
Running totals with SUM() OVER
Coming soon
✅
Check your understanding
Coming soon
Module 7 · Changing data
▶️
INSERT, UPDATE and DELETE
Coming soon
🧪
Transactions
Coming soon
Module 8 · Views, functions and stored procedures
▶️
Views
Coming soon
🧪
Stored procedures
Coming soon
🧪
Final project
Coming soon