The Knowledge Academy Logo
01344 203999
  24 Hours Monday - Sunday
Empty
X

Send us your message.
We'll get back to you as soon as we can.

Please enter Name Please enter valid Email Please enter valid Phone number

Classroom Training

At The Knowledge Academy, our classroom-based training courses allow delegates to study and learn in a friendly, engaging, and interactive environment. We ensure the very best level of teaching, with first-rate instructors, resources, and state-of-the-art facilities. We provide courses of varying durations and can arrange weekend and residential courses in order to suit your requirements.

Furthermore, our classroom courses are carried out in thousands of locations worldwide, making training easily accessible wherever you are. Our courses typically begin at 9.00 am and continue until 5.00 pm each day, with breaks and refreshments provided. , As our most popular form of training available, we pride ourselves in continuously delivering an outstanding learning experience for our delegates in the classroom.

View classroom dates
  • Direct support from our experienced trainers throughout the course
  • Training courses available in thousands of locations globally
  • Partake in engaging and valuable activities in the classroom to boost your learning potential
  • Receive an all-encompassing learning experience

Online Training

Our online-based training courses aim to provide you with a complete training experience. Due to their flexibility, these courses are greatly suited to busy working professionals, or any individual who would prefer the convenience of an online training course.

Our Computer-Based Training (CBT) courses remove the time and cost associated with travelling to course locations. You can complete your chosen course in any location, and work at your own pace, as the learning portal can be accessed 24/7. All of our online training courses have technical and administrative support and mobile access. Furthermore, each course has been carefully designed to incorporate informative, instructive, and engaging content. In this way, online learning can guarantee a valuable and enjoyable training solution.

View online prices
  • Our flexible online courses provide you with 24/7 access
  • Take your time with 90 days from first login to complete the course
  • Enjoy an engaging and interactive learning experience
  • Courses available through our easy-to-use learning portal

In-House Training

Our In-House training option allows you to select any of our courses and receive training at a venue of your choice, by any method of your choice.

In-House courses deliver training to multiple employees at once, thus reducing travel expenses and providing you with the ultimate convenience and value for money. In addition, this option allows you to receive a training course that has been specifically tailored to meet your business needs, ensuring first-class quality, applicability, and value.

By choosing to bring bespoke training to the office, you can improve business performance, and make your organisation more streamlined, resourceful, and profitable. With over 25 years’ of experience, we are the market-leaders of In-House training.

Book onsite
  • Reduce the costs of employees taking time away from the workplace to train
  • Streamline your business with this bespoke training solution
  • Maximise your training budget
  • Monitor your employees’ progress and ensure that they receive applicable qualifications

Virtual Training

Our Virtual training courses provide you with the option to learn using a specialised simulated virtual environment. In this environment, our expert training instructors will be able to convey information and provide you with the all the knowledge you require to earn your qualification with The Knowledge Academy. As the largest global training provider, this method of training allows us to extend our training scope to those who may not be able to attend a classroom course itself, but would like to receive direct training and support from an instructor.
Using this training delivery method, you would benefit from the convenience of remote access and the elimination of the time and cost associated with travelling to a training venue.

View virtual dates
  • Receive direct support from our experienced trainers
  • Acquire the benefits of a classroom course, without the need to travel
  • Train from the comfort of your own home using remote access
  • All virtual training courses come with technical and administrative support
X
Microsoft Technical

Querying Data With Transact-SQL (M20761)

  • Microsoft Silver Learning Partner, therefore fully accredited training
  • Prepare for the Microsoft 70-761 examination
  • Exam guidance, course materials and pre & post course support provided
Popular Course
Accredited:YesAccrediting body: Enquire See Prices From £449

Page Menu

Course Information

Querying Data with Transact-SQL Outline

Module 1: 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 Tools

    • Working with SQL Server Management Studio

    • Creating and Organizing T-SQL Scripts

    • Using Books Online

 

Module 2: Introduction to T-SQL Querying

  • Introducing T-SQL

  • Understanding Sets

  • Writing Queries

  • 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

 

Module 3: Writing SELECT Queries

  • Writing Simple SELECT Statements

  • Eliminating Duplicates with DISTINCT

  • Using Column and Table Aliases

  • Writing Simple CASE Expressions

  • Lab: Writing Basic SELECT Statements

    • Writing Simple SELECT Statements

    • Eliminating Duplicates Using DISTINCT

    • Using Column and Table Aliases

    • Using a Simple CASE Expression

 

