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 and will cover the components of SQL Querying providing you with enhanced understanding of 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 have any questions, please contact Imogen Fowlerβ―atβ―imogen.fowler@housemark.co.uk.
Book Now