Section 1 : Introduction

Lecture 1 Don't let your reporting system hold you back 0:24
Lecture 2 Who this course is for
Lecture 3 What is SQL 4:12

Section 2 : Prepare to Code in SQL

Lecture 4 Get familiar with phpMyAdmin 3:45
Lecture 5 Understand the demo database

Section 3 : Use SQL to Report Data

Lecture 6 Retrieve data with SELECT 5:31
Lecture 7 Filter results with WHERE clause 5:4
Lecture 8 Use LIKE, IN, and wildcards with WHERE 5:39
Lecture 9 Sort SQL results with ORDER BY 0:0
Lecture 10 Use string functions on your data 6:41
Lecture 11 More advanced string functions 8:35
Lecture 12 Change report headings with alias 2:28
Lecture 13 Use date functions with WHERE

Section 4 : Group Your SQL Results

Lecture 14 Use GROUP BY with count 5:46
Lecture 15 Filter grouped results with HAVING
Lecture 16 De-duplicate with SELECT DISTINCT 6:30
Lecture 17 Merge rows with GROUP BY 2:24

Section 5 : Merge Data from Multiple Tables

Lecture 18 Make your queries faster 1:47
Lecture 19 Understand SQL indexes and keys 7:16
Lecture 20 Visualize your database 7:59
Lecture 21 Merge data across tables with JOIN 5:2
Lecture 22 Understand SQL JOINS 4:16
Lecture 23 Combine rows with SQL UNION
Lecture 24 Merge data across tables with IN 2:11
Lecture 25 Select from a selection with subqueries 2:56

Section 6 : More Advanced SQL

Lecture 26 Save your queries using a VIEW 8:28
Lecture 27 Use variables 5:17
Lecture 28 Use functions 8:4
Lecture 29 Use procedures 4:58