The Knowledge Academy Logo
The Knowledge Academy Logo
01344 203999 - Available 24/7

Remember: All of our classroom courses are available as live instructor-led training which you can attend from home.

Remember: All of our classroom courses are available as live instructor-led training which you can attend from home.

Send us your message.

X

Send us your message.

X

Our sales and enquiry team will get back to you as soon as possible

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

The information you provide shall be processed by The Knowledge Academy – a professional training company. Your data shall be used by a member of staff to contact you regarding your enquiry.

Please click here for privacy policy.

We cannot process your enquiry without contacting you, please tick to confirm you consent to us contacting you about your enquiry

Send us your message.

X

Our sales and enquiry team will get back to you as soon as possible

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

The information you provide shall be processed by The Knowledge Academy – a professional training company. Your data shall be used by a member of staff to contact you regarding your enquiry.

Please click here for privacy policy.

We cannot process your enquiry without contacting you, please tick to confirm you consent to us contacting you about your enquiry

Send us your message.

X

Our sales and enquiry team will get back to you as soon as possible

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

The information you provide shall be processed by The Knowledge Academy – a professional training company. Your data shall be used by a member of staff to contact you regarding your enquiry.

Please click here for privacy policy.

We cannot process your enquiry without contacting you, please tick to confirm you consent to us contacting you about your enquiry

Querying Data With Transact-SQL M20761 - United Kingdom

Key points about this course


Duration: 5 Days*

Accredited: Yes

Support: 24/7

Dates & Prices Enquire
  • 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

Available delivery methods for this course

Virtual Icon

Online Instructor-Led

Online Icon

Online Self-Paced

Onsite Icon

Onsite

Classroom Icon

Classroom

Limited Budget?

We understand that people may have limited budgets.

  • To help and support our clients we will provide limited number of 250 daily discount codes.
  • Hurry first come, first served!
  • If you miss out, enquire to get yourself on the waiting list for the next day!

animated-arrow-image-0310 Enquire for daily discount code 359 Remaining (Live Counter)

Why Home Virtual is great

With an incredibly easy to use interface, our chosen platform has been designed to make learning online simple and enjoyable. It’s amazing video & audio quality means you won’t miss a thing.

icon

Works on all devices

Attend on whichever device works best for you.
icon

Recording & transcripts

Revisit what you’ve learnt at any time.
icon

See your trainer’s screen

Your instructor can share their screen at any time to demonstrate what they’re teaching.
icon

Share documents

You can share documents with the trainer and your trainer can share with you.
icon

Virtual whiteboard

Trainers can draw on and share their whiteboard with the class at any time.
static

Key points about this course


Duration: 5 Days*

Accredited: Yes

Support: 24/7

View dates & prices

Find out more

Please enter Name
Please enter valid Email
Please enter valid phone
The information you provide shall be processed by The Knowledge Academy – a professional training company. Your data shall be used by a member of staff to contact you regarding your enquiry. View privacy policy

We cannot process your enquiry without contacting you, please tick to confirm you consent to us contacting you about your enquiry

Or call us now
01344 203999

Course Packages & Certifications

MCSA: SQL 2016 Database Development CertificationSave 27%

2 courses

Querying Data with Transact-SQL M20761

£1495Book now

Developing SQL Databases M20762

£1495Book now

Total:

£2990Savings

Package Price:

£2195£795

This package usually costs £2990, why not book together and save £795
Most people buy as a package!

Querying Data With Transact-SQL M20761 Dates & Prices

Select your preferred delivery method

Choose a Region

Choose a Location

Choose a Month

