IS6030: Week 4

SQL Home Page

Housekeeping

1. Questions from Week 3
2. Answers to Assessment
3. Answer to Homework
4. Take-home Midterm will be available from Monday, Nov. 19 at 8:00AM to Dec 1 at 1:00PM. It is open notes and open book, but it is an individual effort. Material only through Week 3 (NOT today's class) will be tested.

More Functions

1. EOMONTH
2. ISNULL and NULLIF

CASE

UNION

JOINs

In-Class JOIN Example

Homework

Click here for SQL Script. Once completed, submit via Blackboard. Due 12/01/2018 by 1:00PM.

Midterm

Test administered through Blackboard - 25 short answer questions - Due 12/01/2018 by 1:00PM

For Next Class

1. Review this week's material
2. Read Itzik Ben-Gan if you have not already:
• Subqueries, pgs. 133-139
• Table expresions, pgs. 161-165
3. Dec 1 class
• This will be our LAST in-class meeting.
• We will begin with the last assessment of the course. It will cover material from today's course.
• We will cover the basics of nested querying, which WILL be part of the final.
• We will also cover SQL querying through other software, which WILL NOT be part of the final.
• A link to the Final will be made available. It will be due Dec 8, 2018 by 4:50PM (end of last class time).