[PROG1735] Working with the One-to-many relationships (GROUP BY, HAVING, etc.)
In this video series, we discuss how to correctly insert child records, how to select child records when you don't have a parent record ID and various ways to aggregate your data.
Table of Contents:
00:00 - Database Changes/Updates since last time
04:37 - How not to write INSERT queries for child records.
07:26 - Correct child table INSERTs using subqueries
12:30 - SELECT child data using subqueries
13:14 - How to SELECT from multiple tables using INNER JOIN
19:03 - INNER JOIN to get all child records of a parent entity
21:22 - How to SELECT aggregate information for joined tables
23:40 - Using GROUP BY with SELECT and JOIN
30:32 - SELECT using GROUP BY without JOINs
34:58 - SQL SELECT's order of execution
38:09 - Filtering GROUP BY output with HAVING
