Almost weekly labs will be posted here once they are available.

• Lab 7 (March 10/12): Database application program
  A sample program using prepared statements
  and a sample program using unprepared statements
  and their Makefile for the compilation (Note that g++-4.9 is the compiler that works with our version of Oracle, and it is only installed on otter but not on cubs.)
  You must use your sqlplus password to connect to Oracle when executing the database application programs.
  
  
• Lab 6 (March 3/5): SQL Aggregation queries
  And its sample solution
  
  
• Midterm Week (February 24/26): To be fair, we don't have official lab tasks this week. But you can look ahead to next week's lab tasks to practice for our midterm.
  
  
• Lab 5 (February 10/12): SQL, Algebra and Datalog queries
  And its sample solution
  
  
• Lab 4 (February 3/5): SQL, Algebra and Datalog query with projection, selection and join
  And its sample solution
  
  
• Lab 3 (January 27/29): SQL DDL and update queries
  
  
• Lab 2 (January 20/22): Simple SQL queries and some Oracle SQL functions
  
  
• Lab 1 (January 13/15): Getting familiar with Oracle
  and Oracle command line commands
  or through the web interface of Oracle