Skip to course content
Free SQL course

SQL for Data Analysis and AI

Module 08

Date and Time Analysis with Period Comparisons

Help learners understand this topic clearly, practice it on a small example, and produce reviewable evidence before moving to the next module.

Units

  1. Unit 08.00: Date and Time Analysis with Period Comparisons: Read the schema and identify the grain
  2. Unit 08.01: Date and Time Analysis with Period Comparisons: Write the query in small testable steps
  3. Unit 08.02: Date and Time Analysis with Period Comparisons: Check row counts, joins, filters, and nulls
  4. Unit 08.03: Date and Time Analysis with Period Comparisons: Explain what the query proves and does not prove
  5. Unit 08.04: Date and Time Analysis with Period Comparisons: Save the final SQL evidence note

Module work