SQL (continued) 
SQL (continued)
by Harvard / David J. Malan
Video Lecture 7 of 10
Copyright Information: This course's content is licensed by David J. Malan of Harvard University under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
3 ratings
Views: 1,758
Date Added: December 26, 2009

Lecture Description

MySQL. SQL. MySQL types. Indexes, constraints. MySQL Functions. JOIN. Race conditions. INSERT ... ON DUPLICATE KEY UPDATE. Transactions (InnoDB). Locks (MyISAM). CSV.

Course Index

Course Description

In this course, David J. Malan gives 13 video lectures on Building Dynamic Websites. 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.


There are no comments. Be the first to post one.
  Post comment as a guest user.
Click to login or register:
Your name:
Your email:
(will not appear)
Your comment:
(max. 1000 characters)
Are you human? (Sorry)