Lectures / Lecture 6: SQL, Continued / Source Code / PDF

Today's websites are increasingly dynamic.  Pages are no longer static HTML files but instead generated by scripts and database calls.  User interfaces are more seamless, with technologies like Ajax replacing traditional page reloads.  This course teaches students how to build dynamic websites with Ajax and with Linux, Apache, MySQL, and PHP (LAMP), one of today's most popular frameworks.  Students learn how to set up domain names with DNS, how to structure pages with XHTML and CSS, how to program in JavaScript and PHP, how to configure Apache and MySQL, how to design and query databases with SQL, how to use Ajax with both XML and JSON, and how to build mashups.  The course explores issues of security, scalability, and cross-browser support and also discusses enterprise-level deployments of websites, including third-party hosting, virtualization, colocation in data centers, firewalling, and load-balancing.      This is OpenCourseWare, licensed by
      David J. Malan      of Harvard University under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.  Visit http://cs75.tv/2009/fall/ for more material, including prior semesters and other courses.

Technology

Education

Today's websites are increasingly dynamic. Pages are no longer static HTML files but instead generated by scripts and database calls. User interfaces are more seamless, with technologies like Ajax replacing traditional page reloads. This course teaches students how to build dynamic websites with Ajax and with Linux, Apache, MySQL, and PHP (LAMP), one of today's most popular frameworks. Students learn how to set up domain names with DNS, how to structure pages with XHTML and CSS, how to program in JavaScript and PHP, how to configure Apache and MySQL, how to design and query databases with SQL, how to use Ajax with both XML and JSON, and how to build mashups. The course explores issues of security, scalability, and cross-browser support and also discusses enterprise-level deployments of websites, including third-party hosting, virtualization, colocation in data centers, firewalling, and load-balancing. This is OpenCourseWare, licensed by David J. Malan of Harvard University under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License. Visit http://cs75.tv/2009/fall/ for more material, including prior semesters and other courses.

Share Lectures / Lecture 6: SQL, Continued / Source Code / PDF

Sign up to save your podcasts

Lectures / Lecture 6: SQL, Continued / Source Code / PDF

Lectures / Lecture 6: SQL, Continued / Source Code / PDF