Class Schedule:

• Monday (10/1)                Extract, Transform, Load (ETL) (Slides Link)
• Wednesday (10/3)          ICA #4 – ETL – Excel Basics (Instructions Link)
• Friday (10/5)                   Review for Exam 1 (Study Guide Link)

Assignments:

• Bonus Assignment [Optional]: Due Monday (10/1), 11:59 pm

Group Project:

The group project starts from Monday, 10/1/18.

• You are going to analyze a data set from the Temple Analytics Challenge (Link) and to visualize your findings.
• You should work in a team of 2 to 4 members.
• Members of the same team will receive the same grade.

Due: Wednesday, 10/31/2018, 11:59 pm

Check more information here.

Check out the following for the group project.

http://community.mis.temple.edu/mis2502sec003f18/group-project/

If you do have technical issues (constant error reports, no results grid, etc.), do the following,

1. Finish writing all queries and save them in a SQL or document (.docx, .txt, …) file before actually running them. You will save time and energy.
2. Check again your code thoroughly.
3. Common mistakes are typos, wrong spacings, and inappropriate punctuation marks (“, ”, (), [], etc. ). Check correct examples for SQL syntax in the lecture slides.
4. Type but not copy queries from other sources as there may be subtle differences in formatting.
5. Read the error report carefully and see what’s wrong.
6. If it is an unsolvable problem due to the idiosyncratic nature of your computer, operating system, version of MySQL, try another computer, you can (1) download and use MySQL Workbench in a different computer at the school’s computer lab, or (2) borrow and use your friend’s or classmate’s computer if they do not have problems.

For assignment #2, the grading rule is the following,

1. Points (i.e., 5 points, 10 points, 15 points) vary across questions.
2. Full points for each question will be given if your SQL statement is COMPLETELY correct. No point even if there is a small mistake.
3. 20% off for each question if the SQL statement is correct, but the results/answer from MySQL Workbench is missing or incorrect.

BTW, I will not write you a checklist of all possible SQL statements this time for Assignment #2.

1. Overview lecture slides, ICAs, and course captures (Cavas->Modules).
2. Come to my office hour tomorrow 12:30-1:30 pm at Alter 604F if you have any question.

I will hold an additional office hour on Friday, 12:30 pm to 1:30 pm.

• Note the location is Alter 604F (a breakout room).
• Please drop by if you have any questions about SQL queries, or Assignment #2.

BTW, Assignment #2 is due Friday before class by 3:00 pm.

Submission deadlines for ICA #2.2 and Assignment #2 are extended.

See the following NEW due dates and times:

ICA #2.2: Wednesday, 9/26/18, 6:50 pm.

Assignment #2: Friday, 9/28/18, 3:00 pm (before the class).

Class Schedule:

• Monday (9/24)                ICA #2.2 – Working with SQL, part 1 (Retrieving information from the database)
• Wednesday (9/26)          Creating and updating the database (SQL CREATE, DROP, ALTER, INSERT, UPDATE, and DELETE)
• Friday (9/28)                   ICA #3 – Working with SQL, part 2 (Creating and updating the database)

Assignments:

• Assignment #2: Due Wednesday (9/26), 11:59 pm
• Bonus Assignment [optional]: Due next Monday (10/1), 11:59 pm

Office Hours:

• Monday (9/24): Speakman 201F, 3:50-4:50 pm
• Tuesday (9/25): Speakman 209, 11 am-2 pm  (hold by ITA Nathaly).
• Wednesday (9/26): Speakman 201F, 3:50-4:50 pm
• Friday (9/28): Alter 604F, 12:30-1:30 pm

SQL advanced queries are the most difficult ones in this course.

If you want to master SQL, you need to pay more attention, take more efforts, and do more practices.

I attached the SQL queries examples (Check SQL Format / Word Format) covered in the Slides 2.2. SQL 1 – Out – Advanced. You can also have access to them from the community site at Slides Deck. Please take a look and try those queries by yourself!!!

A few notes below.

• Your ICA #2.2, Assignment #2, and Exam 1 will directly rely on your skills in writing SQL queries.
• If you have not installed MySQL workbench, please do so as early as possible.
• If you have difficulty in setting up your MySQL, please contact me or ITA Nathaly.

Come to the following office hours if you have any questions regarding SQL queries：

• Monday/Wednesday: Speakman 201F,  3:50-4:50 pm;
• Tuesday (Nathaly): Speakman 209, 9/25/18, 11am-2pm.

Here are the instructions: Assignment #2 – SQL Part 1.

And here is the answer sheet: [Answer Sheet].

Due date: Wednesday, 9/26/2018, 11:59 pm.

• Complete and submit the answer sheet as a Word or PDF document through Canvas.
• You will need to use MySQL Workbench to complete the assignment.
• Please do note that equipment failure is not an acceptable excuse.
• Slides and ICAs will be your best materials for review. Also, check class captures if you miss something in the class.
• Please come to my regular office hours (M&W: 3:50 – 4:50 pm) if you have any questions.
• Do not procrastinate and start your assignment early!

There is a bonus credit assignment about creating schemas. It is optional. This is worth an additional 30% toward your Assignment #1 grade, if you choose to do it. Here are the instructions: Bonus Credit Assignment – Creating Schemas. It is due Monday, Oct 1, 11:59 pm. Submit your solution as a Word or PDF document through Canvas > Assignments.

Below is the agenda for Week 4.

Monday (9/17):

Getting Data out of a Database

Notes: Make sure you’ve reviewed the guide for setting up a connection in MySQL Workbench and reviewed the MySQL powerpoint deck. Check the previous post on MySQL setup and supplementary powerpoint.

Wednesday (9/19):

MySQL Quick Demo

ICA #2.1: Working with SQL, Part 1.

Friday (9/21):

Joining Tables, SQL Subselects, LIMIT