Archive for February 2012

Setting up SAS OnDemand Account

Here are the instructions for setting up your SAS OnDemand account. We will need this starting on March 21. However, you should set this up immediately to avoid problems; sometimes there are delays in approving your student license for the software. If your account isn’t set up, you can’t complete the assignments!!

SAS OnDemand requires that you have the Java Runtime Environment installed on your computer. The labs have this, but your home PC may not. So first, get the right version of the Java environment here (you can also get it from the Java web site by going through the setup instructions, but this is easier).

For Mac users: Java should come pre-installed with OSX. Check here for more information.

Then follow the instructions step-by-step to create your account. It’s not difficult, but there are a lot of steps and you must follow them carefully.

2/27 and 2/29: turning transaction data into analytical data

Dimensional Modeling

Data cube example: ProductsSample

2/22 Exam 1 Review

Exam1 Review

Protected: Assignment 3: SQL IN (DUE 2/29)

There is no excerpt because this is a protected post.

Protected: Reference answer for in-class exercise #4

There is no excerpt because this is a protected post.

Protected: 2/20 In-class exercise

There is no excerpt because this is a protected post.

Extra SQL Practice

SQL practice player draft with answers

Protected: Reference answer for HW1: ERD

There is no excerpt because this is a protected post.

Exam 1 Study Guide

Here’s the study guide for Exam 1.

Our first exam is scheduled for 2/24. Please make sure that you go through the study guide before the review session (2/22) next week.

2/15 and 2/17 Creating and Updating the database

Lecture Slides: SQL 2 – In