Office Icon All Online Instructor-Led courses are delivered in real-time
Trainers Icon Easy 1 click access
Simple Icon Works on all devices
Edinburgh
Mon 20th Jul 2020
Places available
£3995
Birmingham
Mon 20th Jul 2020
Places available
£2995
Brighton
Mon 20th Jul 2020
Places available
£3995
Mon 20th Jul 2020
Places available
Was: £2295
Now: £1495
Maidstone
Mon 20th Jul 2020
Places available
£3995
Leeds
Mon 27th Jul 2020
Places available
£3995
Mon 27th Jul 2020
Places available
Was: £2295
Now: £1495
Milton Keynes
Mon 27th Jul 2020
Places available
£3995
Liverpool
Mon 27th Jul 2020
Places available
£3995
Newcastle
Mon 3rd Aug 2020
Places available
£3995
Mon 3rd Aug 2020
Places available
Was: £2295
Now: £1495
Sheffield
Mon 3rd Aug 2020
Places available
£3995
Bristol
Mon 3rd Aug 2020
Places available
£3995
Manchester
Mon 3rd Aug 2020
Places available
£2995
Cardiff
Mon 10th Aug 2020
Places available
£3995
Glasgow
Mon 10th Aug 2020
Places available
£3995
London
Mon 10th Aug 2020
Places available
£2995
Mon 10th Aug 2020
Places available
Was: £2295
Now: £1495
Cambridge
Mon 17th Aug 2020
Places available
£3995
Edinburgh
Mon 17th Aug 2020
Places available
£3995
Birmingham
Mon 17th Aug 2020
Places available
£2995
Mon 17th Aug 2020
Places available
Was: £2295
Now: £1495
Mon 24th Aug 2020
Places available
Was: £2295
Now: £1495
Reading
Mon 24th Aug 2020
Places available
£3995
Norwich
Mon 24th Aug 2020
Places available
£3995
Aberdeen
Mon 24th Aug 2020
Places available
£3995
Leeds
Mon 24th Aug 2020
Places available
£3995
Tue 1st Sep 2020
Places available
Was: £2295
Now: £1495
Mon 7th Sep 2020
Places available
Was: £2295
Now: £1495
Bristol
Mon 7th Sep 2020
Places available
£3995
Manchester
Mon 7th Sep 2020
Places available
£2995
Southampton
Mon 7th Sep 2020
Places available
£3995
Dublin
Mon 7th Sep 2020
Places available
€3995
Belfast
Mon 14th Sep 2020
Places available
£3995
Glasgow
Mon 14th Sep 2020
Places available
£3995
London
Mon 14th Sep 2020
Places available
£2995
Nottingham
Mon 14th Sep 2020
Places available
£3995
Mon 14th Sep 2020
Places available
Was: £2295
Now: £1495
Brighton
Mon 21st Sep 2020
Places available
£3995
Maidstone
Mon 21st Sep 2020
Places available
£3995
Mon 21st Sep 2020
Places available
Was: £2295
Now: £1495
Edinburgh
Mon 21st Sep 2020
Places available
£3995
Birmingham
Mon 21st Sep 2020
Places available
£2995
Milton Keynes
Mon 28th Sep 2020
Places available
£3995
Leeds
Mon 28th Sep 2020
Places available
£3995
Liverpool
Mon 28th Sep 2020
Places available
£3995
Mon 28th Sep 2020
Places available
Was: £2295
Now: £1495
Sheffield
Mon 5th Oct 2020
Places available
£3995
Bristol
Mon 5th Oct 2020
Places available
£3995
Manchester
Mon 5th Oct 2020
Places available
£2995
Mon 5th Oct 2020
Places available
Was: £2295
Now: £1495
Newcastle
Mon 5th Oct 2020
Places available
£3995
Mon 12th Oct 2020
Places available
Was: £2295
Now: £1495
Glasgow
Mon 12th Oct 2020
Places available
£3995
London
Mon 12th Oct 2020
Places available
£2995
Cardiff
Mon 12th Oct 2020
Places available
£3995
Birmingham
Mon 19th Oct 2020
Places available
£2995
Mon 19th Oct 2020
Places available
Was: £2295
Now: £1495
Edinburgh
Mon 19th Oct 2020
Places available
£3995
Cambridge
Mon 19th Oct 2020
Places available
£3995
Reading
Mon 26th Oct 2020
Places available
£3995
Leeds
Mon 26th Oct 2020
Places available
£3995
Norwich
Mon 26th Oct 2020
Places available
£3995
Aberdeen
Mon 26th Oct 2020
Places available
£3995
Mon 26th Oct 2020
Places available
Was: £2295
Now: £1495
Southampton
Mon 2nd Nov 2020
Places available
£3995
Mon 2nd Nov 2020
Places available
Was: £2295
Now: £1495
Bristol
Mon 2nd Nov 2020
Places available
£3995
Manchester
Mon 2nd Nov 2020
Places available
£2995
Glasgow
Mon 9th Nov 2020
Places available
£3995
London
Mon 9th Nov 2020
Places available
£2995
Mon 9th Nov 2020
Places available
Was: £2295
Now: £1495
Nottingham
Mon 9th Nov 2020
Places available
£3995
Edinburgh
Mon 16th Nov 2020
Places available
£3995
Brighton
Mon 16th Nov 2020
Places available
£3995
Birmingham
Mon 16th Nov 2020
Places available
£2995
Mon 16th Nov 2020
Places available
Was: £2295
Now: £1495
Leeds
Mon 23rd Nov 2020
Places available
£3995
Mon 23rd Nov 2020
Places available
Was: £2295
Now: £1495
Milton Keynes
Mon 23rd Nov 2020
Places available
£3995
Dublin
Mon 23rd Nov 2020
Places available
€3995
Liverpool
Mon 30th Nov 2020
Places available
£3995
Maidstone
Mon 30th Nov 2020
Places available
£3995
Belfast
Mon 30th Nov 2020
Places available
£3995
Mon 30th Nov 2020
Places available
Was: £2295
Now: £1495
Mon 7th Dec 2020
Places available
Was: £2295
Now: £1495
Newcastle
Mon 7th Dec 2020
Places available
£3995
Bristol
Mon 7th Dec 2020
Places available
£3995
Cambridge
Mon 7th Dec 2020
Places available
£3995
Manchester
Mon 7th Dec 2020
Places available
£2995
Edinburgh
Mon 7th Dec 2020
Places available
£3995
Sheffield
Mon 7th Dec 2020
Places available
£3995
London
Mon 7th Dec 2020
Places available
£2995
Birmingham
Mon 14th Dec 2020
Places available
£2995
Cardiff
Mon 14th Dec 2020
Places available
£3995
Norwich
Mon 14th Dec 2020
Places available
£3995
Aberdeen
Mon 14th Dec 2020
Places available
£3995
Mon 14th Dec 2020
Places available
Was: £2295
Now: £1495
Glasgow
Mon 14th Dec 2020
Places available
£3995
Leeds
Mon 14th Dec 2020
Places available
£3995
Reading
Mon 14th Dec 2020
Places available
£3995
Mon 21st Dec 2020
Places available
Was: £2295
Now: £1495
Mon 28th Dec 2020
Places available
Was: £2295
Now: £1495
Nottingham
Mon 4th Jan 2021
Places available
£3995
Bristol
Mon 4th Jan 2021
Places available
£2295
Leeds
Mon 11th Jan 2021
Places available
£2295
Cardiff
Mon 11th Jan 2021
Places available
£3995
Norwich
Mon 18th Jan 2021
Places available
£3995
Southampton
Mon 18th Jan 2021
Places available
£3995
Glasgow
Mon 25th Jan 2021
Places available
£2295
Newcastle
Mon 25th Jan 2021
Places available
£3995
Belfast
Mon 1st Feb 2021
Places available
£3995
London
Mon 1st Feb 2021
Places available
£2295
Maidstone
Mon 8th Feb 2021
Places available
£3995
Manchester
Mon 8th Feb 2021
Places available
£2295
Birmingham
Mon 15th Feb 2021
Places available
£2295
Dublin
Mon 15th Feb 2021
Places available
€3995
Milton Keynes
Mon 22nd Feb 2021
Places available
£2295
Sheffield
Mon 22nd Feb 2021
Places available
£3995
Cambridge
Mon 1st Mar 2021
Places available
£3995
Liverpool
Mon 1st Mar 2021
Places available
£3995
Aberdeen
Mon 8th Mar 2021
Places available
£3995
Reading
Mon 8th Mar 2021
Places available
£2295
London
Mon 15th Mar 2021
Places available
£2295
Brighton
Mon 15th Mar 2021
Places available
£3995
Edinburgh
Mon 22nd Mar 2021
Places available
£2295
Manchester
Mon 12th Apr 2021
Places available
£2295
Southampton
Mon 12th Apr 2021
Places available
£3995
Birmingham
Mon 19th Apr 2021
Places available
£2295
Leeds
Mon 19th Apr 2021
Places available
£2295
Glasgow
Mon 26th Apr 2021
Places available
£2295
Bristol
Mon 26th Apr 2021
Places available
£2295
London
Mon 10th May 2021
Places available
£2295
Milton Keynes
Mon 10th May 2021
Places available
£2295
Edinburgh
Mon 17th May 2021
Places available
£2295
Norwich
Mon 17th May 2021
Places available
£3995
Belfast
Mon 24th May 2021
Places available
£3995
Cardiff
Mon 24th May 2021
Places available
£3995
London
Mon 7th Jun 2021
Places available
£2295
Newcastle
Mon 14th Jun 2021
Places available
£3995
Nottingham
Mon 14th Jun 2021
Places available
£3995
Leeds
Mon 21st Jun 2021
Places available
£2295
Birmingham
Mon 21st Jun 2021
Places available
£2295
Manchester
Mon 28th Jun 2021
Places available
£2295
Reading
Mon 28th Jun 2021
Places available
£2295
Aberdeen
Mon 5th Jul 2021
Places available
£3995
Brighton
Mon 5th Jul 2021
Places available
£3995
Cambridge
Mon 12th Jul 2021
Places available
£3995
Maidstone
Mon 12th Jul 2021
Places available
£3995
London
Mon 19th Jul 2021
Places available
£2295
Glasgow
Mon 26th Jul 2021
Places available
£2295
Bristol
Mon 26th Jul 2021
Places available
£2295
Liverpool
Mon 2nd Aug 2021
Places available
£3995
Birmingham
Mon 9th Aug 2021
Places available
£2295
Sheffield
Mon 9th Aug 2021
Places available
£3995
Milton Keynes
Mon 16th Aug 2021
Places available
£2295
Edinburgh
Mon 16th Aug 2021
Places available
£2295
Dublin
Mon 23rd Aug 2021
Places available
€3995
Manchester
Mon 23rd Aug 2021
Places available
£2295
Southampton
Mon 6th Sep 2021
Places available
£3995
London
Mon 13th Sep 2021
Places available
£2295
Belfast
Mon 13th Sep 2021
Places available
£3995
Reading
Mon 20th Sep 2021
Places available
£2295
Norwich
Mon 20th Sep 2021
Places available
£3995
Cardiff
Mon 27th Sep 2021
Places available
£3995
Birmingham
Mon 4th Oct 2021
Places available
£2295
Manchester
Mon 4th Oct 2021
Places available
£2295
Nottingham
Mon 11th Oct 2021
Places available
£3995
Leeds
Mon 11th Oct 2021
Places available
£2295
Newcastle
Mon 18th Oct 2021
Places available
£3995
Aberdeen
Mon 25th Oct 2021
Places available
£3995
London
Mon 25th Oct 2021
Places available
£2295
Maidstone
Mon 1st Nov 2021
Places available
£3995
Bristol
Mon 1st Nov 2021
Places available
£2295
Sheffield
Mon 8th Nov 2021
Places available
£3995
Glasgow
Mon 8th Nov 2021
Places available
£2295
Cambridge
Mon 15th Nov 2021
Places available
£3995
Brighton
Mon 22nd Nov 2021
Places available
£3995
Milton Keynes
Mon 22nd Nov 2021
Places available
£2295
Liverpool
Mon 29th Nov 2021
Places available
£3995
London
Mon 29th Nov 2021
Places available
£2295
Edinburgh
Mon 6th Dec 2021
Places available
£2295
Manchester
Mon 6th Dec 2021
Places available
£2295
Dublin
Mon 13th Dec 2021
Places available
€3995
Birmingham
Mon 20th Dec 2021
Places available
£2295
Reading
Mon 20th Dec 2021
Places available
£2295

