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 aggregate, sort, filter, or limit the data retrieved as needed.
This advanced course builds upon the skills learnt in our SQL Intermediate course. In this SQL course, you'll learn more complex querying techniques using Microsoft’s Transact-SQL (T-SQL) in an Azure SQL environment. You’ll learn to write advanced queries with subqueries, temporary tables, and common table expressions (CTEs), reshape data using pivot and unpivot functions, and apply recursive techniques for hierarchical data and date dimension tables.
The course also covers views, stored procedures, table-valued functions, and table variables to help simplify workflows and boost performance skills applicable across a range of database systems.
Nexacu Public Schedule
Nexacu is part of the Lumify Group, offering you the largest public schedule of end user applications and professional development training in Australia, New Zealand, and the Philippines. You can now access the schedule of courses and book, by clicking on the button below.
