Recall
Set 1: Quick Check
Match common text functions and trace nested cleaning expressions.
Text and Date Analysis
Normalize common text fields and filter unambiguous date ranges with dialect awareness.
Start Chapter PracticeChapter plan
What you will be able to do
- Apply documented text and date transformations.
- Study time
- 28–34 minutes, self-paced
- Course
- SQL for Data Analysis (Beginner)
- Practice order
- Four sets, completed in sequence
Chapter practice
Practice in chapter order
10 activities · 80% mastery target
Start set 1
Guided application
Set 2: Core Practice
Normalize text, build half-open date ranges, and document dialect-sensitive syntax.
Hands-on
Set 3: Workplace Task
Clean support-ticket subjects and calculate follow-up dates in SQLite.
Independent check
Set 4: Mastery Check
Predict a substring and independently filter a complete calendar month.