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 1700
20 - 24 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

04 - 08 Oct 09:00 AM - 05:00 PM CST
(8 Hours/Day)

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

1-on-1 Training (GTR) 2000
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
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

Module 1: Introduction to Microsoft SQL Server 2016
  • 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
Module 2: Introduction to T-SQL Querying
  • 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
Module 3: Writing SELECT Queries
  • 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
Module 4: Querying Multiple Tables
  • 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
Module 5: Sorting and Filtering Data
  • 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
Module 6: Working with SQL Server 2016 Data Types
  • 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
Module 7: Using DML to Modify Data
  • Lesson 1: Adding Data to Tables
  • Lesson 2: Modifying and Removing Data
  • Lesson 3: Generating Automatic Column Values
  • Lab: Using DML to Modify Data
Module 8: Using Built-In Functions
  • 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
Module 9: Grouping and Aggregating Data
  • Lesson 1: Using Aggregate Functions
  • Lesson 2: Using the GROUP BY Clause
  • Lesson 3: Filtering Groups with HAVING
  • Lab: Grouping and Aggregating
Module 10: Using Subqueries
  • Lesson 1: Writing Self-Contained Subqueries
  • Lesson 2: Writing Correlated Subqueries
  • Lesson 3: Using the EXISTS Predicate with Subqueries
  • Lab: Using Subqueries
Module 11: Using Table Expressions
  • Lesson 1: Using Views
  • Lesson 2: Using Inline TVFs
  • Lesson 3: Using Derived Tables
  • Lesson 4: Using CTEs
  • Lab: Using Table Expressions
Module 12: Using Set Operators
  • Lesson 1: Writing Queries with the UNION Operator
  • Lesson 2: Using EXCEPT and INTERSECT
  • Lesson 3: Using APPLY
  • Lab: Using Set Operators
Module 13: Using Window Ranking, Offset, and Aggregate Functions
  • Lesson 1: Creating Windows with OVER
  • Lesson 2: Exploring Window Functions
  • Lab: Using Window Ranking, Offset, and Aggregate Functions
Module 14: Pivoting and Grouping Sets
  • Lesson 1: Writing Queries with PIVOT and UNPIVOT
  • Lesson 2: Working with Grouping Sets
  • Lab: Pivoting and Grouping Sets
Module 15: Executing Stored Procedures
  • 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
Module 16: Programming with T-SQL
  • Lesson 1: T-SQL Programming Elements
  • Lesson 2: Controlling Program Flow
  • Lab: Programming with T-SQL
Module 17: Implementing Error Handling
  • Lesson 1: Implementing T-SQL Error Handling
  • Lesson 2: Implementing Structured Exception Handling
  • Lab: Implementing Error Handling
Module 18: Implementing Transactions
  • Lesson 1: Transactions and the Database Engine
  • Lesson 2: Controlling Transactions
  • Lab: Implementing Transactions
Download Course Contents

Request More Information

Course Prerequisites
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working 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
Reswan Ismail Mozambique Oct-2020 A2. Koenig's professionalism is a great differentiator. Koenig lets students focus as much on their studies as possible, avoiding any kind of distractions. The assistance and support provided by the Training Coordinator - Mrs. Rini Watson and the Training Manager - Mrs. Danica Amor is truly essential. Congratulations for your engagement and professionalism.
michael essandoh-sam Ghana Nov-2019 https://youtu.be/nNUXfS1uzGo
Lars Schlaepfer Netherlands Apr-2019 https://www.youtube.com/watch?v=m3K9HAXwS4w