SQL Querying Fundamentals
Delivered by housing experts who are passionate about what data can deliver for the sector.
Find out more
Improving skills and unlocking the potential of your people.
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
To book your place visit our events page.
For more information about our data training courses, please contact imogen.fowler@housemark.co.uk.
Work with Housemark
Our expert partners are here to provide support to boost your in-house capabilities. By presenting data in a clear way, we’ll show you what the numbers mean to your customers, your people, and your business.
Contact us