CIS 495 - Database Systems II

This advanced course builds upon the design, implementation, testing, and manipulation concepts and techniques learned in CIS 395. The course starts with a review of the relational model, entity relational diagrams, normalization, and basic SQL. Database administration topics presented include security, back-up and recovery. Advanced topics in design techniques include indexing structures and data storage. Advanced implementation topics include SQL programming, store procedure and triggers. Advanced manipulation topics include transaction processing concurrency control.
Prerequisite: CIS 395 or departmental approval

Course Credit: 3

Lab Hours: 2HRS.
Sample Syllabus