CIS 429 - Database IV

3 Credits

This course reinforces themes introduced in CIS 427 (Database III) and highlights essential techniques in Oracle database performance tuning. Practical exercises will be used to formulate SQL queries and tune SQL statements for optimal performance. Topics include performance diagnostics and tuning; using tuning tools and utilities; using triggers to customize information management in the Oracle database; managing memory; and tracking and managing dependencies.
Prerequisites: CIS 110, CIS 120, CIS 200, CIS 230, CIS 312, CIS 412, CIS 422, CIS 424, and CIS 427.