SQL Querying Fundamentals

Social Landlords are seeking more effective methods to analyse their data to enhance decision-making and provide deeper insights. SQL (Structured Query Language) lets you access and manipulate databases, it is a popular language used across all types of applications.

This three day course is aimed at those with no experience of SQL and reporting. The course will cover the components of SQL Querying and provide you with the knowledge to understand how to query multiple tables, set operators and subqueries.

The course is split into three parts, delivered over three full days.

Part 1 includes: Writing Select Queries, Sorting and filtering, Querying Multiple Tables and Set Operators

Part 2 includes: Grouping Data, Built-in functions, Subqueries, Correlated Subqueries and Common table expressions

Part 3 includes: Pivoting and Grouping Sets, Using Windows Ranking, Offset, and Aggregate Functions, Partitioning, Using DML to Modify Data and Introduction to SQL Programming

Who is this course for?

This course is aimed at people working in social housing at all levels, particularly those who work in Data Analytics roles and have no experience of creating reports using SQL.

Entry requirements

There is no prerequisite for this course.

Contact us

We can also deliver dedicated courses for your organisation either online or at your premises.

If you would like to pay by invoice, or if you have any questions please contact Imogen Fowler imogen.fowler@housemark.co.uk

SQL Querying Fundamentals - 29 April - 1 May 2025