Module 4: Querying Multiple Tables

  • Understanding the Fundamentals of Joins

  • Querying with Inner Joins

  • Querying with Outer Joins

  • Querying with Cross Joins and Self Joins

  • Lab: Querying Multiple Tables

    • Writing Queries that use Inner Joins

    • Writing Queries that use Multiple-Table Inner Joins

    • Writing Queries that use Self-Joins

    • Writing Queries that use Outer Joins

    • Writing Queries that use Cross Joins

 

Module 5: Sorting and Filtering Data

  • Sorting Data

  • Filtering Data with Predicates

  • Filtering Data with TOP and OFFSET-FETCH

  • Working with Unknown Values

  • Lab: Sorting and Filtering Data

    • Writing Queries that Filter Data using a WHERE Clause

    • Writing Queries that Sort Data Using an ORDER BY Clause

    • Writing Queries that Filter Data Using the TOP Option

 

Module 6: Working with SQL Server 2016 Data Types

  • Introducing SQL Server 2016 Data Types

  • Working with Character Data

  • Working with Date and Time Data

  • Lab: Working with SQL Server 2016 Data Types

    • Writing Queries that Return Date and Time Data

    • Writing Queries that use Date and Time Functions

    • Writing Queries That Return Character Data

    • Writing Queries That Return Character Functions

 

Module 7: Using DML to Modify Data

  • Inserting Data

  • Creating DML Queries

  • Modifying and Deleting Data

  • Lab: Using DML to Modify Data

    • Inserting Data

    • Updating, Merging, and Deleting Data

 

Module 8: Using Built-In Functions

  • Writing Queries with Built-In Functions

  • Using Conversion Functions

  • Using Logical Functions

  • Using Functions to Work with NULL

  • Lab: Using Built-In Functions

    • Writing Queries That Use Conversion Functions

    • Writing Queries that use Logical Functions

    • Writing Queries that Test for Nullability

 

Module 9: Grouping and Aggregating Data

  • Using Aggregate Functions

  • Using the GROUP BY Clause

  • Filtering Groups with HAVING

  • Lab: Grouping and Aggregating Data

    • Writing Queries That Use the GROUP BY Clause

    • Writing Queries that Use Aggregate Functions

    • Writing Queries that Use Distinct Aggregate Functions

    • Writing Queries that Filter Groups with the HAVING Clause

 

Module 10: Using Subqueries

  • Writing Self-Contained Subqueries

  • Writing Correlated Subqueries

  • Using the EXISTS Predicate with Subqueries

  • Lab: Using Subqueries

    • Writing Queries That Use Self-Contained Subqueries

    • Writing Queries That Use Scalar and Multi-Result Subqueries

    • Writing Queries That Use Correlated Subqueries and an EXISTS Clause

 

Module 11: Using Table Expressions

  • Using Views

  • Using Inline Table-Valued Functions (TVFs)

  • Using Derived Tables

  • Using Common Table Expressions (CTEs)

  • Lab: Using Table Expressions

    • Writing Queries That Use Views

    • Writing Queries That Use Derived Tables

    • Writing Queries That Use Common Table Expressions (CTEs)

    • Writing Queries That Sue Inline Table-Valued Expressions

 

Module 12: Using Set Operators

  • Writing Queries with the UNION operator

  • Using EXCEPT and INTERSECT

  • Using APPLY

  • Comparing Rows Between Two Input Sets

  • Lab: Using Set Operators

    • Writing Queries That Use UNION Set Operators and UNION ALL

    • Writing Queries That Use CROSS APPLY and OUTER APPLY Operators

    • Writing Queries That Use the EXCEPT and INTERSECT Operators

 

Module 13: Using Windows Ranking, Offset, and Aggregate Functions

  • Benefits of Window Functions

  • Restricting Window Functions

  • Creating Windows with OVER

  • Exploring Window Functions

  • Lab: Using Windows Ranking, Offset, and Aggregate Functions

    • Writing Queries that use Ranking Functions

    • Writing Queries that use Offset Functions

    • Writing Queries that use Window Aggregate Functions

 

