In-class notes for 01/22/2018

CS 284 (MCA), Interim 2018

• Project feedback this afternoon

• Log form, timely logs. Log at least 30 hours/week on your project from today through Monday 1/29

Labs and SQL

• More in-class query exercises?

Some features of SQL

• Ordering output. ______

• Naming columns. ______

• Expressions involving column names. ______

• Aggregate functions. ______

• Nested queries. ______

• Grouping (categorizing). ______

• EXCEPT, UNION, INTERSECT in queries. ______

Submitted questions on assignments and technology

Lab 10

• Help with labs

• (Testing on the command-line.)

  • last time

  • shell script

Quiz scheduling

• Tues morning or Wed morning? -- decided Wed morning

< >