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.
Our Intermediate SQL course builds upon the skills learnt in our SQL Beginner course. In this course, you'll 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. You'll 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. You'll also create your own user-defined functions to encapsulate business logic and improve efficiency.
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.
