All courses available in-class and remotely.

SQL Header

SQL for Data Analysis

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 multiple, related tables and to aggregate, sort, filter or limit the data retrieved as needed.

Our experienced Data Analyst, will guide you through the basics of relational databases, creating your first Azure SQL Database, uploading, retrieving and transferring data as well as how to run queries from the Azure portal and from Azure Data Studio. Read the full outline here.

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

SQL for Data Analysis

Learn how to work with data stored in the cloud, develop an understanding of relational databases and SQL.
$745
10 max
1 day
$745
10 max
1 day
$745
10 max
1 day
$745
10 max
1 day
$745
10 max
1 day
$745
10 max
1 day
$745
10 max
1 day
$745
10 max
1 day

Frequently Asked Questions

Meet your Trainer

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. She is consistently well reviewed by her students. 


What is Remote Training?

Remote training at Nexacu, means our team of 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 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 for Data Analysis Course?

This course will be of benefit for anyone working towards Microsoft Certification in Azure Data Fundamentals, without prior knowledge of relational databases and SQL. This certification is 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 for Data Analysis
Power BI Beginner
Power BI Intermediate

SQL for Data Analysis Course Details

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

SQL for Data Analysis Course Details

Price
$745
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
L10
333 Adelaide Street
Brisbane QLD 4000
microsoft_gold

SQL for Data Analysis Course Details

Price
$745
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 3
37 Pitt Street
Sydney NSW 2000
microsoft_gold

SQL for Data Analysis Course Details

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

SQL for Data Analysis Course Details

Price
$745
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 3
466 Little Lonsdale St
Melbourne VIC 3000
microsoft_gold

SQL for Data Analysis Course Details

Price
$745
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Ethos House
Level 1
28 Ainslie Place
Canberra ACT 2601
microsoft_gold

SQL for Data Analysis Course Details

Price
$745
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 3
97 Pirie Street
Adelaide SA 5000
microsoft_gold

SQL for Data Analysis Course Details

Price
$745
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 4
220 St Georges Tce
Perth WA 6000
microsoft_gold

SQL Course Outlines

Other Courses
Microsoft Power BI Training Courses
Microsoft Office 365 Training Courses
Microsoft Excel Training Courses
Excel Specialist Training Courses
Microsoft Project Training Courses
R Programming Training Courses
Python Training Courses
Microsoft Power Apps Training Courses
Microsoft SharePoint Training Courses
Microsoft Teams Training Courses
Power Automate Training Courses
Microsoft Visio Training Courses
Dynamics 365 Training Courses
Microsoft PowerPoint Training Courses
Microsoft Word Training Courses
Other Courses
Course Rating
SQL Training Courses

4.72 5 SQL Training Courses
4.72 out of 5
30777 Student Reviews

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 for Data Analysis Learning Outcomes

In this course, you will:

  • Learn the basics of relational databases
  • Create an Azure SQL Database and upload data to an Azure Data Lake Storage Gen2
  • Use Azure Data Factory to transfer data from storage to the database
  • Use SQL to retrieve data from the database
  • Run queries from the Azure portal and from Azure Data Studio

SQL for Data Analysis 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 
  • Create a storage account 
  • Create a database 
  • Create tables 
  • Azure Data Factory 
  • 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 
  • Using Subqueries 
  • Subqueries in the SELECT clause 
  • Subqueries in the FROM clause 
  • Subqueries in the WHERE clause 
  • Stored Procedures 
  • What is a stored procedure? 
  • Parameters 
  • Basic syntax for creating a stored procedure 
  • Creating a stored procedure in Azure Data Studio 
  • Calling a stored procedure 
  • Chart Elements 
  • Understanding Chart Elements 
  • Adding a Chart Title 
  • Adding Axes Titles 
  • Repositioning the Legend 
  • Showing Data Labels 
  • Showing Gridlines 
  • Formatting the Chart Area 
  • Adding a Trendline 
  • Adding Error Bars 
  • Adding a Data Table
  • GoTo Special 
  • Finding Constants 
  • Finding Formulas 
  • Finding Blanks

Contact Us

What is Remote Training?

Valued by Individuals

4.72 / 5
Over 30777 Reviews

Trusted by Business

Procured by Government

Awards and Accreditations

Follow us