SQL Beginner Course

Use SQL to access and query your data.

A crucial skill for anyone working with data is the ability to access and analyse that data. Structured Query Language (SQL) enables users to access data from databases, combine data from related tables and aggregate, sort, filter or limit the data retrieved as needed.

You will be guided through the basics of relational databases as well as how to run queries from the Azure portal and from Azure Data Studio. Read the full outline.

Learn how to work with data stored in the cloud and develop an understanding of relational databases and SQL. This course will suit those working towards an Azure Data Fundamentals Certification.

SQL Beginner Course

Learn how to work with data stored in the cloud, develop an understanding of relational databases and SQL.

$445
10 max
1 day
$445
10 max
1 day
$445
10 max
1 day
$445
10 max
1 day
$445
10 max
1 day
$445
10 max
1 day
$445
10 max
1 day
$445
10 max
1 day
$445
10 max
1 day

Remote East

Brisbane

Sydney

Parramatta

Melbourne

Canberra

Adelaide

Perth

Remote West

Upcoming Courses:
Remote East
Date
Course
City
Status
Mon 11 Nov 24
Mon
11
Nov
SQL Beginner
Remote East
Status: Confirmed
Confirmed
Tue 12 Nov 24
Tue
12
Nov
SQL Beginner
Remote East
Status: Confirmed
Confirmed
Fri 22 Nov 24
Fri
22
Nov
SQL Beginner
Remote East
Status: Few Seats
Few Seats
Thu 5 Dec 24
Thu
5
Dec
SQL Beginner
Remote East
Status: Confirmed
Confirmed
Wed 18 Dec 24
Wed
18
Dec
SQL Beginner
Remote East
Status: Confirmed
Confirmed
Fri 24 Jan 25
Fri
24
Jan
SQL Beginner
Remote East
Status: Scheduled
Scheduled
Tue 28 Jan 25
Tue
28
Jan
SQL Beginner
Remote East
Status: Scheduled
Scheduled
Fri 14 Feb 25
Fri
14
Feb
SQL Beginner
Remote East
Status: Scheduled
Scheduled
Wed 19 Feb 25
Wed
19
Feb
SQL Beginner
Remote East
Status: Scheduled
Scheduled
Tue 25 Feb 25
Tue
25
Feb
SQL Beginner
Remote East
Status: Scheduled
Scheduled
Brisbane
Date
Course
City
Status
Fri 22 Nov 24
Fri
22
Nov
SQL Beginner
Brisbane
Status: Few Seats
Few Seats
Wed 18 Dec 24
Wed
18
Dec
SQL Beginner
Brisbane
Status: Scheduled
Scheduled
Fri 24 Jan 25
Fri
24
Jan
SQL Beginner
Brisbane
Status: Scheduled
Scheduled
Tue 25 Feb 25
Tue
25
Feb
SQL Beginner
Brisbane
Status: Scheduled
Scheduled
Fri 21 Mar 25
Fri
21
Mar
SQL Beginner
Brisbane
Status: Scheduled
Scheduled
Sydney
Date
Course
City
Status
Wed 18 Dec 24
Wed
18
Dec
SQL Beginner
Sydney
Status: Confirmed
Confirmed
Parramatta

We are currently developing these courses. Please contact us to register your interest.

Melbourne
Date
Course
City
Status
Wed 18 Dec 24
Wed
18
Dec
SQL Beginner
Melbourne
Status: Confirmed
Confirmed
Tue 28 Jan 25
Tue
28
Jan
SQL Beginner
Melbourne
Status: Scheduled
Scheduled
Wed 26 Feb 25
Wed
26
Feb
SQL Beginner
Melbourne
Status: Scheduled
Scheduled
Mon 24 Mar 25
Mon
24
Mar
SQL Beginner
Melbourne
Status: Scheduled
Scheduled
Canberra
Date
Course
City
Status
Mon 11 Nov 24
Mon
11
Nov
SQL Beginner
Canberra
Status: Confirmed
Confirmed
Fri 6 Dec 24
Fri
6
Dec
SQL Beginner
Canberra
Status: Scheduled
Scheduled
Fri 14 Feb 25
Fri
14
Feb
SQL Beginner
Canberra
Status: Scheduled
Scheduled
Tue 25 Mar 25
Tue
25
Mar
SQL Beginner
Canberra
Status: Scheduled
Scheduled
Adelaide
Date
Course
City
Status
Tue 12 Nov 24
Tue
12
Nov
SQL Beginner
Adelaide
Status: Confirmed
Confirmed
Thu 5 Dec 24
Thu
5
Dec
SQL Beginner
Adelaide
Status: Scheduled
Scheduled
Wed 19 Feb 25
Wed
19
Feb
SQL Beginner
Adelaide
Status: Scheduled
Scheduled
Tue 25 Mar 25
Tue
25
Mar
SQL Beginner
Adelaide
Status: Scheduled
Scheduled
Perth
Date
Course
City
Status
Tue 5 Nov 24
Tue
5
Nov
SQL Beginner
Perth
Status: Few Seats
Few Seats
Wed 20 Nov 24
Wed
20
Nov
SQL Beginner
Perth
Status: Few Seats
Few Seats
Tue 17 Dec 24
Tue
17
Dec
SQL Beginner
Perth
Status: Scheduled
Scheduled
Mon 20 Jan 25
Mon
20
Jan
SQL Beginner
Perth
Status: Confirmed
Confirmed
Thu 27 Mar 25
Thu
27
Mar
SQL Beginner
Perth
Status: Scheduled
Scheduled
Remote West
Date
Course
City
Status
Tue 5 Nov 24
Tue
5
Nov
SQL Beginner
Remote West
Status: Few Seats
Few Seats
Wed 20 Nov 24
Wed
20
Nov
SQL Beginner
Remote West
Status: Few Seats
Few Seats
Tue 17 Dec 24
Tue
17
Dec
SQL Beginner
Remote West
Status: Scheduled
Scheduled
Mon 20 Jan 25
Mon
20
Jan
SQL Beginner
Remote West
Status: Confirmed
Confirmed
Thu 27 Mar 25
Thu
27
Mar
SQL Beginner
Remote West
Status: Scheduled
Scheduled
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Frequently Asked Questions

