Program Overview

Centre for Continuing Education

The Centre for Continuing Education at the University of Sydney offers a diverse range of professional development short courses. These courses are designed to enhance professional development, grow technical and people skills, and support career progression.

Course Subjects

The Centre for Continuing Education offers courses in various subjects, including:

• Business and management
  • Business communication
  • Business strategy
  • Business writing
  • Cultural competence and diversity
  • Finance
  • Leadership
  • Management
  • Organisational psychology
  • Sales and customer service
• English
• HSC preparation (years 10-12)
  • HSC biology
  • HSC business studies
  • HSC chemistry
  • HSC economics
  • HSC English
  • HSC mathematics
  • HSC physics
  • Year 11 (Revision)
  • Years 10-12 study and essay skills
• Humanities and culture
  • Creative writing
  • Music
  • Philosophy
  • Psychology
• Information technology
  • Adobe
  • AI and machine learning courses
  • Data analysis and analytics
  • Google
  • Microsoft
• Language
  • Arabic
  • Brazilian Portuguese
  • Chinese
  • French
  • German
  • Greek
  • Italian
  • Japanese
  • Spanish
• Marketing
  • Digital marketing
  • Marketing communications
  • Product development
• Project management
  • Agile methodology courses
  • Change management for projects
  • Stakeholder and people management
  • Technical project management skills

SQL Course: Level 2a

This SQL course will show you how to extract and change data in relational databases with SQL (Structured Query Language) that traverses multiple tables with Select, Insert, Update and Delete statements, functions and scripts. SQL is a current hot skill, valued by employers.

Course Details

• Duration: 3 sessions, 22.5 hours total
• Next date: 20 November 2025
• Delivery mode: Online via Zoom
• Cost: A$1,000.00 - A$1,100.00

Course Information

This course will cover the essentials of traditional and modern SQL, including:

• Expanding on the clauses learnt in SQL: Level 1
• Including more clauses in an SQL SELECT statement
• Building rows for a query from multiple tables and table expressions in the FROM clause
• Performing calculations such as subtotals and grand totals in multiple ways
• Writing INSERT, UPDATE and DELETE statements in various forms to add, change and delete rows in tables
• Solving more complex problems by consuming the result sets of SQL statements in other SQL statements
• Building tables and columns, applying constraints in SQL
• Advancing into the basics of scripting in preparation for creating stored procedures, views, functions and triggers (covered in SQL: Level 2b)

Intended Audience

This course is suitable for those who have completed SQL: Level 1, or who have equivalent knowledge and understanding of content covered in the SQL: Level 1 course outline.

Delivery Modes

The course is available in two delivery modes:

• Face-to-face, presenter-taught training in a computer lab
• Online training via the platform Zoom

Materials

Course materials are distributed electronically using Dropbox.

Organisational Training

For groups of six or more, courses can be delivered to your team with the option to tailor content.

Meet the Facilitators

John Cumming has been teaching for more than 20 years, designing courses and teaching at TAFE and universities at the undergraduate and postgraduate levels.

What Others Say

Previous students have praised the course, saying it is well-structured and thoughtfully assembled, with an excellent tutor who holds participants' attention and balances answering questions with ensuring the class moves on through the material.

Related Courses

Related courses include:

• R Programming Course: Intermediate
• SQL Course: Level 1
• SQL Course: Level 2b

FAQs

Frequently asked questions about applications, payment, short courses and more are available.