MySQL DML - Querying Data

LESSON 7, Part 1: Joining MySQL Tables - Introduction Part 2

This lessons continues on by covering table cardinality and showing how to use E-R diagrams as a means of joining SQL tables.

MySQL Topics Covered

  • Joining in WHERE clause
  • Knowing which tables to join
  • Using E-R Diagrams
  • Physical Models
  • Logical Models
  • Table Cardinality
  • 1:1 table relationships
  • 1:M table relationships
  • M:M table relationships