Complete the steps below to receive a quote or more information

How will you be funding your training?

Self funding

Company funding

Not sure

Limited Budget?

We understand that people may have limited budgets.

  • To help and support our clients we will provide limited number of 250 daily discount codes.
  • Hurry, they’re first come, first served!
  • If you miss out, enquire to get yourself on the waiting list for the next day!

  Enquire for daily discount code 359  Remaining (Live Counter)

Key points about this course


Duration: 5 Days*

Accredited: Yes

Support: 24/7


Course Information

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.

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

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

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.
Please arrive at the venue at 8:45am.
No, however you will need to possess some knowledge of relational databases and Microsoft Windows operating systems.
The price for Querying Data with Transact-SQL M20761 certification in the United Kingdom starts from £1395
The Knowledge Academy is the Leading global training provider in the world for Querying Data with Transact-SQL M20761.

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. 

Why choose TKA logo


Gold Tag

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

Trusted Icon

Trusted & Approved

Microsoft Silver Learning Partner

Delivery Icon

Various delivery methods

Flexible delivery methods are available depending on your learning style.

Resource Icon

Resources

Resources are included for a comprehensive learning experience.

Thames Water Logo

"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

Google Logo
Samsung Logo
Shell Logo

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

Diane Gray, Shell

hsbc-logo
mercedes-logo