MSBA 504    
Session Nine     
       
Assignment Due:     
  Assignment 6  
Session Materials    
  chapter 3.5  
  https://waltonlab.uark.edu/     remote  into uark epic (or horizon vm client)
 

two tables code from slide

aggregate code from slide

aggregate and having code

self join sample db

self join sql code

set operators

 
  database tutorial
   
  database design problem
   
   
Session Topics    
  SQL, T-SQL  
  database design    
  relational algebra  
       
Learning Objectives    
  TWO TABLES OR MORE (in SQL)
  AGGREGATES  (in SQL)
  AGGREGATES PART 2 query (in SQL)
  SELF-JOIN query (in SQL)
  SET OPERATORS  (in SQL)
  IMPORT database into SQL