Harvard Extension School Computer Science E-75: Building Dynamic Websites

Lecture 0: DNS, HTTP, XHTML, and CSS. DNS. Web hosts. Virtual private servers. SSH. SFP. Validity. Cross-browser issues. Yahoo! UI Library (YUI). Forms. Available in Flash , MP3 , and QuickTime formats, along with slides .

Lecture 1: PHP. HTTP. Apache. mod_rewrite. BIND. XAMPP. Forms. PHP. suPHP. Variables. Types. References. Superglobals. Arrays. Loops. Available in Flash , MP3 , and QuickTime formats, along with slides and source code .

Lecture 2: PHP, Continued. Forms. Regular expressions. XML. DOM. XPath. OOP. Authentication. .htaccess. SSL. Cookies. Sessions. Available in Flash , MP3 , and QuickTime formats, along with slides .

Lecture 3: SQL. RSS. Authentication. Cookies. Tables. MySQL. phpMyAdmin. SQL. Available in Flash , MP3 , and QuickTime formats, along with slides and source code .

Lecture 4: SQL, Continued. MySQL. SQL. MySQL types. Indexes, constraints. MySQL Functions. JOIN. Race conditions. INSERT ... ON DUPLICATE KEY UPDATE. Transactions (InnoDB). Locks (MyISAM). CSV. Available in Flash , MP3 , and QuickTime formats, along with slides and source code .

Lecture 5: JavaScript. JavaScript. noscript. Statements. focus(). Validation. Regular expressions. Global objects. Objects. Arrays. OOP (prototype-based). Event handlers. CSS properties. blink. YUI Event Utility. Frameworks. YUI Library Utilities. YUI Library Controls/Widgets. Quirks. Static code analysis. Debuggers. Compressors. Available in Flash , MP3 , and QuickTime formats, along with slides and source code .

Lecture 6: Ajax. DOM. XMLHttpRequest. Methods. Properties. Content Types. JSON. PHP + JSON. Progress. Frameworks. YUI Connection Manager. Available in Flash , MP3 , and QuickTime formats, along with slides and source code .

Lecture 7: Mashups. Google Maps. Latitude, Longitude. Google Maps API. Shuttleboy.com. Google News. RSS. Available in Flash , MP3 , and QuickTime formats, along with slides and source code .

Lecture 8: Security. Obvious Threats. suPHP. Cookies. Session Hijacking. SSL. Public-Key Cryptography. Diffie-Hellman (DLP). SQL Injection Attacks. The Same Origin Policy. Attacks. CSRF/XSRF. XSS. Available in Flash , MP3 , and QuickTime formats, along with slides and source code .

Lecture 9: Scalability. Vertical Scaling. Horizontal Scaling. PHP Acceleration. PHP Accelerators. Load Balancing at Layer 4. Load Balancing with BIND. Load Balancing at Layer 7. Sticky Sessions. Load Balancers. Caching. .html. MySQL Query Cache. memcached. MySQL. Replication: Master-Slave. Replication: Master-Master. Load Balacing + Replication + Partitioning. High Availability. MySQL Cluster. Available in Flash , MP3 , and QuickTime formats, along with slides .

Lecture 10: CSS. Cascading Style Sheets. Available in Flash , MP3 , and QuickTime formats, along with slides .

Lecture 11: Frameworks. Model-view-controller. CakePHP. JQuery. Available in Flash , MP3 , and QuickTime formats, along with slides .