Our Intermediate SQL course builds upon the skills learnt in our SQL for Data Analysis - Beginner course.
In this SQL course, you will move beyond using basic SELECT clauses for retrieving data. Learn to work with many different types of functions and expressions that modify the way data is returned in the result set. Students will use built-in T-SQL functions for working with string, date, and numeric data types and will calculate moving averages, running totals, and percentages using window functions.
Learn to use subqueries to perform more complex querying and to use views to simplify querying. Students will also create their own user-defined functions to encapsulate business logic and improve efficiency.
Nexacu Public Schedule
With Lumify Group's acquisition of Nexacu, we're pleased to now offer you the largest public schedule of end user applications training in Australia and New Zealand. As we move to consolidate our End User offering with Nexacu, as an interim measure you can now access the schedule of the most closely aligned courses and book, by clicking on the link below.