Objectives:
- Modeling Schema using ERD/UML
- Correlating data across tables using JOINS and foreign keys.
- JOINs for a belongs to relationship
- JOINs for a has many relationship.
- LEFT JOIN vs INNER JOIN
- Multiple JOINs for a has many through relationship.
- Aggregate functions SUM(), COUNT()
- GROUP BY for aggregate functions.
Discuss SQL, Schema, JOINS, LEFT JOINS, aggregate functions SUM(), COUNT() with GROUP BY
<iframe width="100%" height="720" src=" Videohttps://www.youtube.com/embed/qfB1MRnzk4g?rel=0&showinfo=0" frameborder="0" allowfullscreen></iframe>
View SQL Joins Review Lectures on Learn.co and start learning to code for free.