Meet your Developer

Tamara Shatar holds a PhD in Agricultural Data Science. She has extensive experience, including many years working as a research scientist focused on data analysis, modelling using machine learning, simulation and other techniques. While working in both academia and at the CSIRO, part of her role included teaching a variety of data analysis skills.

What is Remote Training?

Remote training at Nexacu means our experienced trainers will deliver your training virtually. With remote learning, students can access our usual classroom training courses via video conferencing, ask questions, participate in the discussion and share their screen with the trainer if they need help at any point in the course. Students have the same level of participation and access to the trainer as they would in classroom training sessions.

Who will benefit from this SQL Beginner Course?

This course will be of benefit to anyone working towards Microsoft Certification in Azure Data Fundamentals, without prior knowledge of relational databases and SQL. This course is also suitable for anyone interested in working with data stored in the cloud.

What is the Microsoft Azure Data Fundamentals Certification?

The Microsoft Azure Data Fundamentals certification is awarded to individuals who can demonstrate their understanding of core data concepts, working with relational and non-relational data in Azure and the tools available within Azure for data processing, analytics and visualisation. In addition to knowledge of Azure products, candidates for this certification must demonstrate their understanding of SQL and Power BI.

Nexacu offers 3 courses to help you achieve this certification:

SQL Beginner
Power BI Beginner
Power BI Intermediate

SQL Beginner Course Details

Price
$445
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
microsoft_gold

SQL Beginner Course Details

Price
$445
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 8
201 Charlotte Street
Brisbane QLD 4000
microsoft_gold

SQL Beginner Course Details

Price
$445
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 24/477 Pitt Street
Sydney
New South Wales 2000
microsoft_gold

SQL Beginner Course Details

Price
$445
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 7
79 George Street
Parramatta NSW 2150
microsoft_gold

SQL Beginner Course Details

Price
$445
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 12A
45 William Street Melbourne VIC 3000
microsoft_gold

SQL Beginner Course Details

Price
$445
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
NEW LOCATION
Level 2
221 London Circuit
Canberra ACT 2600
microsoft_gold

SQL Beginner Course Details

Price
$445
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 15
33 King William Street
Adelaide 5000
microsoft_gold

SQL Beginner Course Details

Price
$445
Duration
1 day
Time
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 7
553 Hay Street
Perth WA 6000
microsoft_gold

SQL Beginner Course Details

Price
$445
Duration
1 day
Times
9am-4pm
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
microsoft_gold

SQL Course Outlines

Contact Us


What do I need to know to attend?

This course is designed as an introduction to SQL and requires no prior knowledge of relational databases or SQL.

SQL Beginner Learning Outcomes

In this course, you will:

  • Learn the basics of relational databases
  • Use SQL to retrieve data from the database
  • Run queries from the Azure portal and from Azure Data Studio

SQL Beginner Course Content

  • Introduction 
  • SQL 
  • Azure SQL Database
  • What is a Relational Database? 
  • Tables 
  • Primary keys 
  • Foreign keys 
  • Relationships between tables 
  • Type of relationships  
  • Data normalisation 
  • SQL Overview 
  • Type of SQL commands 
  • Working in Azure 
  • Running queries from the Azure portal
  • Basics of Queries 
  • SELECT 
  • SELECT DISTINCT 
  • SQL clauses 
  • Working in Azure Data Studio 
  • Selecting specific columns 
  • Aliases 
  • SQL syntax rules 
  • Filtering Data with a WHERE Clause 
  • SQL operators 
  • Comparison operators 
  • Logical operators 
  • Arithmetic operators 
  • Operator precedence 
  • WHERE clause 
  • Ordering Query Results 
  • ORDER BY clause 
  • Group Query Results 
  • GROUP BY clause 
  • Aggregation functions 
  • CASE statement 
  • Filtering on Aggregated Values 
  • HAVING clause 
  • Order of evaluation of clauses in a SELECT statement 
  • Access Data from Multiple Tables 
  • JOIN using WHERE clause 
  • Types of Joins 
  • Joining with date tables 
  • Combining multiple SELECT Results  
  • UNION operator 
  • Practice Exercises
  • Practice query writing

Contact Us

Why Nexacu?

Valued by Individuals

4.72 / 5
Over 75364 Reviews

Trusted by Business

Procured by Government

Awards and Accreditations

Follow us