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 career prospects and provide opportunities for personal growth.

Course Subjects

The Centre 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 1

This introductory course is suitable for those with little or no prior understanding of relational databases. The course covers the basics of SQL and relational databases, including designing databases, managing data, and writing queries.

Course Details

• Duration: 1 session, 8 hours total
• Next date: 28 November 2025
• Location: Face-to-face (CCE Building, Newtown)
• Cost: A$465.00 - A$495.00

Course Information

The course is designed for those with little to no prior understanding of relational database management. It covers the principles of relational database management systems, including database design, data modelling, and SQL queries.

Outcomes

By the end of the course, participants should be able to:

• Recognise elements of good and bad database design relevant to SQL
• Interpret database structures to determine the SQL required to resolve queries
• Choose appropriate clauses to write an SQL query
• Write SQL queries to answer specific questions
• Read SQL queries to determine the result sets produced

Content

The course covers the following topics:

• Rationalise the purpose of Relational Database Management Systems and their role in information systems
• Interpret the narratives that define business rules that form the basis of a database's design
• Simplify business rules to enable database design and the interpretation of database design when answering questions with SQL
• Resolve the metaphor used in relational database management systems and thus SQL
• Discuss the principles of a normalised database that store facts in a single place and the method used to relate facts
• Name and discover the natural cardinalities in a given business narrative
• Create an ERD (Entity Relationship Diagram) for the design of a database using its symbols and their meaning that express those cardinalities to capture business rules using primary keys and foreign keys, constraints and datatypes to enforce cardinalities
• Implement a database design in SQL from an ERD creating tables, columns and relationships
• Use Structured Query Language (SQL) to build a result set from one table, alias columns in the result set, derive columns in the result set with arithmetic, intrinsic functions and concatenation, cull records from a result set with WHERE clause boolean predicates, involve multiple boolean predicates in the WHERE clause with the logical operators AND and OR using their operator precedence and brackets, sort result sets with the ORDER BY clause and nested sort orders

Intended Audience

The course is suitable for those with little to no prior understanding of relational database management, including business people and IT professionals who want to enhance their skills in SQL and database design.

Delivery Modes

The course is available in face-to-face and online delivery modes.

Materials

Course materials are distributed electronically using Dropbox.

Related Courses

The Centre offers several related courses, including:

• Power BI Course: Introduction
• R Programming Course: Introduction
• SQL Course: Level 2a
• SQL Course: Level 2b
• Tableau Course: Level 1A

Meet the Facilitators

The course is taught by experienced facilitators, including John Cumming, who has been teaching for over 20 years and has designed courses and taught at TAFE and universities.

What Others Say

Participants have praised the course, saying it was "really beneficial" and "enhanced my background in the field of SQL." The tutor was described as "great" and having a "great style for explaining key concepts very quickly."