|
|
|
Dec 26, 2024
|
|
CIS 269 Advanced SQL Programming and Tuning (5 credits)
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.
Add to Portfolio (opens a new window)
|
|
|
