DATA 201: Database Technologies for Data Analytics

Instructor: Ron Mak (http://www.cs.sjsu.edu/~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.
  
  
• Intro 5
  Queries with counting, grouping, and subqueries.
  
  
• Your turn!
  Submit your own SQL code for execution.
  
  

Web server: www.apropos-logic.com