A crucial skill for anyone working with data is the ability to access and analyse that data. Structured Query Language (SQL) enables users to access data from databases, combine data from multiple related tables and to aggregate, sort, filter, or limit the data retrieved as needed. This advanced course builds upon the skills learnt in our SQL for Data Analysis - Intermediate course.
In this course, students will use more sophisticated techniques for querying databases and reshaping and manipulating result sets. Participants will learn to reshape data by pivoting and unpivoting. They will write more complex queries using subqueries, temporary tables, and common table expressions. They will use recursive techniques to query hierarchical data and create date dimension tables. Students will build on their understanding of scalar user-defined functions and local variables to create table-valued functions and use table variables.
Students will also learn to simplify querying and increase their efficiency by using views and stored procedures. Students work with an Azure SQL database and write queries in Microsoft’s Transact-SQL (T-SQL). Much of what is covered will be useful for users working with other database products.