نظرة عامة على البرنامج

Introduction to SQL

Course Overview

This is a gentle, fast-paced introduction to SQL, aiming to build a strong foundation and intuition for SQL programming, with an emphasis on building and testing reliable SQL queries. The course is suitable for beginners.

Course Details

• Dates: Monday 16 Tuesday 17 February 2026 (2 DAYS ONLINE)
• Fees: 800 NZD

Course Outline

This course uses Microsofts flavour of SQL (called Transact-SQL) but all of the fundamentals, which are core SQL standards, are transferrable to all others, such as MySQL, PostgreSQL, Oracle SQL, and so on. The course is accompanied by an extensive set of notes and exercises.

Day One

• Introduction to database technologies
• The basic structure of a database and the usefulness of the SQL relational database model
• SQL tables, relationships between tables, and primary/foreign key pairs
• Connecting to a remote SQL database in the Azure Data Studio development environment
• Introducing SQL coding with easy examples and the most useful data manipulation queries
• Fundamentals of SQL: search conditions, subqueries, and joining tables
• Exercises for practice and revision.

Day Two

• Reading and interpreting Transact-SQL documentation
• Syntax and intuition for filtering and aggregating on grouped data
• Skills for iterative development, using the SQL data definition language to create test tables
• Design our own databases, with which we can safely test complicated queries as we write them.

Instructor

Daniel Fryer is an award-winning Honorary Lecturer and Associate Fellow of the Higher Education Academy of La Trobe University in Melbourne. He is a Senior Data Scientist specialising in Data Infrastructure at the Social Research Centre, technical sub-editor for the Australian & New Zealand Journal of Statistics, and Executive Privacy Officer for the Statistical Society of Australia, for which he also built the longitudinal member database. Danny completed his PhD at the University of Queensland, applying coalitional game theory in machine learning.