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.

Course Details

Download Course PDF
Price
$490 $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

Course Details

Download Course PDF
Price
$490 $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

Course Details

Download Course PDF
Price
$490 $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

Course Details

Download Course PDF
Price
$490 $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

Course Details

Download Course PDF
Price
$490 $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

Course Details

Download Course PDF
Price
$490 $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

Course Details

Download Course PDF
Price
$490 $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

Course Details

Download Course PDF
Price
$490 $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

Course Details

Download Course PDF
Price
$490 $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

Upcoming Courses

Remote East

Brisbane

Sydney

Parramatta

Melbourne

Canberra

Adelaide

Perth

Remote West

Remote East

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

Brisbane

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

Sydney

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

Parramatta

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

Melbourne

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

Canberra

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

Adelaide

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

Perth

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

Remote West

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

Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

SQL Training Courses

Course Icon SQL Beginner

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

download course pdf
Price: $445 $490
View Course
4.74
(783)
Course Icon SQL Intermediate
download course pdf
Price: $550 $610
View Course
4.71
(581)
Course Icon SQL Advanced
download course pdf
Price: $595 $660
View Course
4.75
(477)

SQL Beginner Course Content

Expand All | Collapse All
  • 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

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

Course Details

Download Course PDF
Price
$490 $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

Course Details

Download Course PDF
Price
$490 $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

Course Details

Download Course PDF
Price
$490 $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

Course Details

Download Course PDF
Price
$490 $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

Course Details

Download Course PDF
Price
$490 $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

Course Details

Download Course PDF
Price
$490 $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

Course Details

Download Course PDF
Price
$490 $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

Course Details

Download Course PDF
Price
$490 $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

Course Details

Download Course PDF
Price
$490 $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

Skills Test


Try our short skills tests and
find out which course is right for you.

Skills Test Icon

 skills test

 

Contact Us

Can’t find a suitable date or have questions about the course? Fill out the form below, and our team will get back to you promptly.

Locations In-Person & Online

Find the nearest location and date that works for you

Locations In-Person & Online

Find the nearest location and date that works for you

;

Why Nexacu?

Books Icon

Step by Step Courseware

Custom workbook included with a step by step exercises

Why grid 2
Why grid 3
Why grid 1
Refresh Icon

Free Refresher

Resit your course for free within 6 Months

More than 1,300 Business trust Nexacu

Trusted by Business

Procured by Government

Procured by Goverment

Valued by Individuals