SQL for Data Analytics · Querying single tables

Querying single tables

This unit

This unit is where you start writing SQL. By the end of it you'll be able to pull exactly the columns and rows you want out of a single table, do math on them, name them, and sort them.

There are five lessons, and each one works the same way:

  1. Watch the video. There's a query box right under it. When I tell you in the video to try something, use that box.
  2. Try it. One short question after the video to check yourself. It isn't recorded or part of your unit submission.

The lessons:

  • SELECT Statements (8 min)
  • Math on Columns (4 min)
  • Column Aliasing (3 min)
  • WHERE Clause (30 min)
  • ORDER BY, LIMIT, and Query Structure (11 min)

When you've finished the lessons, do the Practice for this unit. It's fifteen questions in two parts: ten queries to write, then five questions where you use queries to answer something. This is what you will turn in on Canvas.