20761 - Querying Data with Transact-SQL

MOC 20761 Querying Data with Transact-SQL is designed as a thorough introduction to Transact-SQL. This is the best course to take if you are planning on taking exam 70-761.

Training for Your Group

Training On Demand


Training for Individuals


Course Overview

This Querying Data with Transact-SQL training class is designed to introduce students to Transact-SQL. It is designed so that the first three days teach students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 and 5 teach the remaining skills required to take exam 70-761

Course Length: 5 days

Audience: Database Administrators, Database Developers, BI Professionals

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

What You're Going To Learn

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

Register for an Upcoming Date

Please call for information

This Course is Available On Demand

90 Day Access

$ 999
  • 90 Day Subscription

180 Day Access

$ 1199
  • 180 Day Subscription
Most Popular

180 Day Access +

$ 1399
  • 180 Day Subscription

Course Outline

Introduction to Microsoft SQL Server 2016

  • The Basic Architecture of SQL Server
  • SQL Server Editions and Versions
  • Getting Started with SQL Server Management Studio
  • Lab: Working with SQL Server 2016 Touls
  • Working with SQL Server Management Studio
  • Creating and Organizing T-SQL Scripts
  • Using Books Online

Introduction to T-SQL Querying

  • Introducing T-SQL
  • Understanding Sets
  • Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT statements
  • Lab: Introduction to T-SQL Querying
  • Executing Basic SELECT Statements
  • Executing Queries that Filter Data using Predicates
  • Executing Queries That Sort Data Using ORDER BY

What to Expect at LeapFox

Knowledgeable Instructors

Our instructors are certified professionals. They are trained on the latest features and how to get the most out of software programs.

Hands-on Labs

No boring lectures! Our courses are designed to give students lots of time to practice what they are learning with hands-on exercises and projects.

Bounce Back Pass

Retake any course for up to 3 months. *Some limitations apply

Certificate of Completion

Receive a certificate of completion at the end of every course.

Up-to-date Curriculum

Each course comes with a helpful and up-to-date ebook which will contain instruction and practice exercises.

Time Saving Tips N Tricks

In each course, your instructor will show you tips and tricks that will save you time and make you more efficient.

Friendly and Helpful Staff

Our staff is dedicated to your success. Each team member is trained to provide the absolute best customer service possible.

Satisfaction Guarantee

If you aren't 100% satisfied with your experience at LeapFox, simply let us know, and we will make it right.

Look who Else is Using LeapFox

Live Microsoft Technical Training

LeapFox Learning offers live, instructor-led training courses.  We offer both classroom training in Boise, Idaho as well as Remove Live training classes, which can be taken from any location.

Hands On Training that Works!

Adults learn by doing.  This is why over 50% of each course incorporates hands-on learning.  Students will work on labs and projects that will help them learn by using the software.  Our curriculum is all developed in house.

See What Our Customers Say