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

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

The 20761C: Querying Data with Transact-SQL 2016 course is designed to provide learners with the fundamental knowledge and skills necessary to use Transact-SQL effectively for data manipulation within SQL Server. This Transact-SQL course covers a broad range of topics, from basic querying and filtering data to more advanced concepts like error handling and transactions.

Students will become proficient in writing queries, using functions, implementing subqueries, and executing stored procedures. They will also learn to work with various data types and to utilize T-SQL programming elements to control program flow. By the end of the course, those enrolled will be adept at querying data with Transact-SQL, making them valuable assets in database management and data analysis roles. The comprehensive curriculum ensures that students gain practical experience through labs, reinforcing their learning and preparing them for real-world database challenges.

Koenig's Unique Offerings

images-1-1

1-on-1 Training

Schedule personalized sessions based upon your availability.

images-1-1

Customized Training

Tailor your learning experience. Dive deeper in topics of greater interest to you.

images-1-1

4-Hour Sessions

Optimize learning with Koenig's 4-hour sessions, balancing knowledge retention and time constraints.

images-1-1

Free Demo Class

Join our training with confidence. Attend a free demo class to experience our expert trainers and get all your queries answered.

Purchase This Course

2,500

  • Live Online Training (Duration : 40 Hours)
  • Per Participant
  • Guaranteed-to-Run (GTR)
  • date-img
  • date-img

♱ Excluding VAT/GST

Classroom Training price is on request

  • Live Online Training (Duration : 40 Hours)
  • Per Participant

♱ Excluding VAT/GST

Classroom Training price is on request

Request More Information

Email:  WhatsApp:

Winner of the Microsoft’s Asia Superstar Campaign in FY 22

Course Prerequisites

To ensure a fruitful learning experience in the 20761C: Querying Data with Transact-SQL 2016 course, participants should possess the following minimum prerequisites:


  • Basic understanding of relational databases and what they are used for.
  • Familiarity with the concept of a primary key in a database.
  • Fundamental knowledge of Microsoft Windows operating system and its core functionality.
  • Experience with Windows-based programs such as Microsoft Office, and an ability to navigate the Windows environment.
  • Basic understanding of programming concepts such as loops and conditionals is helpful but not mandatory.

Please note that while prior experience with any version of SQL Server is beneficial, it is not a strict requirement to begin this course. The course is designed to introduce the core features and functionality of SQL Server 2016, especially focusing on T-SQL.


Target Audience for 20761C:Querying Data with Transact-SQL 2016

Course 20761C: Querying Data with Transact-SQL 2016 is designed for professionals who need to manage and analyze data with SQL Server.


  • SQL Server Database Administrators
  • Data Analysts
  • Business Intelligence Professionals
  • Database Developers
  • Report Developers
  • IT Professionals who work with data and need querying skills
  • Aspiring Data Professionals
  • Data Scientists who need to interface with SQL Server databases
  • System Engineers who support database systems
  • Technical Consultants who design data solutions for organizations


Learning Objectives - What you will Learn in this 20761C:Querying Data with Transact-SQL 2016?

Introduction to Learning Outcomes:

The 20761C: Querying Data with Transact-SQL course is designed to impart fundamental skills for writing queries, manipulating data, and understanding the core structure of SQL Server 2016.

Learning Objectives and Outcomes:

  • Understand the basic architecture, editions, and tools of SQL Server 2016.
  • Develop proficiency in Transact-SQL (T-SQL) for querying and modifying data.
  • Write SELECT queries to retrieve data efficiently, using various functions and handling duplicates.
  • Master the use of joins to query multiple tables and set operations for complex data retrieval.
  • Learn to sort, filter, and manage SQL data effectively, implementing pagination and working with NULL values.
  • Gain familiarity with SQL Server data types and their appropriate usage within T-SQL.
  • Use Data Manipulation Language (DML) to insert, update, delete, and manage data in a database.
  • Implement built-in scalar and aggregate functions, including conversion and logical functions.
  • Apply subqueries, table expressions, and set operators to structure advanced queries.
  • Utilize window functions for advanced data analysis and understand the concepts of pivoting and grouping sets.
  • Create and execute stored procedures with input and output parameters and handle dynamic SQL.
  • Develop T-SQL programming skills, including control-of-flow elements and error handling mechanisms.
  • Implement robust error handling within T-SQL scripts and manage transactions to ensure data integrity.