Instructor: Bruce Donald Campbell
Faculty, Continuing Education - RISD
Director, Watersheds Project
While many software application packages address front-end issues, if you want to deepen your experience in the back-end of web design, then MySQL is well worth investigating. With a reported incidence of ten million installations, it is simply the most popular open source database available because of its extreme adaptability to run dependably on more than twenty platforms. Additionally, it is a popular database management tool for such web applications as YouTube, Friendster and Wikipedia, not to mention that it has a particular affinity for PHP. Besides the primary objective of examining the system for its practical applications, MySQL is worth exploring, as it has many uses that are within the General Public License.
Class participation - 20%
Written project - 60%
Homework assignment - 20%
There are no required books associated with this class — instead, we will use the wide resource library available from the Web.
The recommended book for this class is the third edition of the book PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide, by Larry Ullman (December 2007), but the book is most useful in conjunction with the Dynamic Web Design with PHP course provided within the Web Design and Development RISD certificate program.
Course Handouts and On-line Readings as identified below and in class.
welcome to mysql
- Database Modeler
- Database Administrator
- Data Analyst
- Wikipedia's introduction to relational databases which provides a good overview of the relevance of Edwin Codd's relational database theory
- If interested, read a more in-depth investigation of relational database theory.
- Pre-test: To focus your attention on your learning objectives, please write a 1000 word essay of your current understanding of relational databases and how databases enable the information age.
- Read the class project instructions.