Skip to course content
Free SQL course

SQL for Data Analysis and AI

Module 09

Text Fields, Categorisation, and Feature Preparation

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 09.00: Text Fields, Categorisation, and Feature Preparation: Read the schema and identify the grain
  2. Unit 09.01: Text Fields, Categorisation, and Feature Preparation: Write the query in small testable steps
  3. Unit 09.02: Text Fields, Categorisation, and Feature Preparation: Check row counts, joins, filters, and nulls
  4. Unit 09.03: Text Fields, Categorisation, and Feature Preparation: Explain what the query proves and does not prove
  5. Unit 09.04: Text Fields, Categorisation, and Feature Preparation: Save the final SQL evidence note

Module work