What you’ll learn
After completing this course, students will be able to:
Understand the basics of relational databases
Use SQL to retrieve data from a database
Run queries using SQL Server Management Studio (SSMS)
Microsoft at Lumify Work
As part of Lumify Group, Lumify Work has skilled more people in Microsoft technologies than any other organisation in Australia and New Zealand. We have a campus in the Philippines, too. We offer the broadest range of instructor-led training courses, from end user to architect level. We are proud to be the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers in ANZ.
Who is the course for?
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 course is also suitable for anyone interested in working with data stored in the cloud.
Course subjects
Introduction
What is a Relational Database?
SQL Overview
Basics of Queries
Filtering Data with a WHERE Clause
SQL operators
Comparison operators
Logical operators
Arithmetic operators
Operator precedence
WHERE clause
Ordering Query Results
Group Query Results
GROUP BY clause
Aggregation functions
CASE statement
Filtering on Aggregated Values
Access Data from Multiple Tables
JOIN using WHERE clause
Types of Joins
Joining with date tables
Combining Multiple SELECT Results
Practice Exercises
Prerequisites
This course is designed as an introduction to SQL and requires no prior knowledge of relational databases or SQL.
FREE E-BOOK: The New Era of Cloud Computing
We've created this e-book to assist you on your cloud journey, from defining the optimal cloud infrastructure and choosing a cloud platform, to security in the cloud and the core challenges in moving to the cloud.
Terms & Conditions
The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.
