IS6030: Week 5

SQL Home Page

Course Evaluation

1. University places a large amount of emphasis on student evaluations of courses.
2. I find evaluations useful to improve the course:
• By understanding what I do well, I can work to apply it elsewhere.
• By understanding what I do not do well, I can work to do less of it.
• By understanding what you find useful, I can work to provide more of it.
• By understanding what you do not find useful, I can work to make it more useful (which may include getting rid of it).
3. I will award a single percentage point increase for the grade on the Final for all students if completion rate exceeds 90%.

Course evaluation link.

Housekeeping

1. Questions from Week 4
2. Answers to Homework 4 (on Blackboard)
3. Assessment on Week 4 Material
4. A list of all assignments and weights for grading can be found here.

Midterm Solution

Duplicates in JOINs

Click here for SQL Script.

Nested SELECT

Click here for SQL Script.

Creating tables

Click here for SQL Script.

In-Class Assignment 5

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

Importing Data into SQL

• You need to determine whether office is 32-bit or 64-bit. Click here for YouTube video.
• Click here for YouTube video on importing an Excel Workbook.
• Click here for YouTube video on importing via a .CSV or tab-delimited .TXT file.

SQL and R

• This WILL NOT be on the Final.
• To use R and SQL together, you need to install your SQL Server instance in the Windows "Data Sources (ODBC)" program. The YouTube video is here.
• If you need to download R, here is one of the mirror sites to download it.
• R Script

SQL and Excel

• This WILL NOT be on the Final.
• The YouTube video is here.

SQL and Tableau

• This WILL NOT be on the Final.
• Tableau Doc

Remaining Items:

• We do not meet next week!!!
• In-class Assignment 5
• Final
• Enjoy the winter break!