SQL Joins Review Lectures
Join GitHub today
GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together.
19 lines (14 sloc) 859 Bytes
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
Video
<iframe width="100%" height="720" src="https://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.
Last updated