Perl, SQL, and Web Publishing Security


Andrew Cantino


Course Introduction

Welcome! This is the homepage for Perl, SQL, and Web Publishing Security, an informal summer course taught through Networking & Systems at Haverford College in June, 2005. The intent of this summer training was to expose the broader computing center staff (along with others) to advanced publishing topics, the cPanel interface, and to demonstrate what is necessary to manage, support and secure dynamic web sites.

While the course is over, these online class notes are thorough and are written to stand alone. They may prove helpful to those wishing to learn about online content delivery, cPanel, Perl, CGI, and online security. References to people.haverford.edu and ACC refer back to the origins of the course, but the topics discussed are general. Simply substitute your own UNIX shell/cPanel hosting account.

These notes cover a number of advanced topics commonly used in web environments that provide rich dynamic content. Although advanced topics are covered, the training starts at an introductory level, and no prior programming background is required. We start with a brief introduction to HTML and UNIX, then move on to Perl scripting and other advanced topics.

Lessons

This course is divided into a series of lessons. The links below lead to class notes for each of these lessons. I have tried to write these notes as stand-alone tutorials. Hopefully they will be helpful. Parts of these notes are based off of my ExCo course, taught in 2003.

  1. Lesson 1: The Internet, HTML, and UNIX
  2. Lesson 2: Introduction to Perl
  3. Lesson 3: cPanel
  4. Lesson 4: Files and CGI
  5. Lesson 5: Perl Security and Regular Expressions
  6. Lesson 6: Fantastico
  7. Lesson 7: SQL and phpMyAdmin
  8. Lesson 8: Conclusions



This document was generated using AFT v5.094