Querying Data with Transact-SQL Training Course (Exam 70-761)

20761C:Querying Data with Transact-SQL 2016 Certification Training Course Overview

The SQL 2016 Querying course 20761 aims to impart skills on writing queries for Transact-SQL language. This SQL 2016 Querying certification training is the basic foundation for SQL Server-related disciplines such as Database Administration, Business Intelligence and Database Development. The course teaches participants how to select, sort and filter data from multiple tables and how to use stored procedures and views.

The primary audience for this T-SQL training is database administrators, business intelligence professionals, database developers etc. This T-SQL certification course can also be attended by non-technical power users such as business analysts, report writers, and client application developers.

Test your current knowledge Qubits42

Querying Data with Transact-SQL Training Course (Exam 70-761) (Duration : 40 Hours) Download Course Contents

Live Virtual Classroom
Group Training 1800

21 - 25 Jun
09:00 AM - 05:00 PM CST
(8 Hours/Day)

05 - 09 Jul
09:00 AM - 05:00 PM CST
(8 Hours/Day)

02 - 06 Aug
09:00 AM - 05:00 PM CST
(8 Hours/Day)

GTR=Guaranteed to Run
1-on-1 Training (GTR) 2050
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request

Special Solutions for Corporate Clients! Click here

Hire Our Trainers! Click here

Course Modules

  • Lesson 1: The Basic Architecture of SQL Server
  • Lesson 2: SQL Server Editions and Versions
  • Lesson 3: Getting Started with SQL Server Management Studio
  • Lab: Working with SQL Server 2016 Tools
  • Lesson 1: Introducing T-SQL
  • Lesson 2: Understanding Sets
  • Lesson 3: Understanding Predicate Logic
  • Lesson 4: Understanding the Logical Order of Operations in SELECT Statements
  • Lab: Introduction to T-SQL Querying
  • Lesson 1: Writing Simple SELECT Statements
  • Lesson 2: Eliminating Duplicates with DISTINCT
  • Lesson 3: Using Column and Table Aliases
  • Lesson 4: Writing Simple CASE Expressions
  • Lab: Writing Basic SELECT Statements
  • Lesson 1: Understanding Joins
  • Lesson 2: Querying with Inner Joins
  • Lesson 3: Querying with Outer Joins
  • Lesson 4: Querying with Cross Joins and Self Joins
  • Lab: Querying Multiple Tables
  • Lesson 1: Sorting Data
  • Lesson 2: Filtering Data with Predicates
  • Lesson 3: Filtering Data with TOP and OFFSET-FETCH
  • Lesson 4: Working with Unknown Values
  • Lab: Sorting and Filtering Data
  • Lesson 1: Introducing SQL Server 2016 Data Types
  • Lesson 2: Working with Character Data
  • Lesson 3: Working with Date and Time Data
  • Lab: Working with SQL Server 2016 Data Types
  • Lesson 1: Adding Data to Tables
  • Lesson 2: Modifying and Removing Data
  • Lesson 3: Generating Automatic Column Values
  • Lab: Using DML to Modify Data
  • Lesson 1: Writing Queries with Built-In Functions
  • Lesson 2: Using Conversion Functions
  • Lesson 3: Using Logical Functions
  • Lesson 4: Using Functions to Work with NULL
  • Lab: Using Built-in Functions
  • Lesson 1: Using Aggregate Functions
  • Lesson 2: Using the GROUP BY Clause
  • Lesson 3: Filtering Groups with HAVING
  • Lab: Grouping and Aggregating
  • Lesson 1: Writing Self-Contained Subqueries
  • Lesson 2: Writing Correlated Subqueries
  • Lesson 3: Using the EXISTS Predicate with Subqueries
  • Lab: Using Subqueries
  • Lesson 1: Using Views
  • Lesson 2: Using Inline TVFs
  • Lesson 3: Using Derived Tables
  • Lesson 4: Using CTEs
  • Lab: Using Table Expressions
  • Lesson 1: Writing Queries with the UNION Operator
  • Lesson 2: Using EXCEPT and INTERSECT
  • Lesson 3: Using APPLY
  • Lab: Using Set Operators
  • Lesson 1: Creating Windows with OVER
  • Lesson 2: Exploring Window Functions
  • Lab: Using Window Ranking, Offset, and Aggregate Functions
  • Lesson 1: Writing Queries with PIVOT and UNPIVOT
  • Lesson 2: Working with Grouping Sets
  • Lab: Pivoting and Grouping Sets
  • Lesson 1: Querying Data with Stored Procedures
  • Lesson 2: Passing Parameters to Stored Procedures
  • Lesson 3: Creating Simple Stored Procedures
  • Lesson 4: Working with Dynamic SQL
  • Lab: Executing Stored Procedures
  • Lesson 1: T-SQL Programming Elements
  • Lesson 2: Controlling Program Flow
  • Lab: Programming with T-SQL
  • Lesson 1: Implementing T-SQL Error Handling
  • Lesson 2: Implementing Structured Exception Handling
  • Lab: Implementing Error Handling
  • Lesson 1: Transactions and the Database Engine
  • Lesson 2: Controlling Transactions
  • Lab: Implementing Transactions

Request More Information

Course Prerequisites

  • Basic knowledge of relational databases.

Upon Completion of this Course, you will accomplish following:-

  • 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.

Give an edge to your career with Microsoft certification training courses. Students can join the classes for 20761 : Querying Data with Transact-SQL ( SQL 2016) at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

Student Feedback  (Check Koenig Feedback on Trustpilot)

Q1 Say something about the Trainer? Q2 How is Koenig different from other training Companies? Q3 Will you come back to Koenig for training ?

Student Name Country Month Feedback Rating
Lars Schlaepfer Netherlands Apr-2019 https://www.youtube.com/watch?v=m3K9HAXwS4w
michael essandoh-sam Ghana Nov-2019 https://youtu.be/nNUXfS1uzGo