Are you in the right region?
These are the sessions we offer for Introduction to SQL in New Zealand.
We also have sessions for this course in: Australia Asia

21 - 22 Nov, 2024

12.30pm - 5pm NZDT

LiveOnline via Strigo
NZD$950 +GST
Book now
Can't find a date that suits you?

More are always being added
Click here to register your interest

What is the course like?

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.

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.

Great 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.

Course overview

Pricing

LiveOnline
Cost: NZD$950 +GST (NZD$1,093 incl. GST)
Duration: 2 sessions of 4.5 hours
In-person
Cost: NZD$995 +GST (NZD$1,144 incl. GST)
Duration: 1 day
20% off for group bookings when booking 3 or more attendees from the same organisation on the same course dates in the same transaction
Need more information?
Need to hold your place or have a question?
Corporate group?

Meet the course trainers

Craig Smith

Global Agility Lead

Colin Garlick

Knowledge Engineer

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

Very practical and hands on. The instructor, Colin Garlick, was well presented and spoken, and easy to discuss topics with. I'd recommend this course to anyone wanting to learn SQL.

- Carlo Abogado, Capital & Coast District Health Board

I was worried that this course would be overwhelming, but the lessons were broken down into digestible bites that allowed us to build our knowledge over the day.

- Steph Peters, Mercury

Need more information?
Need to hold your place or have a question?
Corporate group?
Introduction to SQL
 

Enhance your productivity, sign up to our newsletter

See our Privacy Policy for more details. You can unsubscribe at any time.

Problem submitting!

- {{formError.message}}

Submitting, please wait

/images/newsletter.jpg

Thank you!

Your details have been submitted and we will be in touch.