Free to read ยท Three levels

Microsoft SQL Server and T-SQL

A complete SQL Server theory path from relational queries to safe application access, concurrency, performance, and recovery.

18 lessonsEnglish + ArabicContent reviewed
Start learning

In this course

Learn Microsoft SQL Server through synthetic order, customer, inventory, and operational examples. The course develops T-SQL reasoning, database integrity, typed interfaces, transaction behavior, and evidence-based administration across three levels.

Every lesson includes developed explanations, reviewed SQL illustrations, expected semantics, common failure analysis, worked exercises, and Microsoft Learn references. Examples were not executed in a disposable engine and are intentionally marked non-runnable.

What you will learn

  • Model relational data and write predictable T-SQL queries.
  • Design constrained, parameterized, transaction-aware data changes.
  • Reason about isolation, indexes, plans, security, and application failures.
  • Evaluate performance, recovery, availability, and operational evidence.

Your learning path

Three levels

Basic

Build relational models and predictable T-SQL reads and writes.

  1. The engine, databases, tools, and batches
  2. Schemas, data types, and keys
  3. SELECT, predicates, NULL, and deterministic order
  4. Join relationships and test existence
  5. Grouping and trustworthy aggregates
  6. Safe INSERT, UPDATE, and DELETE
Explore this level

Intermediate

Protect integrity and concurrency while designing efficient database APIs.

  1. Constraints, transactions, and error recovery
  2. Isolation, locks, and concurrent decisions
  3. Indexes, statistics, and execution plans
  4. CTEs, windows, and temporary results
  5. Stored procedures and typed parameters
  6. Identities, permissions, and least privilege
Explore this level

Advanced

Connect workload evidence to resilient operations and application design.

  1. Query Store and performance investigation
  2. Deadlocks, waits, and incident evidence
  3. Backups, restore chains, and recovery models
  4. High availability and disaster recovery
  5. Operations, integrity, and observability
  6. Application access and resilient workflows
Explore this level

Who this is for

  • New database learners and application developers.
  • Engineers preparing to maintain SQL Server-backed applications.

Before you start

  • Basic computer and application concepts.
  • No existing SQL Server account or configured server is required.

Related technical solutions

Diagnose SQL Server login failure 18456Find the failing authentication or database-access boundary without disclosing credentials or broadening privileges blindly.Distinguish deadlock 1205 from lock timeoutClassify the wait, preserve read-only evidence, and choose cleanup and retry behavior that matches the transaction outcome.Fix conversion failures in dates and typed parametersLocate the actual conversion boundary, preserve Unicode input, and repair type contracts without silently accepting invalid business data.