Please note this course is not offered in your region.

We do however offer this course in the following regions:



Do you need to analyse and work with large volumes of data?  For anyone looking to improve their knowledge of structured query language (SQL), this course will teach you how to write SQL SELECT statements to retrieve data from across multiple tables in a relational database.

This is one of four 4-hour modules that cover SQL.  These modules are independent and are provided at different times.  You can attend all modules or only those that are of interest to you.  Furthermore, you can attend the modules in any order (subject to the relevant prerequisites). 

 

Related modules:

 

LiveOnline delivery

This program is offered as a LiveOnline course.  It is delivered in a virtual classroom environment that includes an instructor and other participants just like a traditional classroom but from your home or workplace.

Timing:

Australia AEST: 11am-3pm 
New Zealand: 1pm-5pm 
Singapore: 9am-1pm 

 

Intended for:

The modules of this course are 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

 

Prerequisites:

A basic understanding of SQL SELECT statements is necessary for this module.  This is covered in the Queries and Expressions module.

 

Learning outcomes:

During this module you will learn about:

  • How relationships are implemented in a relational database
  • Reading entity-relationship (ER) diagrams and derive them from the database
  • Using inner joins to read data from multiple tables simultaneously
  • Finding unmatched records with outer joins
  • Using self-joins to retrieve hierarchical information from a table
  • Correlating the result of multiple queries.

 

Content:
  • Understand relationships between tables
  • Obtain the entity-relationship (ER) diagram from the database
  • Read records from two tables with inner joins
  • Read records from many tables
  • Know when and why to use outer joins, and how to implement them
  • Follow hierarchical data in a single table with self-joins
  • Combine the results of multiple queries with the set operators UNION, INTERSECT, and EXCEPT/MINUS.

 

Method used:

This is a hands-on course facilitated by an instructor online.  Each module will take 4 hours.

You will connect using your own computer from your own location, using Zoom meeting to attend.  The hands-on exercises are carried out using your choice of SQL Server or Oracle in an online environment accessed through an up-to-date web browser.

Instructions on how to connect will be sent to you by email before the course starts.  You will need to install Zoom, either from the instructions in the email or from https://zoom.us/support/download.  Information on the system requirements for Zoom is available at https://support.zoom.us/hc/en-us/articles/201362023-System-Requirements-for-PC-Mac-and-Linux.

 

CHAT
EMAIL
CALL