Increase the Efficiency and Productivity of Your Data Team
with Our Onsite or Remote Training Workshops
Our Training Benefits You
The BI School Ltd specialises in delivering comprehensive and personalised SQL training that empowers individuals and businesses to excel in their data roles. Unlike generic online courses, we offer a unique blend of group workshops and dedicated one-on-one mentorship. With over 20 years of industry experience, we ensure that every learner receives the guidance and support needed to master SQL and achieve their personal and organisational goals.
Give your team of data heroes the skills they deserve to excel in their current and future roles. Empower them in their careers by offering them the gift of advanced SQL knowledge.
We don’t just teach SQL. We go above and beyond to support our learners in their development with bespoke support packages, to build a strong foundation of ability.
A successful, effective, efficient and productive data team reflects well on YOU as their leader. The quality of their work output is a direct reflection on the quality of the person in charge.
Equip your data and analytics team with the skills they need to excel. Improved SQL skills lead to better data management, more insightful reports, and more effective decision-making.
Studies have comprehensively shown that when you invest in your people, they are more likely to reward you with a positive attitude, effort and loyalty.
Extracting data from a SQL database with basic SELECT statements
Filtering your data with the WHERE clause using wildcards & complex commands
Using table joins for working with data from all across the database
Sorting and limiting data results
Manipulating text data
Numeric calculations & data types
Working with NULL (empty) values
Date functions for generating dynamic time periods such as year to date or previous month
IF, THEN, ELSE logic with the CASE statement
Grouping and summarising data
Combining results from multiple queries with UNION
Subqueries and derived tables (queries within queries)
Using CTEs to simplify your SQL queries
Views
Using window functions for analysis
Getting to know your working environment
Understanding how data in a database is related
Table design including naming conventions, data types and constraints.
Two day workshop delivered on site in your place of work.
You book a meeting room, invite the delegates and we’ll do the rest.
The sessions usually run from around 9.30 until 4pm, but we’ll fit it around you.
Two day workshop delivered on remotely, so your team can work at their desks, or from home.
However, experience shows that sometimes it works better when everyone’s together in a meeting room – no distractions means greater focus!
Get access to a suite of carefully curated video tutorials designed to take you through the training in simple steps.
We’ll have a weekly get-together to answer questions and review code, and to set expectations for the next week (usually to complete two videos).
We also offer ongoing support options to keep your team on track long after the formal training is complete.
This can be discussed on your consultation call.
Book a call today to discuss your requirements.
