COST: Contact us DURATION: 4 hours


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 and analyse your data from 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:

There are no prerequisites for this module. 

 

Learning outcomes:

During this module you will learn about:

  • Easily writing SQL SELECT statements in a structured 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.

 

Content:
  • Read records and fields with SELECT / FROM
  • Eliminate unwanted duplicate values with DISTINCT
  • Sort the records with ORDER BY
  • Filter the records with WHERE
  • Use the conditional operators with WHERE
  • Return the fields in the desired format with expressions
  • Apply the various scalar functions.

 

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