Week
Topics
Reading
Week 1 9/08
Wednesday 9/08
Introduction and syllabus
Overview of the project
What we'll use this semester
Sources of information
Linux shells
what is a shell (see wikipedia )?
different choices: Bourne shell, C shell, Z shell, Korn shell, Bash (Bourne Again) shell
The Bash shell
default shell for Mac, GNU operation system, and many Linux variants
has been ported to MS-DOS
configuration files: .bash_profile, .bashrc
important commands:
ls
rm
cat
cd
pwd
grep, -i, -l, -v, -A, -B
wc
chmod
chown
head & tail
tail -f
history
watch
Week 2 9/13
Mon 9/13
Lab 1 : playing with bash
pipes and redirection, stdout, stderr
Wed 9/15
Week 3 9/20
Monday 9/20
Wednesday 9/22
phpinfo() test
using Php as interpreter (on hadoop110)
Arrays in php: sample programs
Lab 3
Week 4 9/27
Monday 9/27
Lab #4 on Forms
Mini assignment for Wed 9/29 : create an organizational chart for the project. What needs to happen? What tools will be needed? How/where is the data stored? How is the data observed?
Homework #3 and Solution programs
Week 5 10/04
Monday 10/04
Project overview. See pictures here .
Below, a video created by Jon for the class. Thanks Jon!
Wednesday 10/06
Week 6 10/11
Wednesday
Lab 5
Food for thought...
Week 7 10/18
Monday 10/18
Wednesday
Difference between joins (inner and outer)
Views
Indexes
Feedback on Homework #4
Thursday -- Take-home Midterm Exam, available here !
Week 8 10/25
Monday 10/25
A word about the Solution for Homework 5
Indexes
B-Trees
PRIMARY INDEX
INDEX
UNIQUE
FULL TEXT
Lab 6
Wednesday 10/27
Php + MySql
mysqlSkel.php A simple php program that interacts with a mysql database. Warning: this program is not robust!
formSkel.php A self-reloading form that interacts with a mysql database. Warning: this code is not robust!
Lab 7
Week 9 11/01
Monday 11/01
Uploading/Downloading text files
Wednesday 11/03
Week 10 11/08
Monday 11/08
Wednesday 11/10
Presentation on Processing and data visualization by Eitan Mendelowitz
Week 11 11/15
Monday 11/15
Wednesday 11/17
Week 12 11/22
Monday 11/22
Wednesday 11/24 -- Thanksgiving Break
Week 13 11/29
Monday 11/29
Wednesday 12/1
Week 14 12/06
Monday 12/06
Wednesday 12/08
Week 15 12/13
Monday -- Last Class