Skip to content
Online
Campus
ucademy.ca
  1. Campus
  2. Courses
  3. SQL Basics: Ask Questions of Your Data
Free courseTechnology & IT

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.

60minutes
5lessons
1final quiz
Freecertificate of completion

What you’ll be able to do

  • 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

Curriculum

01

Course lessons

5 lessons · module quiz
  1. 01Tables, rows and your first SELECTLesson
  2. 02Filtering and sorting with WHERE and ORDER BYLesson
  3. 03Summarizing data with GROUP BYLesson
  4. 04Combining tables with joinsLesson
  5. 05Changing data safelyLesson
  6. 06QUIZSQL Basics: final quizQuiz