Pei-yu Chen

virgin_short_700k

There are a number of videos here which are all related to each other and were created in collaboration with Microsoft’s BI group. The videos reference a suite of tools called ProClarity.  They are all posted under a category called BI Contents Please focus on the following: Watch the Virgin Record video – short and […]

If you submitted 5 cans you received 2 points.  If you submitted 4 cans you received 4.5 points.

Please contact Michelle if there is a discrepancy.

As I posted in an announcement earlier, due to a prior commitment, office hours will be changed tomorrow to 10 – 11 AM.  I will be approximately 10 minutes late for class.  We will be finishing up SQL tomorrow with the last of aggregation and a review of nested queries.  If time permits, we will […]

Office hours will be rescheduled to 10 – 11 on 11/30.  In addition, class will start 15 minutes late at 12:45

We are starting aggregation tomorrow.  You’ll definitely want to Chapter 29 before class!  I posted a new presentation summarizing the lab.  Make sure to review it.

Treats for those that answer the questions correctly 🙂

I am very sorry but I have food poisoning and will not be able to attend class tomorrow.  I will try and create a voice over power point of the artist in class SQL assignment so we will not miss any content.  We will be starting aggregation on Thursday.  You can hand in lab 4 […]

I will be rescheduling office hours next Tuesday 10/19 to Thursday 10/21 from 11:15 – 12:15 in my office in Speakman 209C.  I need to do a presentation during our regular office hour time.  I apologize in advance for any inconvenience this may cause.

Average:  75.3 (C)

Grade distribution:

A
14

B
15

C
16

D
3

F
7

We will review the exam in the beginning of Tuesday’s class.  Please note the last day to withdraw from class is 11/1 (http://www.temple.edu/registrar/acad_cals_2010-2011.html)

A few people have emailed me about question 7 in the lab and have indicated that they have received a parent key error.  We discussed this in class a few times including last Tuesday and Thursday.  If you note, the last question on the lab is VERY similar. We will discuss for a few moments […]

As we discussed in lab, for lab 2 you should write your insert statements and then run at the SQL prompt.  Then runs your describe command at the SQL prompt.  Copy your command and the output into the appropriate space on the word document.  For the last 2 questions you are only answering the question […]

As we discussed in class on Thursday, exam 1 has been rescheduled to 10/7.  Please see the calendar on blackboard.  We will be starting lab 3 on Thursday