Ch. 1 - Selecting columns
Welcome to the course!
Onboarding | Tables
Onboarding | Query Result
Onboarding | Errors
Onboarding | Bullet Exercises
Beginning your SQL journey
SELECTing single columns
SELECTing multiple columns
SELECT DISTINCT
Learning to COUNT
Practice with COUNT
Ch. 2 - Filtering rows
Filtering results
Simple filtering of numeric values
Simple filtering of text
WHERE AND
WHERE AND OR
WHERE AND OR (2)
BETWEEN
BETWEEN (2)
WHERE IN
Introduction to NULL and IS NULL
NULL and IS NULL
LIKE and NOT LIKE
Ch. 3 - Aggregate Functions
Aggregate functions
Aggregate functions practice
Combining aggregate functions with WHERE
A note on arithmetic
It’s AS simple AS aliasing
Even more aliasing
Ch. 4 - Sorting and grouping
ORDER BY
Sorting single columns
Sorting single columns (2)
Sorting single columns (DESC)
Sorting multiple columns
GROUP BY
GROUP BY practice
GROUP BY practice (2)
HAVING a great time
All together now
All together now (2)
A taste of things to come
About Michael Mallari
Michael is a hybrid thinker and doer—a byproduct of being a StrengthsFinder “Learner” over time. With nearly 20 years of engineering, design, and product experience, he helps organizations identify market needs, mobilize internal and external resources, and deliver delightful digital customer experiences that align with business goals. He has been entrusted with problem-solving for brands—ranging from Fortune 500 companies to early-stage startups to not-for-profit organizations.
Michael earned his BS in Computer Science from New York Institute of Technology and his MBA from the University of Maryland, College Park. He is also a candidate to receive his MS in Applied Analytics from Columbia University.
LinkedIn | Twitter | michaelmallari.com