SQL for Data Analysis – Beginner

Length

1 days

Price

$899

Cities

Melbourne, Sydney, Brisbane, Adelaide, Canberra, Perth

Request Course Information

Why Choose This Course

SQL for Data Analysis – Beginner is an instructor-led course for professionals who need to learn how to query, filter and combine data stored in relational databases using SQL. The curriculum is aligned with recognised beginner pathways for Transact-SQL and core data concepts, covering SELECT statements, joins, grouping and aggregation, and safe data modification patterns. You will practise running queries in Azure Data Studio and the Azure portal while building foundational understanding of tables, keys, relationships and normalisation, so your analysis is consistent and repeatable across datasets and platforms.

Why this training matters: SQL remains the standard language for retrieving and analysing data in enterprise systems. The course focuses on practical techniques that map to the skills measured in Microsoft’s Azure Data Fundamentals certification outline (relational vs non‑relational data, analytical workloads), while keeping the emphasis on day‑to‑day querying skills applicable to reporting and analytics roles across Melbourne, Sydney, Brisbane, Adelaide, Canberra and Perth. The learning path components include sorting and filtering, joining multiple tables, subqueries, built‑in functions and grouping, all of which form the backbone of business reporting workflows.

You will learn, prepare and apply SQL in realistic scenarios: exploring schemas, handling NULLs and data types, designing result sets for stakeholders, and using predicates and HAVING to answer targeted business questions. The training promotes safe patterns for modifying data where appropriate and introduces governance through role‑appropriate access in the service. The approach balances core SQL concepts with hands‑on practice, giving analysts and reporting specialists the confidence to work with relational data and present insights clearly. A certificate of course attendance is included.

Prerequisites

  • There are no formal prerequisites for this course.

Exam

  • Candidates can achieve thi certification by passing the following exam(s).

    DP‑900: Microsoft Azure Data Fundamentals

Books

  • SQL for Data Analysis – Beginner course material included.

Delivery

  • Instructor-led Classroom Training at our premises
  • Live Virtual Online Training attend in real-time from anywhere
  • In-House Training at your premises (4+ participants)

Skills Gained

  • Understand tables, primary and foreign keys, relationships and normalisation basics
  • Write SELECT queries to retrieve columns and rows from one or more tables
  • Sort and filter results using ORDER BY and WHERE with comparison and logical operators
  • Combine data with INNER, LEFT, RIGHT and FULL joins; use UNION to combine result sets
  • Use built‑in functions and GROUP BY to aggregate data; refine results with HAVING
  • Apply aliases, DISTINCT, predicates and CASE for cleaner, business‑ready outputs
  • Create basic subqueries to support targeted analysis scenarios
  • Execute queries in Azure Data Studio and the Azure portal for cloud‑hosted databases
  • Follow safe patterns for INSERT, UPDATE, DELETE and MERGE when required

Audience

  • Data analysts, BI practitioners, reporting developers, business professionals and experienced Excel users who want to learn SQL for reliable, repeatable data analysis in a professional setting.

Price

Category Full-Time (Weekdays) Part-Time (Weeknights) Part-Time (Weekends)
Days Mon – Wed Mon & Tue Saturdays only
Time 9:30 am to 5:00 pm 6:00 pm to 9:00 pm 10:00 am to 5:00 pm
Duration 3 days 3 weeks 3 weeks
Price $2999 $2999 $2999

Outline

  • Introduction to relational databases and SQL in analytics workflows
  • Tables, schemas and database objects; working with data types and NULLs
  • Keys and relationships: primary keys, foreign keys, one‑to‑many and many‑to‑many
  • Normalisation concepts for clean, queryable datasets
  • SQL command types and query syntax rules; SELECT and SELECT DISTINCT
  • Filtering with WHERE: comparison, logical and arithmetic operators; operator precedence
  • Sorting with ORDER BY; paging and de‑duplication patterns
  • Column selection, aliases and readable outputs for stakeholders
  • Joining tables: INNER, OUTER, CROSS and self joins; joining with date dimensions
  • Combining results with UNION; set‑based thinking for analysis
  • Aggregation with GROUP BY; COUNT, SUM, AVG, MIN, MAX; HAVING for grouped filters
  • Built‑in functions: scalar, ranking and rowset functions for common calculations
  • CASE expressions and conditional logic in reports
  • Subqueries: scalar and multi‑valued; correlated subqueries for targeted lookups
  • Executing queries in Azure Data Studio and the Azure portal
  • Basic data modification: INSERT, UPDATE, DELETE and MERGE patterns
  • Safe practices for write operations and testing in sandboxes
  • Introduction to views for reusable query logic (read‑only analysis scenarios)
  • Query troubleshooting: error messages and performance basics for beginners
  • Mapping skills to DP‑900 domains: relational, non‑relational and analytics workloads

Terms & Conditions

The supply of this course is governed by our terms and conditions. Please read them carefully before enrolling, as enrolment is conditional on acceptance of these terms and conditions. Proposed course dates are given, course runs subject to availability and minimum registrations.

Frequently Asked Questions (FAQ's)

Does this beginner SQL course align to a certification pathway?
Yes. It builds core relational and analytical skills that align with Microsoft’s Azure Data Fundamentals certification, which covers relational vs non‑relational concepts and analytical workloads.
You will practise in Azure Data Studio and the Azure portal against Azure SQL databases, with guidance on portable SQL patterns for enterprise databases.
The modules focus on joins, grouping, HAVING and built‑in functions so you can prepare stakeholder‑ready result sets and answer targeted business questions with confidence.

Our Partnership

Reliable certification testing is vital for validating professional skills in today’s tech-driven world. As a Pearson VUE Authorised Centre, we provide a secure environment for globally recognised IT exams. This partnership ensures convenient access to certifications with the highest standards of integrity and accuracy.

$118,530

Average advertised salary for Business Intelligence Analyst roles in Australia’s ICT sector.

97%

Power BI reported in use across 97% of Fortune 500 companies.

375,000+

Global organisations using Power BI (2024).

0.3%

Online job ads up 0.3% in July 2025 nationally (JSA)

17 years

Microsoft named a Leader in Gartner’s Magic Quadrant for Analytics and BI Platforms (including 2024)

98%

Student satisfaction rate from our training programs.

Our Accreditations

Scroll to Top