OLDB (Online Databases with MySQL and PHP) - DIT 15998

Databases are now the most common place to store organizational information and the internet is fast becoming the most popular way to access information. The combination of the two, with appropriate security, gives staff, management and clients instant access to the information they need no matter where they are in the world. This course covers all the steps required to communicate with a database via a web browser, including the fundamental principles of good database design, practical hands-on database development, the widely popular MySQL language that most databases use, and an introduction to the programming commands that are needed to communicate with databases from a web browser. Before taking this course, the student is expected to understand the basic operation of a computer and the internet, client-server concepts, basic UNIX commands and have the ability to create simple XHTML pages and forms. No previous database or programming experience is required. An internet web server will be provided. The following software will be used: Microsoft Access, MySQL, PHP, various HTML editors, UNIX and an Apache web server.