Catalog Description: Course topics include database application programming using a high performance, high concurrency multi-user database management system. This course covers the SQL programming language including Data Definition Language, Data Manipulation Language, and Data Control Language. The course then focuses on a procedural database programming language including control structures, composite datatypes, explicit cursors, exception handling, and writing embedded SQL applications. 2.0 hours discussion, 2.0 hours activity. Formerly CSCI 276.
Course Objectives:
The objectives are for the student to:
become proficient with the SQL*Plus programming environment
develop and debug SQL scripts
develop and debug PL/SQL scripts
be able to generate formatted reports using appropriate SQL*Plus environment variables
be able to successfully pass the Oracle Certified Professional Exam in SQL and PL/SQL Programming
Course Outcomes:
Students shall be able to:
1. design SQL and PL/SQL scripts that are correct and efficient
2. write SQL and PL/SQL scripts that demonstrate knowledge of:
restricting and sorting data, writing functions, displaying data from multiple tables, using group functions and subqueries
inserts, updates and deletes on data.,
creation of tables, constraints, views and other database objects
using PL/SQL to declare variables, write executable statements and interact with the Oracle server
writing control structures, composite datatypes, explicit cursors, and exception handling
writing embedded SQL in applications written in other languages
Class/Laboratory schedule:
One hundred minutes a week activity
Accreditation Category Content:
This course embodies a significant portion of (a) Problem Analysis and (b) Solutions Design
Topic
Percentage
Hours
Algorithms
20%
9
Data Structures
20%
9
Software Design
30%
14
Concepts of Programming
20%
9
Relationship of Course to Program Objectives:
This course supports the achievement of the following program objectives:
All students will be able to analyze and solve computing problems, or problems in related areas, and to continually upgrade their knowledge and skills
College of Engineering, Computer
Science, & Construction Management
California State University, Chico
Chico, CA 95929-0003
530-898-5963 webmaster@ecst.csuchico.edu
