Intermediate

SQL Server

70-761: Querying Data with Transact-SQL

18 Sections
20h Duration

Collapse All

Introduction to Microsoft SQL Server

Introduction to T-SQL querying

Writing SELECT queries

Querying multiple tables

Sorting and filtering data

Working with SQL Server data types

Using DML to modify data

Using built-in functions

Grouping and aggregating data

Using subqueries

Using table expressions

Using set operators

Using Windows ranking, offset, and aggregate functions

Pivoting and grouping sets

Executing stored procedures

Programming with T-SQL

Implementing error handling

Implementing transactions

In this instructor-led, online training course, students will be introduced to Transact-SQL. Students will be given a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

70-761: Querying Data with Transact-SQL

Introduction to Microsoft SQL Server

Introduction to T-SQL querying

Writing SELECT queries

Querying multiple tables

Sorting and filtering data

Working with SQL Server data types

Using DML to modify data

Using built-in functions

Grouping and aggregating data

Using subqueries

Using table expressions

Using set operators

Using Windows ranking, offset, and aggregate functions

Pivoting and grouping sets

Executing stored procedures

Programming with T-SQL

Implementing error handling

Implementing transactions

About Us

TOIT blends technical know-how and a quality knowledge base and implements that blend throughout the four corners of the globe.

Follow Us

Resources

Categories

Get In Touch

© 2026. All Rights Reserved.

70-761: Querying Data with Transact-SQL

Introduction to Microsoft SQL Server

Introduction to T-SQL querying

Writing SELECT queries

Querying multiple tables

Sorting and filtering data

Working with SQL Server data types

Using DML to modify data

Using built-in functions

Grouping and aggregating data

Using subqueries

Using table expressions

Using set operators

Using Windows ranking, offset, and aggregate functions

Pivoting and grouping sets

Executing stored procedures

Programming with T-SQL

Implementing error handling

Implementing transactions

Deleting Course Review

Course Access

Categories