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

If you are interested in this course please reach out to us about the opportunity to schedule a course here.

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.

Pricing

LiveOnline
Cost: Not Applicable
Duration: 2 sessions of 5 hours each
In-person
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?
General Query

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?
General Query
Introduction to SQL
 
CHAT
CALL