Q2: Sessions, Schema, SQL

These questions come primarily (but not exclusively) from:

• The DB Sessions Page/Handout
• The Schema Page
• The SQL Crash Course Page & Lyric Database Handout
• The Joins Page

Test questions can also come from pages linked directly from a lesson, lectures, class discussion, class assignments, handouts and packages.  Questions that are labeled [Critical Thinking] may not come directly from any text but instead need to be deduced or extrapolated by you based on your studies thus far.

In the case of this test, be sure to install the lyric database tables (linked on the SQL Crash Course Page) and run the commands against the tables via Adminer.  Here's the zip file: SQL Query Crash Course Zip File

You have 24 hours to email me questions about the test. To miss a due date on a test is to incur a zero score.