CTEC1731 Enterprise Computing III

Announcements

• [Sat Dec 18 14:34:46 EST 2010]
  This course will not be offered again.

• [Wed Dec 8 10:19:02 EST 2010]
  Labs are due today by 12:30 pm and, tomorrow, start losing 10% per day.  Project is due this Friday by midnight.

• [Wed Dec 8 10:16:53 EST 2010]
  Exam takes place on Dec. 15th.  Take home exam was handed out today.  An exam preview [PPSX; 108,694 bytes] and sample take-home exam with solutions [ZIP; 194,046 bytes] have been posted.

• [Wed Oct 13 10:43:16 EDT 2010]
  Project has been posted.  See the POS_Project directory in your $HOME for the latest files.

Notes and Code

Online books (requires password)

URLs
HTML
HTML Tutorial (from W3C)
Cascading Style Sheet (CSS) examples (start here)

Introduction to databases:  PPS [351,744 bytes]  PDF [193,321 bytes]  MOV [1,545,537 bytes] added Thu Oct 1 2009
SQL databases:  PDF [147,039 bytes] HTML

Web stacks added Thu Oct 1 2009

PHP

PHP examples using mysqli (the "MySQL Improved Extension"):

• README [TXT; 1,252 bytes]
• mysqli [ZIP; 3,765 bytes]
• mysqli [TAR.GZ; 2,288 bytes]

Music Database Example

1. Database files — versions 1 & 2:

   • zip [14,303 bytes]
   • tar [81,920 bytes]

   version 3:

   • zip [16,102 bytes]
   • tarball [7,228 bytes]

2. Perl programs (version 1 only, see the README file for details):

   • zip [92,456 bytes]
   • tarball [89,881 bytes]

3. A CGI application (and updated SQL) for the music database (version 2 only, see the README file for details):

   • zip [7,378 bytes]
   • tarball [4,896 bytes]

4. A PHP application (and updated SQL) for the music database (version 3 only, see the README file for details):

   • zip [15,131 bytes]
   • tar.bz2 [11,163 bytes]
   • tar.gz [11,834 bytes]
   • tar [71,680 bytes]

Labs

Lab #0
Lab #1
Lab #2
Lab #3
Project

Downloads

InfoZip UNZIP for Windows (113K, EXE)
InfoZip ZIP for Windows (104K, EXE)
Apache/PHP/MySQL/Perl/Tidy
Secure Shell (SSH) Clients