Do you need to analyse and work with large volumes of data?

For anyone looking to improve their knowledge of SQL (Structured Query Language) this course will teach you how to write SQL SELECT statements to retrieve and analyse your data from a relational database.

LiveOnline
Cost: Not Applicable
Duration: 2 sessions of 5 hours each
20% off for Group bookings of three or more
Need more information?

Corporate group?

In-house/private course query
You'll learn:

During this course you will learn about:

  • Writing SQL SELECT statements in a structure way, starting with visualising the desired output.
  • Ordering the data according to your needs.
  • Filtering the records to get only the relevant information.
  • Using expressions and scalar functions to transform the data.
  • Using inner joins to read data from multiple tables simultaneously.
  • Finding unmatched records with outer joins.
  • Using aggregate functions to summarise your data
  • Reclassifying your data with new criteria.
Download Course Overview
Designed for:

Anyone who needs to be able to access relational data using SQL, including:

  • Developers.
  • Test analysts and engineers.
  • Business and systems analysts.
  • Data analysts.

 

You'll need:

There are no prerequisites for this course.

Here's what our customers are saying:
This course provided a sound knowledge of SQL. It was very informative and provided lots of exercises which helped to expand the theory.- Teresa Glen, Victoria University
I feel a lot more confident with SQL now - not only do I know how to do things, but also why.
- Cara Marshall, Kiwibank
Colin was excellent in his presentation and enthusiasm for the subject matter and communicated extremely well.
- Tim Jones, ANZ
Absolutely fantastic! I would recommend both this course and SoftEd to anyone.
- Tamara Bardell, MSD
I thought the course was extremely beneficial for my needs.
- Tony Hardy, AGL
CHAT
CALL