CSCI12 Sharing Topics and Slides

UPDATED (SEPTEMBER 22)

ATTENTION THE FILES CAN ONLY BE OPENED IN MS POWERPOINT 2000 OR 2003

The following are the topics (with the date of report) and links of the slides:

Lesson 3:

Single Row Functions (September 16, 2010)

www.projectarchive.comuf.com/278.ppt

Lesson 4:

Displaying Data from Multiple Tables (September 21, 2010)
www.projectarchive.comuf.com/279.ppt

Lesson 5:

Aggregating data using Group Functions (September 23, 2010)


Lesson 6:

Subqueries (September 28, 2010)



Note:

• Limit your sharing for only 20 minutes.
• Assignment will be give after each report
• Each sharing is equivalent to one quiz in Prefinal

The tables to be used as reference for the examples are the following: