Course Duration
2 Days
Microsoft
Authorized Training
IT
Course cost:
was £2,460
£1,628
IT Certification Overview
This course provides you with the basic knowledge and skills to create queries using Transact-SQL. It will teach you how to select, filter, and sort data, perform aggregations, and use multiple tables.
Newto Training Reviews
What Our Happy Alumni Say About Us
I had absolutely no experience in this field, but Newto Training recognised my potential and supported me every step of the way. The real-life scenarios were invaluable in making me job-ready.
The tutors at Newto are consistently patient, clear and more than willing to help. I couldn't have asked for a better learning environment.
From day one I felt welcomed and supported. The live sessions were interactive and the resources well thought-out. I passed my exam on the first attempt thanks to them.
I was nervous about switching careers but the practical approach and continual 1-to-1 support gave me the confidence I needed to succeed."
The training material was excellent, and the instructors really brought the subject to life with hands-on lab work. I feel fully prepared for the workplace."
What impressed me most was the flexibility and responsiveness of the support team. Whenever I had a question, they were there even outside of normal hours.
The course structure was superb. A great mix of theory and practice delivered at a pace that made sense even for beginners. Highly recommended.
Switching into IT felt overwhelming, but Newto Training made the journey manageable and quite enjoyable. Their coaching style is top class.
I particularly appreciated the way complex topics were broken down into manageable chunks, and the tutor actively encouraged questions at every stage.
The live-taught interactive classes set Newto apart from other providers. It wasn't just video-based learning and the real engagement made all the difference.
The cyber course exceeded my expectations. They've been on hand for everything and are constantly in touch with me
The resources provided were spot on and the teaching style made everything easy to understand. I particularly appreciated the extra help offered when needed.
Enrolling with Newto was one of the best decisions I've made. The job-readiness focus, strong teaching and excellent support all stood out.
I completed my SQL course and now feel confident in my skills. The real-world examples and supportive tutors made it all click.
I've just passed my AZ-900 exam thanks to the support received from Ken in the boot camp and his exam preparation sessions.
I've gained a qualification and the confidence to use it in real-world scenarios.
Their commitment to student success is obvious from the personalised guidance to the quality of delivery. I'd recommend them without hesitation.
Every tutor I encountered was professional, encouraging and keen to see me succeed. That personal touch made a big difference.
I'm now in a role I once thought was out of reach, thank you to the all the team
The bootcamps were excellent, we were given practical projects to complete and I feel so much more confident with my coding skills
I had absolutely no experience in this field, but Newto Training recognised my potential and supported me every step of the way. The real-life scenarios were invaluable in making me job-ready.
The tutors at Newto are consistently patient, clear and more than willing to help. I couldn't have asked for a better learning environment.
From day one I felt welcomed and supported. The live sessions were interactive and the resources well thought-out. I passed my exam on the first attempt thanks to them.
I was nervous about switching careers but the practical approach and continual 1-to-1 support gave me the confidence I needed to succeed."
The training material was excellent, and the instructors really brought the subject to life with hands-on lab work. I feel fully prepared for the workplace."
What impressed me most was the flexibility and responsiveness of the support team. Whenever I had a question, they were there even outside of normal hours.
The course structure was superb. A great mix of theory and practice delivered at a pace that made sense even for beginners. Highly recommended.
Switching into IT felt overwhelming, but Newto Training made the journey manageable and quite enjoyable. Their coaching style is top class.
I particularly appreciated the way complex topics were broken down into manageable chunks, and the tutor actively encouraged questions at every stage.
The live-taught interactive classes set Newto apart from other providers. It wasn't just video-based learning and the real engagement made all the difference.
I had absolutely no experience in this field, but Newto Training recognised my potential and supported me every step of the way. The real-life scenarios were invaluable in making me job-ready.
The tutors at Newto are consistently patient, clear and more than willing to help. I couldn't have asked for a better learning environment.
From day one I felt welcomed and supported. The live sessions were interactive and the resources well thought-out. I passed my exam on the first attempt thanks to them.
I was nervous about switching careers but the practical approach and continual 1-to-1 support gave me the confidence I needed to succeed."
The training material was excellent, and the instructors really brought the subject to life with hands-on lab work. I feel fully prepared for the workplace."
What impressed me most was the flexibility and responsiveness of the support team. Whenever I had a question, they were there even outside of normal hours.
The course structure was superb. A great mix of theory and practice delivered at a pace that made sense even for beginners. Highly recommended.
Switching into IT felt overwhelming, but Newto Training made the journey manageable and quite enjoyable. Their coaching style is top class.
I particularly appreciated the way complex topics were broken down into manageable chunks, and the tutor actively encouraged questions at every stage.
The live-taught interactive classes set Newto apart from other providers. It wasn't just video-based learning and the real engagement made all the difference.
The cyber course exceeded my expectations. They've been on hand for everything and are constantly in touch with me
The resources provided were spot on and the teaching style made everything easy to understand. I particularly appreciated the extra help offered when needed.
Enrolling with Newto was one of the best decisions I've made. The job-readiness focus, strong teaching and excellent support all stood out.
I completed my SQL course and now feel confident in my skills. The real-world examples and supportive tutors made it all click.
I've just passed my AZ-900 exam thanks to the support received from Ken in the boot camp and his exam preparation sessions.
I've gained a qualification and the confidence to use it in real-world scenarios.
Their commitment to student success is obvious from the personalised guidance to the quality of delivery. I'd recommend them without hesitation.
Every tutor I encountered was professional, encouraging and keen to see me succeed. That personal touch made a big difference.
I'm now in a role I once thought was out of reach, thank you to the all the team
The bootcamps were excellent, we were given practical projects to complete and I feel so much more confident with my coding skills
The cyber course exceeded my expectations. They've been on hand for everything and are constantly in touch with me
The resources provided were spot on and the teaching style made everything easy to understand. I particularly appreciated the extra help offered when needed.
Enrolling with Newto was one of the best decisions I've made. The job-readiness focus, strong teaching and excellent support all stood out.
I completed my SQL course and now feel confident in my skills. The real-world examples and supportive tutors made it all click.
I've just passed my AZ-900 exam thanks to the support received from Ken in the boot camp and his exam preparation sessions.
I've gained a qualification and the confidence to use it in real-world scenarios.
Their commitment to student success is obvious from the personalised guidance to the quality of delivery. I'd recommend them without hesitation.
Every tutor I encountered was professional, encouraging and keen to see me succeed. That personal touch made a big difference.
I'm now in a role I once thought was out of reach, thank you to the all the team
The bootcamps were excellent, we were given practical projects to complete and I feel so much more confident with my coding skills
Prerequisites
There are no technical pre-requisites for this course and it assumes no prior knowledge of SQL Server.
Target audience
This course is designed for IT professionals who write queries for use with Microsoft SQL Server 2005 or later. Non-technical 'power users' will also benefit from the course if they’re comfortable using sophisticated software tools like SQL Server Management Studio.
The course is aimed at both non-technical 'power users' and IT professionals who write queries for use with Microsoft SQL Server.
Learning Objectives
By the end of this course, learners will be able to:
- Use fundamental aspects of the T-SQL language with SQL Server Management Studio (SSMS).
- Use SSMS to write T-SQL to write queries using a single table.
- Use SSMS to write T-SQL queries that use multiple queries with inner and outer joins.
- Apply filters to the output to reduce the number of rows and columns returned.
- Analyse data to return aggregated results using GROUP BY and HAVING.
- Use simple built-in functions to process and convert data.
Querying SQL Databases using T-SQL Course Content
Introduction to T-SQL
- This module provides essential background information on Relational Database Management Systems and Microsoft SQL Server. It introduces the main tool that will be used throughout the course — SQL Server Management Studio.
Retrieving Data
- This module describes the fundamental part of a T-SQL query: the SELECT statement.
Filtering Rows
- This module describes how you can filter unwanted data out of your results using the WHERE clause.
Sorting returned rows
- This module describes how to use the ORDER BY clause of a query to manage the order in which rows are returned.
Grouping and Aggregating data
- This module describes how to use the aggregate functions of SQL to calculate results for a number of records at a time and how to group results into a series of values. Finally, it examines how to filter the grouped values.
Using multiple tables
- This module describes how to use JOIN clauses to retrieve data from multiple tables. It also covers the UNION, INTERSECT, and EXCEPT keywords
Common Functions
- This module introduces you to some of the basic text, date, and null-value manipulation functions that are built in to SQL Server.
Using Views and Stored Procedures
- This module introduces the benefits of using pre-written queries stored in the database.
Appendix : Modifying Data
- This module is provided for additional post-course reading and gives a brief introduction to INSERT, UPDATE, and DELETE statements.
Appendix: Working with Tables
- This module is provided for additional post-course reading and gives a brief introduction into how tables are created, altered, and dropped.
Exams and assessments
There are no formal exams included in this course. Participants will complete interactive labs and knowledge checks to reinforce learning outcomes.
Hands-on learning
This course includes:
- Hands-on labs to apply key concepts in a real-world environment.
Querying SQL Databases using T-SQL Dates
Next 5 available training dates for this course
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
2 DAYS
|
ALL DAY
Mon 23 Feb 2026
LIMITED
was £2,460
£1,628
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
2 DAYS
|
ALL DAY
Fri 20 Mar 2026
AVAILABLE
was £2,460
£1,628
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
2 DAYS
|
ALL DAY
Mon 20 Apr 2026
AVAILABLE
was £2,460
£1,628
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
2 DAYS
|
ALL DAY
Tue 26 May 2026
AVAILABLE
was £2,460
£1,628
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
2 DAYS
|
ALL DAY
Thu 18 Jun 2026
AVAILABLE
was £2,460
£1,628
Advance Your Career with Querying SQL Databases using T-SQL
Gain the skills you need to succeed. Enrol in Querying SQL Databases using T-SQL with Newto Training today.