Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Practice SQL!
INTRODUCTION
General Advice | How to get the most out of this course (3:56)
1) Set up your Data Server!
BEST PRACTICES #1 - Tips for using SQL Workbench
2) Get the data and put it into SQL! (7:27)
3) What is in the dataset? (3:27)
4) pgAdmin vs. SQL Workbench (1:31)
LECTURE #1 | Practice data selection!
LEARNING MATERIALS
Exercise #1
Solution for Exercise #1 (3:25)
Exercise #2
Solution for Exercise #2 (1:29)
Exercise #3
Solution for Exercise #3 (1:24)
LECTURE #2.1 | The SQL WHERE clause with Multiple Filters
LEARNING MATERIALS
Exercise #4
Solution for Exercise #4 (2:59)
Exercise #5
Solution for Exercise #5 (1:46)
Exercise #5+
Solution for Exercise #5+ (1:02)
BEST PRACTICE #2 - So you got an error message?
Exercise #6
Solution for Exercise #6 (2:15)
Exercise #7
Solution for Exercise #7 (1:08)
Exercise #8
Solution for Exercise #8 (2:34)
Exercise #9
Solution for Exercise #9 (3:58)
LECTURE #2.2 | The SQL WHERE clause with Multiple Filters and the ORDER BY clause
LEARNING MATERIALS
Exercise #10
Solution for Exercise #10 (1:22)
Exercise #11
Solution for Exercise #11 (1:07)
Exercise #12
Solution for Exercise #12 (1:53)
Exercise #13
Solution for Exercise #13 (2:31)
Exercise #14
Solution for Exercise #14 (2:38)
LECTURE #3.1 | Practicing SQL Functions (COUNT, SUM, AVG, MIN, MAX)
LEARNING MATERIALS
Exercise #15
Solution for Exercise #15 (2:12)
Exercise #16
Solution for Exercise #16 (2:23)
Exercise #17
Solution for Exercise #17 (0:56)
Exercise #18
Solution for Exercise #18 (0:54)
Exercise #19
Solution for Exercise #19 (3:39)
EXTRA --» Exercise #20
Solution for Exercise #20 (4:10)
LECTURE #3.2 | Practicing SQL Functions (COUNT, SUM, AVG, MIN, MAX) and the GROUP BY clause
LEARNING MATERIALS
Exercise #21
Solution for Exercise #21 (4:46)
Exercise #22
Solution for Exercise #22 (1:56)
Exercise #22+
Solution for Exercise #22+ (1:15)
Exercise #22++
Solution for Exercise #22++ (1:40)
Exercise #23
Solution for Exercise #23 (1:47)
Exercise #24
Solution for Exercise #24 (3:26)
EXTRA Exercise
Solution for the EXTRA Exercise (2:33)
BEST PRACTICE #3 - Think in iterations!
LECTURE #4 | JOIN-ing SQL tables
BEFORE ANYTHING ELSE…. (4:33)
LEARNING MATERIALS
Exercise #25
Solution for Exercise #25 (2:22)
Exercise #26
Solution for Exercise #26 (1:43)
Exercise #27
Solution for Exercise #27 (1:29)
Exercise #28
Solution for Exercise #28 (2:43)
Exercise #29
Solution for Exercise #29 (4:13)
Exercise #30
Solution for Exercise #30 (3:28)
BEST PRACTICE #4 - Visualize your SQL data in Google Data Studio!
LECTURE #5 | SQL Subqueries and the HAVING clause
LEARNING MATERIALS
Exercise #31
Solution for Exercise #31 (3:51)
Exercise #31 (Alternative Solution)
Solution for Exercise #31 (Alternative Solution) (1:49)
Exercise #32
Solution for Exercise #32 (3:14)
Exercise #33
Solution for Exercise #33 (6:15)
LECTURE #6 | Extra Exercises (Case Study)
BEFORE ANYTHING ELSE…. (0:52)
Exercise #34
Solution for Exercise #34 (4:15)
Exercise #35
Solution for Exercise #35 (1:31)
Exercise #36
Solution for Exercise #36 (3:22)
Exercise #37
Solution for Exercise #37 (1:26)
Exercise #38
Solution for Exercise #38 (3:41)
MORE EXERCISES WITH SEND-A-TREE DATA...
SUMMARY, GOOD BYE & WHERE TO GO NEXT
Summary, Good Bye & Where to Go Next... (2:47)
Solution for Exercise #36
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock