ΣνΜSyvara Software & Data TrainingSyvara Learning
🗄️

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
Reading · 5 min
Free preview
▶️
Install SQL Server and SSMS
Video · 20 min
Coming soon
📖
Your first SELECT query
Reading · 15 min
Free preview

Module 2 · Filtering and sorting

▶️
WHERE, AND, OR and IN
Video · 15 min
Coming soon
🧪
ORDER BY and TOP
Hands-on lab · 15 min
Coming soon
📖
Working with NULL
Reading · 10 min
Coming soon
✅
Check your understanding
Quiz · 10 min
Free preview

Module 3 · Joining tables

▶️
INNER JOIN
Video · 20 min
Coming soon
🧪
LEFT, RIGHT and FULL joins
Hands-on lab · 25 min
Coming soon
✅
Check your understanding
Quiz · 10 min
Coming soon

Module 4 · Aggregation

▶️
GROUP BY and aggregate functions
Video · 20 min
Coming soon
🧪
HAVING
Hands-on lab · 15 min
Coming soon

Module 5 · Subqueries and CTEs

▶️
Subqueries
Video · 20 min
Coming soon
🧪
Common table expressions
Hands-on lab · 25 min
Coming soon

Module 6 · Window functions

▶️
ROW_NUMBER, RANK and DENSE_RANK
Video · 20 min
Coming soon
🧪
Running totals with SUM() OVER
Hands-on lab · 25 min
Coming soon
✅
Check your understanding
Quiz · 10 min
Coming soon

Module 7 · Changing data

▶️
INSERT, UPDATE and DELETE
Video · 20 min
Coming soon
🧪
Transactions
Hands-on lab · 20 min
Coming soon

Module 8 · Views, functions and stored procedures

▶️
Views
Video · 15 min
Coming soon
🧪
Stored procedures
Hands-on lab · 30 min
Coming soon
🧪
Final project
Hands-on lab · 60 min
Coming soon
Working…