Section 1 : Welcome!
Lecture 1 Introduction to the Course and Your Instructors copy 00:03:50 Duration
Lecture 2 WATCH ME NOW! 00:02:47 Duration
Lecture 3 A Note from Your Humble Leaders
Lecture 4 Getting Started (Downloading a Text Editor!) - All OS 00:02:20 Duration
Lecture 5 Getting set up No installation necessary! 00:02:40 Duration
Lecture 6 PSA How to preview data in a table on SQLSnack

Section 2 : Intro to MySQL
Lecture 1 What the heck is a relational database 00:05:57 Duration
Lecture 2 Da SQL Basics Skeleton of a Query 00:10:24 Duration
Lecture 3 [Brainbuster] Build Your First Query!

Section 3 : Basic Queries
Lecture 1 COUNT() and GROUP BY 00:06:24 Duration
Lecture 2 Brainbuster TWEAK
Lecture 3 [Brainbuster] Organize movies by rating! 00:04:18 Duration
Lecture 4 Connecting Tables 00:06:41 Duration
Lecture 5 [Brainbuster] Connect Tables 00:05:33 Duration
Lecture 6 [Brainbuster] Finding your best selling products (Rental Count by Movie) 00:05:24 Duration
Lecture 7 Having trouble understanding connecting tables
Lecture 8 Arithmetic & Order By 00:11:38 Duration
Lecture 9 [Brainbuster] Finding Your Top-Performing Store 00:04:15 Duration
Lecture 10 LEFT(), MIN() AND MAX() 00:11:04 Duration
Lecture 11 [Brainbuster] Finding Your Active Users - Last Rental Time by Customer
Lecture 12 [Brainbuster] Finding Month over Month Revenue Growth 00:04:53 Duration
Lecture 13 DISTINCT 00:06:29 Duration
Lecture 14 [Brainbuster] Find Distinct Films Rented Each Month 00:04:10 Duration
Lecture 15 IN()
Lecture 16 Comparison Operators and HAVING 00:05:26 Duration
Lecture 17 [Brainbuster] Breaking Down Revenue by Store and Rating 00:04:57 Duration
Lecture 18 Nested Queries
Lecture 19 PSA Temporary Tables on SQLSnack
Lecture 20 Nested Queries vs 00:02:50 Duration
Lecture 21 Add your new skills to LinkedIn!

Section 4 : BONUS Lectures
Lecture 1 BONUS JOINs 00:19:19 Duration
Lecture 2 [Brainbuster] BONUS JOINs
Lecture 3 What is a Cohort Analysis 00:06:50 Duration
Lecture 4 Cohort Analysis Preamble
Lecture 5 Cohort Analysis Query - Time to get FANCY 00:19:19 Duration
Lecture 6 A Request from Your Humble Leaders

Section 5 : Appendix A Alternative Installation
Lecture 1 Installation Guide
Lecture 2 Getting Set Up (Installation) - Mac Version 00:16:48 Duration
Lecture 3 Getting Set Up (Installation) - Windows 32-bit Version 00:13:14 Duration