Welcome!
  • Introduction to the Course and Your Instructors
  • WATCH ME NOW!
  • A Note from Your Humble Leaders
  • Getting Started (Downloading a Text Editor!) - All OS
  • Getting set up: No installation necessary!
  • PSA: How to preview data in a table on SQLSnack
Intro to MySQL
  • What the heck is a relational database?
  • [QUIZ] What the heck is a relational database?
  • Da SQL Basics: Skeleton of a Query
  • SQL Query Skeleton
  • [Brainbuster] Build Your First Query!
Basic Queries
  • COUNT() and GROUP BY
  • Brainbuster TWEAK
  • COUNT() and GROUP BY
  • [Brainbuster] Organize movies by rating!
  • Connecting Tables
  • Connecting Tables (Warm-up for Brainbuster)
  • [Brainbuster] Connect Tables
  • [Brainbuster] Finding your best selling products (Rental Count by Movie)
  • Having trouble understanding "connecting tables"?
  • Arithmetic & Order By
  • [Brainbuster] Finding Your Top-Performing Store
  • LEFT(), MIN() AND MAX()
  • [Brainbuster] Finding Your Active Users - Last Rental Time by Customer
  • [Brainbuster] Finding Month over Month Revenue Growth
  • DISTINCT
  • [Brainbuster] Find Distinct Films Rented Each Month
  • IN()
  • Comparison Operators and HAVING
  • [Brainbuster] Breaking Down Revenue by Store and Rating
  • Nested Queries
  • PSA: Temporary Tables on SQLSnack
  • Nested Queries vs. Temporary Tables
  • Add your new skills to LinkedIn!
BONUS Lectures
  • BONUS: JOINs
  • [Brainbuster] BONUS: JOINs
  • What is a Cohort Analysis?
  • Cohort Analysis Query: Setting the Stage
  • Cohort Analysis Query: SQL Fanciness
  • Cohort Analysis Query: Finishing Touches
Appendix A: Alternative Installation
  • Installation Guide
  • Getting Set Up: (Installation) - Mac Version
  • Getting Set Up (Installation) - Windows 32-bit Version