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.
Course Content
A. Procedural Languages
B. Design
C. Structured Query Language
D. Programming terms and concepts
E. SQL Tuning
F. Debugging
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.
Degree Outcomes
Information Competency: Graduates will be able to seek, find, evaluate and use information and employ information technology to engage in lifelong learning. Program Outcomes: Leverage IT best practices to analyze and present database and information resources that support the mission of the healthcare industry while complying with healthcare industry standards such as HIPAA (Health Insurance Portability and Accountability Act). Model and develop database and data warehouse applications to meet user needs.
Lecture Contact Hours 50
Lab Contact Hours 0
Clinical Contact Hours 0
Total Contact Hours 50
Add to Portfolio (opens a new window)
|
