Course Description

SQL, Data Storage Technologies, and Web-Data Integration

Web, Online, Summer 2013

Instructor: Daniel Parshall

6/24 - 8/23, 2013

Cost: $875 | 3 Credits

Design and create your own database. Access it online using PHP. Find reliable, systematic and organized ways to store information so that it can be searched, browsed and used to make informed decisions. Learn SQL basics. Create queries. Retrieve data and write data with MySQL. Manage session and cookies. Explore MySQL's storage engines, data types, administration utilities, security features and data import/export facilities.

Topics include:

• Requirements to define the scope of a database design
• Retrieval and modification of data using SQL
• Use of PHP and MySQL to store, access and query a Web database
• XML for building and accessing unique data sets
• Web security issues that relate to PHP
• Web application built with PHP with MySQL technologies to create data-driven web applications

View the course introduction

Prerequisites

• Completion of Server-Side Programming Using PHP or equivalent coursework or experience

Schedule Notes

This is an asynchronously scheduled online course; students start and end the course as a group, but do not adhere to specific class meeting times.