Week 1 Relating

Relational Databases. Relationships: One-to-one, One-to-many, Many-to-many. Entity Relationship Diagrams. Keys: Primary Keys, Foreign Keys. Subqueries. IN. Joins: INNER JOIN, Outer Joins, LEFT JOIN, RIGHT JOIN, FULL JOIN, NATURAL JOIN. Sets: INTERSECT, UNION, EXCEPT. Groups: GROUP BY, HAVING.

• Lecture
  • Notes
  • Slides
    • Keynote
    • PDF
  • Source Code
    • Index
    • PDF
    • Zip
  • Video
    • CS50 Video Player
    • YouTube
• Check for Understanding 1
• Problem Set 1