Section 1 : Welcome!

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

Section 2 : Intro to MySQL

Lecture 7 What the heck is a relational database 5:57
Lecture 8 Da SQL Basics Skeleton of a Query 10:24
Lecture 9 [Brainbuster] Build Your First Query!

Section 3 : Basic Queries

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

Section 4 : BONUS Lectures

Lecture 31 BONUS JOINs 19:19
Lecture 32 [Brainbuster] BONUS JOINs
Lecture 33 What is a Cohort Analysis 6:50
Lecture 34 Cohort Analysis Preamble Pdf
Lecture 35 Cohort Analysis Query - Time to get FANCY 19:19
Lecture 36 A Request from Your Humble Leaders Pdf

Section 5 : Appendix A Alternative Installation

Lecture 37 Installation Guide Text
Lecture 38 Getting Set Up (Installation) - Mac Version 16:48
Lecture 39 Getting Set Up (Installation) - Windows 32-bit Version 13:14