The second in a two course sequence applies the knowledge of BCS260 to administer and implement a relational database system. Topics covered may include: embedded SQL; PL/SQL; advanced/optimized SQL queries; transaction management including concurrency and recovery; schema refinement; higher-level normal forms; integrity; security; and database administration development. Credits: 3.00
BCS 260 with a grade of C or better.
At the completion of this course, students will:
Celko, SQL for Smarties, Fourth Edition: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems), ISBN: 0123820227