Accessing and analysing data is a crucial skill for anyone who works with it. Structured Query Language (SQL), allows users to access and analyse data from different databases. It also allows them to combine data from related tables. Users can filter, aggregate, filter, or limit the data retrieved. The SQL Intermediate course will be used to build on the skills of our Advanced SQL course.
Students will learn advanced techniques to query databases and manipulate result sets. Participants will be able to pivot and unpivot data. They will learn to write more complicated queries by using temporary tables, subqueries and common table expressions. They will be able to query hierarchical data using recursive techniques and create date dimension tables. Students will use their knowledge of local variables and scalar user defined functions to create table-valued functions.