Prerequisite CIS 261 with 2.0 or better; or instructor permission.

Course Description
An advanced course in Structure Query Language (SQL). Students will develop script files, stored procedures, and procedural language units, as well as diagnose and tune performance problems.

Student Outcomes
1. Manage procedural language program constructs.
2. Describe the procedural language development environments.
3. Create, execute, and maintain procedures, functions, packages and database triggers.
4. Design procedural language packages and program units effectively.
5. Describe T-SQL or PL/SQL supplied packages.
6. Describe the causes of performance problems.
7. Write and tune procedural language code effectively to maximize performance.
8. Use diagnostic tools to gather information about SQL statement processing.

Print this Page

Facebook this Page (opens a new window)

Tweet this Page (opens a new window)

Add to Portfolio (opens a new window)