2021-2022 Pierce College Catalog 
    Apr 24, 2024  
2021-2022 Pierce College Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

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)