Module 1: Selecting columns (10 Hours)

• Onboarding | Tables
• Onboarding | Query Result
• Onboarding | Errors
• Onboarding | Bullet Exercises
• SELECTing single columns
• SELECTing multiple columns
• SELECT DISTINCT
• Learning to COUNT
• Practice with COUNT

Module 2: Filtering rows (10 Hours)

• Filtering results
• Simple filtering of numeric values
• Simple filtering of text
• WHERE AND
• WHERE AND OR
• BETWEEN
• Introduction to NULL and IS NULL
• LIKE and NOT LIKE

Module 3: Aggregate Functions (10 Hours)

• Aggregate functions
• Combining aggregate functions with WHERE
• A note on arithmetic
• It's AS simple AS aliasing
• Even more aliasing

Module 4: Sorting, grouping and joins (10 Hours)

• ORDER BY
• Sorting single columns
• Sorting multiple columns
• GROUP BY
• HAVING a great time
• All together now
• A taste of things to come