Expert-led training for your team
T-SQL Training Course

10 August 2022

UK county council supplied with T-SQL training course

A UK county council requested that JBI run a T-SQL training course for their procurement team and in particular the category and contract managers.

Before the pandemic, JBI had run various iterations of the Power BI and Power BI – beyond the basics course for the same county council, building a strong rapport during the on-site training at both the JBI offices and at the county council. Following the return to more normal practices after the pandemic, JBI was recommended to several other departments in the county council including technology services and education services when the entire council had an overhaul to using Power BI. This year the procurement team returned to JBI for T-SQL training to improve the BI strategy of the team by syncing with Power BI. The procurement company wants to use T-SQL script as the source for Power BI reports, getting data from the SQL server and receiving the results in Power BI. T-SQL removes the need to filter data, remove columns or use other steps after importing data. T-SQL also enhances mathematical functions and adds user-defined functions.

In consultation with the county council, JBI created a three day tailor made training course to enhance the learning experience of the group. This involved mixing the “perfect” adventure works SQL data with the county councils own data to improve engagement and understanding of exercises during the course. Furthermore, since the county council data wasn’t perfect, it ensured the delegates worked through problems they would encounter on a daily basis. The course created used certain learning objectives to ensure it was a success:

  • Introduce SQL server and T-SQL
  • Gain an understanding of T-SQL features
  • Learn how to program views, triggers, user-defined function and stored procedures
  • Integrating T-SQL with SQL server
  • Using XML data support

The training course took place virtually on zoom with a distinguished instructor who has been a part of training this county council many times. During the feedback, she always gets fantastic feedback and is a big part of why the council returns to JBI for training:

“I really enjoyed learning with Mariella.  She was supportive and managed course really well despite it being run virtually.  There was lots of information covered over the three days.” CE, Category and Contract assistant manager

“The order in which topics were covered and pacing were excellent. I liked the flexibility to be able to do plenty of exercises to put into practice what we were learning” VK, Category and Supplier Relationship Specialist

For further information on SQL training courses, please see below:

T-SQL training course

SQL training course 

SQL Server Administration training course 

Here are some other articles that may interest you:

T-SQL Training for Government IT System Upgrade

Global intergovernmental organisation receive foundation in OBIEE

About the author: Craig Hartzel
Craig is a self-confessed geek who loves to play with and write about technology. Craig's especially interested in systems relating to e-commerce, automation, AI and Analytics.

+44 (0)20 8446 7555

[email protected]



Copyright © 2023 JBI Training. All Rights Reserved.
JB International Training Ltd  -  Company Registration Number: 08458005
Registered Address: Wohl Enterprise Hub, 2B Redbourne Avenue, London, N3 2BS

Modern Slavery Statement & Corporate Policies | Terms & Conditions | Contact Us


Rust training course                                                                          React training course

Threat modelling training course   Python for data analysts training course

Power BI training course                                   Machine Learning training course

Spring Boot Microservices training course              Terraform training course

Kubernetes training course                                                            C++ training course

Power Automate training course                               Clean Code training course