CIS 269 SQL Programming II (5 credits)
Prerequisite CIS 261 with 2.0 or better; or instructor permission.
Course Description
The second of a two-course series on Structured Query Language (SQL). This class includes the development of scripts, views, stored procedures, functions and triggers, and also covers applying and managing database transactions, performance tuning and database security.
Course Content
A. Structured Query Language (SQL) Scripts
B. SQL functions, stored procedures and triggers
C. Database Transaction Management
D. Database performance tuning and indexes
E. Azure Cloud SQL Database (DB)
Student Outcomes
1. Create and use SQL programming constructs
2. Use and apply the SQL development environments
3. Create, execute, and maintain procedures, functions, scripts and triggers
4. Use diagnostic tools for SQL statements
5. Tune databases for optimal performance
6. Apply database transaction management and concurrency control
Degree Outcomes
Information Literacy: Graduates will be critical users, creators, and disseminators of information by examining how information is created, valued, and influenced by power and privilege.
Critical, Creative, and Reflective Thinking: Graduates will evaluate, analyze, synthesize, and generate ideas; construct informed, meaningful, and justifiable conclusions; and process feelings, beliefs, biases, strengths, and weaknesses as they relate to their thinking, decisions, and creations.
Program Outcome: Collect, analyze, integrate and query data from disparate sources.
Lecture Contact Hours 50
Lab Contact Hours 0
Clinical Contact Hours 0
Total Contact Hours 50
Potential Methods
A. Student Demonstration
B. Individual and Group Projects
C. Practice Exercises
D. Instructor Observation
Add to Portfolio (opens a new window)
|
