BeginnerFree

SQL Basics

Query data with SELECT, filters and joins.

1h 40m 9 lessons 4.8 4.1k learners

Course content

Module 1: Talking to a Database

What SQL is and how to read data

  • What a Database Really Is6 min
  • SELECT: Getting Columns Back6 min
  • Reading Errors Without Panic6 min

Module 2: Filtering and Sorting

Ask precise questions of your data

  • WHERE: Asking Precise Questions6 min
  • ORDER BY and LIMIT6 min
  • Working with Dates and Text6 min

Module 3: Grouping and Joining

Summarise and combine tables

  • GROUP BY and Aggregates7 min
  • JOIN: Combining Two Tables7 min
  • Building a Real Report7 min