INFO221 - Relational Database Concepts
View Academic Calendar
This course is an introduction to the concepts, management issues, and advantages of relational database management systems. Topics include data definition, data manipulation, relational algebra, Structured Query Language (SQL), and Online Transaction Processing (OLTP) systems. This course examines database design, normalization for OLTP systems, Codd’s rules for OLTP systems, data integrity, database system functions (journaling, forward recovery, backward recovery), database security (authentication and authorization), and database administration. This course also explores distributed databases, Online Analytic Processing (OLAP) systems, data warehouses, and object-oriented databases. Students must have access to Microsoft Access 2007 (or higher) software. This software is not provided by the course material grant and must be purchased/provided by the student.
Prerequisites
N/A
Corequisites
N/A
Schedule of Classes
| 09/26/11 - 02/26/12 |
03/05/12 - 04/29/12 |
Winter 2012 Session D - 8 Week session |
| 10/31/11 - 03/25/12 |
04/02/12 - 05/27/12 |
Spring 2012 Session B - 8 Week session |
| 11/28/11 - 04/29/12 |
05/07/12 - 07/01/12 |
Spring 2012 Session I - 8 Week session |
| 12/26/11 - 05/27/12 |
06/04/12 - 07/29/12 |
Spring 2012 Session D - 8 Week session |
| 01/30/12 - 06/24/12 |
07/02/12 - 08/26/12 |
Summer 2012 Session B - 8 Week session |
Course Materials
| Book Title: |
Concepts of Database Management, 7th ed. - E-book links provided inside the classroom
|
| ISBN: |
1111825912
|
| Publication Info: |
Cengage
|
| Author: |
Pratt Adamski Staff
|
| Unit Cost: |
$76.00
|
| |
| Book Title: |
Students must have access to required software. APUS does not supply this software.
|
| ISBN: |
Software Note
|
| Publication Info: |
N/A
|
| Author: |
N/A
|
| Unit Cost: |
N/A
|
| |
| Book Title: |
Stateside & Canadian Students: The e-book is available online and the location/access information is provided in the classroom. If you wish to purchase the hard copy text, you may do so through the bookseller of your choice.
|
| ISBN: |
Online Text Note
|
| Publication Info: |
N/A
|
| Author: |
N/A
|
| Unit Cost: |
N/A
|
| |
