CSC220 Schedule 2010

Back to Main Page

---

Weekly Schedule

Week	Topics	Reading
Week 1 9/08	Wednesday 9/08 Introduction and syllabus Overview of the project Some pictures Google Maps example (Generated by walkmeter) 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	Unix Shells (on wikipedia) Bash Beginners Guide All about redirection with Bash
Week 2 9/13	Mon 9/13 Lab 1: playing with bash pipes and redirection, stdout, stderr sort Wed 9/15 How to change your login shell automatically cut cat programming, bash scripts variables for loops Lab 2 An example script illustrating features we will not cover in class, but that are important and useful. Another example illustrating how to test file system-parameters. Lab #1 (Mon) Lab #2 (Wed) Homework #1 and Solution Programs	A good reference: The GNU Bash manual
Week 3 9/20	Monday 9/20 Crontab Example (Cron Syntax) php architecture of a Web Server Apache public_html chmod a+r, chmod a+rx phpinfo.php: simple test fibonacci1.php: generates fibonacci numbers fibonacci2.php: fibonacci numbers in a list fibonacci3.php: fibonacci numbers in a table fibonacci4.php: fibonacci numbers in a while loop fibonacci5.php: only the even fibonaccis. Wednesday 9/22 phpinfo() test using Php as interpreter (on hadoop110) Arrays in php: sample programs Lab 3 Lab #3 on Php Homework #2 and Solution Programs	THE MAIN PHP REFERENCE Definition of a Web Server Definition of a Web Browser List of TCP and UDP Ports The TCP Protocol the UDP Protocol The main reference on HTML forms Difference between Post and Get methods References on how to write HTML forms
Week 4 9/27	Monday 9/27 HTML Forms form1.htm processform1.php echoform.php (a simple php file to test forms) form2.htm : a form displaying many different input options. Lab 4 Php functions dealing with arrays and strings Testing tricks and warnings. Example: the strpos() function Creating Php functions Exercise: processing KML coordinates. 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	Php tutorials: a good place from where to start investigating Php array-operations Php string-operations
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 Robustness form that reloads themselves: example, link Another example Catching email messages programmatically. Python Example Notes on DBMS Homework #4 and Solutions	Php htmlspecialchars() function Introduction to databases and MySql on Google.code MySql Tutorial on dev.mysql.com Chapter 1 (required reading) and Chapter 2 of Garcia-Molina, Ullman and Widom's Database Systems book. Instamapper: discovery of the week, found by Jon.
Week 6 10/11	Monday Fall Break Wednesday Lab 5 Food for thought... Lab 5 on MySQL Homework 5 and Solutions	MySQL Tutorial: an e-book with some good information. Check it out.
Week 7 10/18	Monday 10/18 Something to play with: MySql Workbench, a GUI for MySql Anatomy of a query <=== good reading! More notes on DBMS Exercises Wednesday Difference between joins (inner and outer) Views Indexes Feedback on Homework #4 Thursday -- Take-home Midterm Exam, available here!	Anatomy of a SQL query Joins Joining tables Indexes Creating an Index How MySQL uses Indexes B-Trees (used for indexes) Views Creating a View Using a View
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 mysql_connect() mysql_select_db() mysql_query() mysql_fetch_array() mysql_close() 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 Lab 6 Lab 7 Homework 6 <--- due 11/4/10
Week 9 11/01	Monday 11/01 Mysql Injection Examples http://unixwiz.net/techtips/sql-injection.html mysql_real_escape_string to the rescue! Final Project: Discussion [Image:CSC220ProjectDiagram2.jpg | right|150px]] Uploading/Downloading text files uploadFile0.htm: the form uploadFile1.php : the php that processes the form downloadFile0.php: a program display simple html and calling upon downloadFile1.php downloadFile1.php: a php program dumping the contents of the saved text file. uploadImages.php: example program Php Sessions ($_SESSION array) | Blobs: storage for binary data Random subdirectories, md5 hashing, in general, and with php. Wednesday 11/03 GPS demo by Jon Caris
Week 10 11/08	Monday 11/08 Presentation on GIS file formats by Jon Caris
Week 11 11/15
Week 12 11/22	Wednesday: Thanksgiving Break Friday: Thanksgiving Break
Week 13 11/29
Week 14 12/06
Week 15 12/13	Monday: Last Class

Links and Resources

Bash Shell

• Bash Beginners Guide

Linux Utilities

• Good information on Grep (Thanks Sharon!)

MySQL

• MySQL Tutorial ebook.
• Examples of Common Queries on dev.mysql.com
• Select Syntax on dev.mysql.com
• Counting rows with count()

Maps/GIS

• The State of Mapping APIs, Adam DuVander, O'Reilly Radar, 7 Sept. 2010.

• Directions for installing Google Earth under Fedora.

Tips & Tricks

• How to change your login shell automatically

Miscellaneous Information

• 

(c) D. Thiebaut 2010, Dept. Computer Science, Smith College.