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 INSERT, UPDATE, and DELETE statements to make changes to the data in your 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:

  • Adding new records, individually or from other tables, and identify what was inserted
  • Changing fields to values either specified or derived, possibly from other tables, and identify what was changed
  • How to safely remove unwanted records, and identify what was removed
  • Using transactions to make changes safely with the option to abort them

 

Content:
  • Add new records to tables with the SQL INSERT statement
  • Modify the data already in the database with the SQL UPDATE statement
  • Remove records with the SQL DELETE statement
  • Combine these changes using the SQL MERGE statement
  • Use transactions to undo failed changes

 

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