Sql Joins Review Lectures

  • 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

MP4

View SQL Joins Review Lectures on Learn.co and start learning to code for free.

Unlock your future in tech
Learn to code.

Learn about Flatiron School's Mission

With a new take on education that falls somewhere between self-taught prodigy and four-year computer science degree, the Flatiron School promises to turn students with little programming experience into developers.

In the six months since the Manhattan coding school was acquired by WeWork, it has spawned locations in Washington, D.C., Brooklyn, and London. Now, WeWork is opening a fourth Flatiron School location, this time in Houston.

Adam Enbar, Flatiron School's cofounder, believes now is the time to grow. "How the world is changing has impacted working and learning in very similar ways. We think education fundamentally is about one thing: enabling people to pursue a better life."

Learn. Love. Code.
Students come to Flatiron School to change their lives. Join our driven community of career-changers and master the skills you need to become a software engineer or a data scientist.
Find Us