Microsoft's TSQL course is ideal for analysts, BI professionals, database administrators, and developers who want to learn how to work effectively with data in a SQL Server environment. The program covers SELECT, JOIN, GROUP BY, subqueries, variables, table expressions, NULL handling, and more. Practice on real queries - from the first lessons.
Course code: 20761 (20761‑C)
Duration: 5 days / 40 academic hours
Format: Microsoft authorized course + further preparation for MCSA certification: SQL 2016 Database Development
Trainer: Experienced Microsoft trainer with over 10 years of teaching experience and over 15 years in development
Course objective:
Provide a solid understanding of the T-SQL language, which underlies administration, development, and BI systems on the Microsoft SQL Server platform.
Database Administrators (DBAs)
SQL Server Developers
BI analysts and IT specialists
Basic knowledge of Microsoft Windows
Practical skills in working with relational databases
Understanding SQL Server architecture
Basic concepts of T-SQL, sets, predicate logic
Skills in writing SELECT queries — simple and with JOINS, UNIQUE, ALIAS, CASE
Ability to sort (ORDER BY), filter (WHERE, TOP, OFFSET-FETCH) data
Knowledge of SQL Server data types, date handling, strings
Working with DML: INSERT, UPDATE, DELETE
Using built-in functions (conversion, logical, NULL functions)
Data grouping, aggregation, group filtering (GROUP BY, HAVING)
Using subqueries (scalar, correlated)
Table expressions: views, TVF, CTE, derived tables
Set operations (UNION, EXCEPT, INTERSECT, APPLY)
Window functions, RANK, OFFSET, aggregations
Pivot tables: PIVOT, UNPIVOT, ROLLUP, CUBE
Execution of stored procedures, Dynamic SQL