SQL Beginner Course
Use SQL to access and query your data.
Use SQL to access and query your data.
5.00
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. 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.
By the end of this course, you will be able to:
No prior knowledge of SQL or relational databases is required; this course is designed for beginners.
SQL IntermediateBoost your data skills with our intermediate SQL training course. Learn T-SQL functions, subqueries, and views to write more advanced SQL queries.
SQL AdvancedTake your skills further with our advanced SQL training course. Master complex queries, data reshaping, and performance tuning in Azure SQL.
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
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:
What will I learn in this SQL course?
In this SQL training course, you’ll gain a solid understanding of relational databases, learn how to write SQL queries to retrieve and filter data, and run your own queries using both Azure Portal and Azure Data Studio.
SQL IntermediateBoost your data skills with our intermediate SQL training course. Learn T-SQL functions, subqueries, and views to write more advanced SQL queries.
SQL AdvancedTake your skills further with our advanced SQL training course. Master complex queries, data reshaping, and performance tuning in Azure SQL.
At Nexacu, we are proud to be the trusted training partner for hundreds of leading organisations across Australia, New Zealand, and around the world. From government agencies to multinational corporations, we help teams build practical skills and achieve real outcomes through expert-led training.
Students
4 & 5 Star Reviews
Google Reviews
Businesses Trust Nexacu
Custom workbook included with a step by step exercises
Learn with expert instructors, wherever you are
Australia
New Zealand
Singapore
Hong Kong
Malaysia
Philippines
Thailand