CST1602 Advanced Databases (Oracle)
Syllabus

COURSE DESCRIPTION
This course is designed to introduce students to SQL and PL/SQL functions for database management systems. Students will learn how to create and maintain database objects, and how to store, retrieve, and manipulate data. Students will also create PL/SQL blocks of application code that can be shared in multiple forms, reports, and data management applications. Prerequisite: CST1600 or prior knowledge of relational databases. (3 Credits) (3 Lecture, 0 Lab)

TEXT AND REFERENCES
1. ORACLE 11G:SQL-W/DVD (Student supplied textbook)
2. Laptop.  Running Windows 7 or newer. (School or Student supplied equipment)
3. Course Instructional Guide (Online)

COURSE EXPECTATIONS
See this link for additional course expectations.

COURSE EVALUATION
Student objectives and evaluations are translated to a percentage and the percentages to grades. The following percentage distribution guarantees the following grade: A:93%+, A-:90%+, B+:87%+, B:83%+, B-:78%+, C+:77%+, C:73%+, C-:70%+, D+:67%+, D:63%+, D-:60%+, F:<60%.

REQUIREMENTS
This course is lecture/lab based. The CST Staff will deliver the lectures, as well as supervise the lab. The student is expected to spend at least 45 hours per credit in self study with direction from instructors and/or instructional guides and testing.  This a three (3) credit course, so an average student is expected to spend approximately 135 hours completing this course, which includes lectures and lab. All lectures will be scheduled, with that schedule posted online.



Version Information:
Aug 25th, 2015 Original course materials. (ADB)