Skip Navigation
 

Schedule of Classes

View Academic Calendar

INFO221 - Relational Database Concepts

 

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 software. This software is not provided by the course material grant and must be purchased/provided by the student. Course software requirements with the appropriate versions are listed under the course materials site. Note for Mac Users: Access 2013 does not work on Mac OS. APUS recommends using Windows OS even on Mac. If Mac OS must be used it is recommended to install Windows on Parallels (purchased separately) and install Access 2013 on the Windows OS via Parallels.

 

Prerequisites

N/A

Corequisites

N/A

Schedule of Classes

Registration Dates Course Dates Session
05/28/18 - 11/02/18 11/05/18 - 12/30/18 Fall 2018 Session I - 8 Week session
06/25/18 - 11/30/18 12/03/18 - 01/27/19 Fall 2018 Session D - 8 Week session
07/30/18 - 01/04/19 01/07/19 - 03/03/19 Winter 2019 Session B - 8 Week session
08/27/18 - 02/01/19 02/04/19 - 03/31/19 Winter 2019 Session I - 8 Week session
09/24/18 - 03/01/19 03/04/19 - 04/28/19 Winter 2019 Session D - 8 Week session
10/29/18 - 03/29/19 04/01/19 - 05/26/19 Spring 2019 Session B - 8 Week session

Course Materials

Previous Syllabi

Book Title: Students must have access to the required software. APUS does not supply this software. The listing can be found at http://apus.libguides.com/bookstore
ISBN: N/A
Publication Info: N/A
Author: N/A
Unit Cost: N/A
Electronic ISBN: N/A
Electronic Unit Cost: N/A

Book Title: Concepts of Database Management, 7th ed.- the VitalSource e-book is provided inside the classroom
ISBN: 9781111825911
Publication Info: Cengage
Author: Pratt Adamski Staff
Unit Cost: $120.10
Electronic ISBN: 9781285501154
Electronic Unit Cost: $35.00