Mon - Fri | 9am - 6pm GMT

Microsoft SQL Server 2016: Querying Transact-SQL (70-761)

Microsoft SQL Server 2016: Querying Transact-SQL (70-761)

Transact-SQL is how you communicate with a Microsoft SQL Server to add and retrieve data in their SQL Server databases, a key concept for IT professionals in many roles as the database lies at a crucial stage of operations for businesses in multiple industries.

This course is designed to give you a level of understanding of the Transact-SQL language that is good enough for you to not only pass the official 70-761 exam, but also practically implement the skills you learn when querying and managing data in a corporate environment to help efficiently run business IT and operations. People in job roles ranging from SQL Developer, DevOps, Database Administrator and Development will find the 70-761 beneficial to their career as it will teach you the core skills needed to manage a database, talk to the database server and store data for applications in a database.

The course is delivered to you through our convenient but effective online training platform where you will have unlimited access to the 18 hours of in-depth content which will guide you through how to query data with Transact-SQL in a Microsoft SQL Server using both basic and advanced protocols.


  • Describe key capabilities and components of SQL Server
  • Describe T-SQL, sets, and predicate logic
  • Write a single table SELECT statement
  • Write a multi-table SELECT statement
  • Write SELECT statements with filtering and sorting
  • Describe how SQL Server uses data types
  • Write DML statements
  • Write queries that use built-in functions
  • Write queries that aggregate data
  • Write subqueries
  • Create and implement views and table-valued functions
  • Use set operators to combine query results
  • Write queries that use window ranking, offset, and aggregate functions
  • Transform data by implementing pivot, unpivot, rollup and cube
  • Create and implement stored procedures
  • Add programming constructs such as variables, conditions, and loops to T-SQL code


  • Learn how to talk to the SQL Server to retrieve and input data
  • Talk to any version of the Microsoft database (including 2016, 2014 2012, even all the way back to 2000) with the skills you learn in this course
  • Learn how to master T-SQL and SQL Server with the help of subject matter experts with over 10 years’ experience in technical IT
  • 24-hour access to the course content, seven days a week for an entire year
  • This course includes a practice exam where you can become accustomed to the criteria needed for the official 70-761 exam
Course Code
Online Course
Course Access
1 Year
Exams Included
1 gigahertz (GHz)
1 GB
Operating Systems
Windows 7
Windows 8
Windows 10
Mac OS
Internet Explorer 8 or above
Google Chrome
Safari 6 or above
Mozilla Firefox
Windows, Mac, iPhone, iPad, Android



Your query is submitted.
Learn more about how we use your data
Go on Top