Intermediate

70-761: Querying Data with Transact-SQL

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.

Curriculum

18 Sections
20h Duration

Expand 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

70-761: Querying Data with Transact-SQL

Curriculum

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

Get In Touch

Resources

Categories

© 2025. All Rights Reserved.

70-761: Querying Data with Transact-SQL

Curriculum

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

Buy for group

70-761: Querying Data with Transact-SQL

You don't have any groups yet

Choose Group(s)