SQL and Class-Related Examples List

CIS 180 L - Section 3
Intro to SQL
Spring 2003

• Class session 9, 4-4-03: concatenating columns, simple ASCII reports using SQL*Plus
  • 180class9.sql - post-class version
    
    
• Class session 8, 3-28-03: union/intersect/minus, "full" select statement, intro to views and sequences
  • 180class8.sql
  • Summary of full select explanation
    • "plain text" version
    • RTF (Rich Text Format) version
    
    
• Class session 7, 3-24-03: aggregate functions, group-by clause, and having clause within a SQL select statement
  • 180class7.sql - post-class version of SQL script
    
    
• Class session 6, 3-14-03: SQL commit, rollback, update, and delete
  • 180class6.sql - SQL script built in-class
    
    
• Class session 5, 3-10-03: using nested selects (subselects) WITHIN a SQL select statement
  • 180class5.sql - SQL script built in-class
    
    
• Class session 4, 3-7-03: SQL drop table statement, SQL create table statement, and SQL insert statement
  • 180class4.sql - SQL script built in-class (and polished a bit *after* class...)
    
    
• Class session 3, 3-3-03: equi-joins using SQL select statements (and table aliases, too)
  • 180class3.sql - SQL script built in-class
    
    
• Class session 2, 2-28-03: simple selection using SQL select statements
  • 180class2.sql - SQL script built in-class
    
    
• Class session 1, 2-24-03: intro to SQL*Plus, simple projection using SQL select statement
  • 180class1.sql - examples made after class
  • UNIX handout (in RTF - Rich Text Format)
  • set_up_ex_tbls.sql - script to reload tables already pre-loaded into your class SQL account, just in case!