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.