SQLMentor // learn sql server

Learn SQL Server & T-SQL — Microsoft's Database Language

Microsoft SQL Server runs a huge share of enterprise systems, and its dialect — T-SQL — is the SQL flavour you'll need for any role touching the Microsoft data stack. This free interactive tutorial covers T-SQL from basic queries to stored procedures, window functions, CTEs, and query optimisation.

Every topic includes worked examples you can run against AdventureWorks-style sample tables, practice exercises, and a quick quiz. Use the sidebar to dive into the feature you need, or follow the chapters in order to build T-SQL fluency end-to-end.

T-SQL fluency is the entry ticket to the entire Microsoft data ecosystem — SQL Server on-premises, Azure SQL Database, Synapse and Fabric all speak it. The track suits application developers on the .NET stack, aspiring DBAs heading for the DP-300 certification, and analysts who query SQL Server through SSMS or Power BI every day.

What you'll master in T-SQL and SQL Server

  • T-SQL syntax, batches, and the GO separator
  • SELECT, joins, common table expressions (CTEs)
  • Window functions and the OVER clause
  • Stored procedures, user-defined functions, and triggers
  • Indexes, statistics, and execution plans
  • Transactions, isolation levels, and snapshot isolation

Common use cases for SQL Server and T-SQL

Line-of-business applications on the Microsoft stack

SQL Server is the default database for .NET applications in mid-size and enterprise companies — ERP, CRM and internal tools all driven by T-SQL stored procedures and views.

Business intelligence and reporting

The SQL Server BI stack — SSIS for ETL, SSRS for reports, Analysis Services and Power BI on top — is fed by T-SQL. Strong query skills are the foundation of every Microsoft BI role.

Cloud databases on Azure

Azure SQL Database and Managed Instance run the same T-SQL dialect, so everything in this track applies directly to cloud roles — including the Microsoft DP-300 Azure DBA certification.

Frequently asked questions about SQL Server and T-SQL

What is the difference between SQL and T-SQL?
T-SQL (Transact-SQL) is Microsoft's dialect of SQL used by SQL Server and Azure SQL. It extends standard SQL with procedural features — variables, IF/WHILE, TRY...CATCH error handling — plus dialect specifics like TOP, IDENTITY, APPLY operators and functions such as GETDATE() and STRING_SPLIT().
Can I use SQL Server for free while learning?
Yes. SQL Server Developer Edition is a free, full-featured edition licensed for non-production use, and SQL Server Express is free even for small production workloads. Both work with the free SQL Server Management Studio (SSMS).
How different is T-SQL from Oracle PL/SQL?
The core SQL is similar, but the procedural layers differ: T-SQL uses batches and GO separators, TRY...CATCH, and table variables, while PL/SQL uses BEGIN/END blocks, packages and exception sections. Knowing one makes the other much faster to pick up — many concepts map one-to-one.
Does this track help with the Microsoft DP-300 exam?
Yes, as the T-SQL foundation. DP-300 (Administering Microsoft Azure SQL Solutions) assumes solid query and administration skills; this track covers the language side, and SQLMentor offers a free 30-question timed DP-300 practice exam.
Loading content