DATA 225 Database Systems for Analytics

Instructor: Ron Mak

Introduction to SQL Queries

• Intro 1
  Student and Teacher tables with no relationships.
  
  
• Intro 2
  Contact table with one-to-one relationships.
  
  
• Intro 3
  Class table with many-to-one relationships.
  
  
• Intro 4
  Takes table with many-to-many relationships.
  
  
• Show SQL
  Display the SQL code for each query.
  
  
• My turn!
  Submit my own SQL code for execution.
  
  

Web server: www.apropos-logic.com