Course Duration
2 Days
Microsoft
Authorized Training
IT
Course cost:
was £3,030
£1,936
IT Certification Overview
This course provides more advanced T-SQL knowledge for those who’ve already attended QATSQL. This is not a beginner’s course, and a foundational knowledge of writing T-SQL queries is required. For those without a basic level of T-SQL for reporting, please complete the QATSQL course first.
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
Participants should have:
- Experience of writing SQL queries using SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, and INNER and OUTER JOIN statements.
Target audience
This course is designed for IT professionals writing queries for use with Microsoft SQL Server from SQL 2005 onwards. Non-technical 'power users' will also benefit from the course if they’re comfortable using sophisticated software tools like SQL Server Management Studio.
Learning Objectives
By the end of this course, learners will be able to:
- Use various table expressions to write queries in a modular way.
- Use advanced forms of GROUP BY, including PIVOT, UNPIVOT, GROUPING SETS, and GROUPING_ID.
- Use window functions to perform ranking operations and to perform comparisons between rows within result sets.
- Use batches, variables, control of flow, loops, conditional operations, and dynamic SQL appropriately.
- Use error handling statements.
- Use transactions and isolation levels in code.
Intermediate Querying SQL Databases using T-SQL Course Content
Using Table Expressions
- This module introduces T-SQL expressions which return a valid relational table, typically for further use in the query. You’ll discuss views, inline table-valued functions, multi-statement table-valued functions, derived tables, common table expressions, and temporary tables.
Pivoting and Advanced Grouping
- This module discusses techniques for pivoting data in T-SQL and introduces fundamentals of the GROUPING SETS clause. It also covers the use of GROUP BY ROLLUP and GROUP BY CUBE syntax in SQL Server.
Window Functions
- This module introduces window functions, including ranking, aggregate, and offset functions. It also covers using T-SQL functions, such as ROW_NUMBER, RANK, DENSE_RANK, NTILE, LAG, LEAD, FIRST_VALUE, and LAST_VALUE, to perform calculations against a set, or window, of rows.
Programming with T-SQL
- This module provides a basic introduction to T-SQL programming concepts and objects. It discusses batches, variables, control of flow elements such as loops and conditional operations, and how to create and execute dynamic SQL statements.
Implementing Error Handling
- This module introduces the use of error handlers in T-SQL code, including the difference between compile errors and run-time errors and how errors affect batches. It also examines how to control error handling using TRY/CATCH blocks, the use of the ERROR class of functions, and the use of the new THROW statement.
Transactions and Isolation Levels
- This module introduces the concepts of transaction management in SQL Server. It provides a high-level overview of transaction properties, covering the basics of marking transactions with BEGIN, COMMIT, and ROLLBACK.
Appendix: Subqueries
- This module is provided for additional post-course reading and gives a brief introduction to the concept of subqueries in SQL.
Appendix: Using Set Operators
- This module is provided for additional post-course reading, and introduces the set operators UNION, INTERSECT, and EXCEPT to compare rows between two input sets, along with the APPLY operator, which can be used to execute a user-defined function against every row returned by a query.
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.
Intermediate Querying SQL Databases using T-SQL Dates
Next 4 available training dates for this course
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
2 DAYS
|
ALL DAY
Thu 26 Mar 2026
AVAILABLE
was £3,030
£1,936
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
2 DAYS
|
ALL DAY
Mon 20 Apr 2026
AVAILABLE
was £3,030
£1,936
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
2 DAYS
|
ALL DAY
Thu 28 May 2026
AVAILABLE
was £3,030
£1,936
OFFER!
BOOK NOW
VIRTUAL
QA On-Line Virtual Centre
2 DAYS
|
ALL DAY
Mon 22 Jun 2026
AVAILABLE
was £3,030
£1,936
Advance Your Career with Intermediate Querying SQL Databases using T-SQL
Gain the skills you need to succeed. Enrol in Intermediate Querying SQL Databases using T-SQL with Newto Training today.