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:
Morris-Murphy - Oracle 9I: SQL with an Introduction to PL/SQL.
Course Technology - ISBN - 0619212845