- Home
- Free Courses
- SQL Basics: Ask Questions of Your Data
SQL Basics: Ask Questions of Your Data
Learn to read and summarize data with SQL in five short lessons: SELECT, WHERE, GROUP BY, joins and safe data changes. Practise on a free tool and finish with a certificate of completion.
Already have a campus account? Open the course
The short version
Free, no payment details
Sign up with your name and e-mail and confirm it with a 6-digit code. There is nothing to buy.
About 60 minutes
5 short lessons and one final quiz. Your progress is saved, so you can stop and come back on any device.
Certificate of completion
Finish every lesson and score 70% or more on the final quiz. Retakes are unlimited.
Not a program
This free short course is not part of a Ucademy diploma or certificate program and gives no program credit.
What you will learn
- Explain tables, rows, columns, primary keys and foreign keys in plain terms
- Write SELECT queries that filter with WHERE and sort with ORDER BY
- Summarize data with COUNT, SUM, AVG, MIN, MAX, GROUP BY and HAVING
- Combine related tables with INNER JOIN and LEFT JOIN
- Create a table and add, change and remove rows using a safe checking routine
- Recognize NULL pitfalls, SQL injection and the privacy care that personal data needs
Who it is for
Adults who want to work with data in an office or tech role, career changers exploring software and databases, and anyone who has heard of SQL and wants a clear first look. No programming experience is needed.
What you need
- A computer with an internet connection
- A free SQL practice tool, such as the SQLite command-line shell or an in-browser SQL playground
- About 60 minutes in total, which you can split across several days
Lessons
- 1Tables, rows and your first SELECT12 min
- 2Filtering and sorting with WHERE and ORDER BY12 min
- 3Summarizing data with GROUP BY12 min
- 4Combining tables with joins12 min
- 5Changing data safely12 min
- ✓SQL Basics: final quizfinal quiz
Where this course can lead
Software & Web Developer Diploma
This course is a short, practical introduction. The full program goes much further: 960 hours online of full-stack development: web pages, programming, databases and team tools.
Related reading
More free technology & it courses
Safe Job Search: Phishing Basics
Learn how phishing and fake job offers work in Canada, how to spot the warning signs, and what to do if you clicked or paid. Six…
See the course →
Python Basics for Complete Beginners
Learn the core ideas of Python programming from scratch: variables, decisions, lists, loops and functions. Five short lessons and a quiz, with a certificate of completion.
See the course →
Cyber Hygiene: Protect Your Accounts and Devices
A free cybersecurity course for beginners: strong passphrases, multi-factor authentication and passkeys, updates, backups and safe Wi-Fi, using Canadian Centre for Cyber Security guidance. Five short…
See the course →Frequently asked questions
Yes. You create a free Ucademy account, take the five lessons and the quiz at no cost, and there is nothing to pay at any point.
Yes. When you finish all five lessons and the quiz, you receive a certificate of completion from Ucademy. This free course is not part of a Ucademy diploma or certificate program.
The five lessons take about 60 minutes in total, plus the quiz. The course is online and self-paced, so you can split it over several days.
No. The course starts with what a table is and builds up one clause at a time. A computer and a free practice tool are all you need.
The examples work in SQLite, which is free and needs no server. The commands you learn also work in PostgreSQL and MySQL, and the lessons point out the small differences.
Start SQL Basics: Ask Questions of Your Data today
Free, online and at your own pace, with a certificate of completion.