In this section

Share this page

Querying Data with Transact-SQL (M20761)

Course Description

Learn how to write basic Transact-SQL queries for Microsoft SQL Server 2016. This course will provide 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.

You will learn about: T-SQL elements, writing SQL queries, querying JOINs, sorting and filtering data, SQL Server 2016 data types, T-SQL DML, built-in functions, grouping and aggregating data, subqueries, and set operators.

This course incorporates material from the Official Microsoft Learning Product 20761: Querying Data with Transact-SQL.

What You'll Learn

  • Basic architecture and concepts of Microsoft SQL Server 2016.
  • Similarities and differences between Transact-SQL and other computer languages.
  • Write SELECT queries.
  • Query multiple tables.
  • Sort and filter data.
  • Using data types in SQL Server.
  • Modify data using Transact-SQL.
  • Use built-in functions.
  • Group and aggregate data.
  • Use subqueries.
  • Use table expressions.
  • Use set operators.
  • Use window ranking, offset and aggregate functions.
  • Implement pivoting and grouping sets.
  • Execute stored procedures.
  • Program with T-SQL.
  • Implement error handling.
  • Implement transactions.

Who Needs to Attend

  • Database administrators
  • Database developers
  • Business intelligence professionals
  • Report writers
  • Business analysts
  • Client application developers.

Prerequisites

  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.

Follow-On Courses

  • Administering a SQL Database Infrastructure (M20764)
  • Implementing a SQL Data Warehouse (M20767)
  • Developing SQL Databases (M20762)

Certification

  • MCSA: SQL 2016 Database Development

Costs

£449 +VAT

Registration

Please complete the below form to confirm your provisional order for the Microsoft Official Course - On-Demand title Querying Data with Transact-SQL (M20761) We will contact you as soon as possible.