|CS445 - Database Management|
Facilitator: Wayne Cook
H: (970)229-9282 C: (970)690-9976
5% lost for every week a homework is late (unless other arrangements are made), no homework can be turned in past last night of class.
Which Database to Use?
Originally this course was taught using Access and the Adamski/Finnegan Tutorial book. The current recommended SQL Database is MySQL, which is a free Database available over the web. Since the programming course (CS455) uses PostgreSQL instead of MySQL, I will accept assignments using PostgreSQL instead of MySQL. Tutorials for MySQL are found on the web.
I will be adding references to various tutorials for MySQL as I determine which ones are the best. There are three scripting languages that can be used with MySQL. I will be looking for the best tutorials for PHP, Perl, and Python. Look up tutorials for these three ways of accessing MySQL and decide which one serves you best. For now, PHP seems to be the most common, but there are arguments for both Perl and Python.
Extra credit will be given for pointers to good tutorials on using SQL. Also, a good portion of this class is Analyzing a person's or group's need for a database. If you want some more information about good documents for design, please see my Q&A information for the CS432 class.
Installation of MySQL:
Please download MySQL from: http://dev.mysql.com/doc/refman/5.0/en/installing.html
Please refer to the MySQL reference manual at: http://dev.mysql.com/doc/refman/5.0/en/index.html
The assignments will be based off of the deliverables for the Final Assingment.
This site was last updated 01/16/07