Module 14: Pivoting and Grouping Sets

  • Writing Queries with PIVOT and UNPIVOT

  • Working with Grouping Sets

  • Lab: Pivoting and Grouping Sets

    • Writing Queries that use the PIVOT Operator

    • Writing Queries that use the UNPIVOT Operator

    • Writing Queries that use the GROUPING SETS CUBE and ROLLUP Subclauses

 

Module 15: Executing Stored Procedures

  • Querying Data with Stored Procedures

  • Passing Parameters to Stored procedures

  • Creating Simple Stored Procedures

  • Working with Dynamic SQL

  • Lab: Executing Stored Procedures

    • Using the EXECUTE statement to Invoke Stored Procedures

    • Passing Parameters to Stored procedures

    • Executing System Stored Procedures

 

Module 16: Programming with T-SQL

  • T-SQL Programming Elements

  • Controlling Program Flow

  • Lab: Programming with T-SQL

    • Declaring Variables and Delimiting Batches

    • Using Control-Of-Flow Elements

    • Using Variables in a Dynamic SQL Statement

    • Using Synonyms

 

Module 17: Implementing Error Handling

  • Implementing T-SQL error handling

  • Implementing structured exception handling

  • Lab: Implementing Error Handling

    • Redirecting errors with TRY/CATCH

    • Using THROW to pass an error message back to a client

 

Module 18: Implementing Transactions

  • Transactions and the Database Engines

  • Controlling Transactions

  • Lab: Implementing Transactions

    • Controlling transactions with BEGIN, COMMIT, and ROLLBACK

    • Adding error handling to a CATCH block

Back to top

Querying Data with Transact-SQL Overview

This 5 day Microsoft Querying Data with Transact-SQL training course provides delegates with an introduction to Transact-SQL. The first 3 days take the form of classroom teaching whereby candidates acquire the knowledge needed to complete more SQL Server courses. The final 2 days focus more on the exam, developing the skills needed to complete it successfully. Delegates will understand Transact-SQL language adopted by those within SQL Server disciplines.

 

They will be taught the fundamentals of Transact-SQL, how to write queries, how to sort data, and the process of executing procedures. By the end of this training course, delegates will be ready to complete and pass the Querying Data with Transact-SQL 70-761 examination.

Back to top

Who should attend?

Querying Data with Transact-SQL M20761 is designed for those within SQL Server-related roles, predominantly Database Administrators, Database Developers, and Business Intelligence professionals.

 

Prerequisites

Delegates should possess knowledge of:

  • Relational databases

  • The Microsoft Windows operating system

Querying Data with Transact-SQL Examination

The exam associated with this course is the Querying Data with Transact-SQL 70-761 examination, which will cover the following areas:

  • Managing Data with Transact-SQL

  • Querying Data with Advanced Transact-SQL Components

  • Programming Databases by Using Transact-SQL

 

Delegates will need to sign a non-disclosure exam agreement, which states that they will not share information relating to the exam structure with anyone. 

Available delivery methods for this course:

Classroom

In-house

Online

Virtual

Upcoming classes

Speak to a member of our team

Call now

01344 203999 >

Or

Enquire Now

Dates & Prices for Querying Data with Transact-SQL (M20761)

Select your preferred delivery method

Filter your results

Why choose Virtual?

Attend your course from the office or home
Interactive support from experienced trainers
Simple to setup and easy to use on any device

Complete the steps below to receive a quote or more information

How will you be funding your training?

Self funding

Company funding

Not sure

Speak to a member of our team

Call now

01344 203999 >

Or

Enquire Now

Best Price in the Industry

We have the guaranteed best price for our courses in the industry

Trusted & Approved

Microsoft Silver Learning Partner

Resources Included

Resources are included for a comprehensive learning experience

Various Delivery Methods

Flexible delivery methods are available depending on your learning style


Querying Data with Transact-SQL (M20761) FAQs

Delegates will need to take the Querying Data with Transact-SQL 70-761 examination. The exam is not included with the training course and must be taken separately.
Querying Data with Transact-SQL is a 5 day training course.
Querying Data with Transact-SQL will start at 9am and end at 5pm each day. Delegates should arrive at the venue by 8:45am.
No, however you will need to possess some knowledge of relational databases and Microsoft Windows operating systems.

Some of our clients

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."

Diane Gray, Shell


Back to top

Trustpilot

TICK, TOCK

Grab your deals before they run out
First come, first served!