Course Code: CENG 254
Academic Year: 2020-2021
This course covers the Oracle implementation of the SQL programming language as well as techniques for embedding SQL in Java programs and writing static Java functions that can be called from SQL. Measures such as named constraints, referential integrity and triggers will be examined as a means of establishing business rules within a database. Students will examine the Oracle Data Dictionary and the use of the "Explain Plan" utility as an introduction to Systems Administration and Performance Tuning. Finally, students will look at a variety of techniques for establishing database connections over the internet.