Designing a database is a critical first step when developing database-driven applications.  In a matter of two days, you will clearly and effectively go through the entire process of database development and implementation. Through lecture, discussion, problems, and case studies, this course will cover: Database systems and models, Relational database Model, Entity-Relationship (ER) Modeling, normalization of database tables, an introduction to Structured Query Language (SQL), database design, transaction management and concurrency control, distributed database management systems, object oriented databases, the data warehouse, databases in electronic commerce, Web database development, and database administration.

Important note: This is a web-based online course developed and offered by Cleveland State University (Division of Continuing Education). To participate you need to have average web skills, a computer, Internet access, and an e-mail address. All other directions will be provided to you, via email and Blackboard, during the course. You will need to log into the course web site at least once for each of the lessons. Your work and access time will be monitored by the instructor. You must begin the course within the first week of the time period and may request a one week grace period to conclude all lessons if necessary.

Prerequisite: Working knowledge of Microsoft Windows

You'll learn to:

1) Discuss relational database systems and models.
2) Identify database normalization and how it pertains to structured data storage.
3) Create a multi-table relational database.
4) Use the structured query language (SQL) to retrieve, update, and delete data.
5) Discuss transactions and concurrency control and the role these play in maintaining data integrity.
6) Identify how databases can be used in a web environment.