Faculty Syllabus

COURSE DESCRIPTION:

An introduction to the design and creation of relational databases. Topics include storing, retrieving, updating and displaying data using Structured Query Language (SQL) integrated into Stored Procedures, Functions, Packages, and Triggers (PL/SQL Programming).

• Credit Hours:  3

• Classroom Contact Hours per week:  2 hours 40 minutes

• Laboratory Contact Hours per week: 50 minutes

• Pre-requisite:  ITSE 2309 - Database Programming: Oracle.  Knowledge of SQL, SQL*Plus, Database Modeling and Database Normalization

• Course Type:  W – Workforce

COURSE RATIONALE:

This course is designed to teach students how to create programmed solutions using the PL/SQL procedural language. As each student is required to have a working knowledge of the programming process and understanding of the functional constructs in programming, the focus of this course is on database problems and potential solutions.

This course is part of the Computer Information Technology Database Certificate plan. Completion of this course and the prerequisite courses prepares the student for a position as an entry level Database Programmer and acts as preparation for Oracle Certification Test 2.

Approved Course Text and Teaching Materials:

1. Oracle 11g:  PL/SQL Programming – 2nd Edition, Casteel, Joan; Cengage Learning; 2013 (ISBN  978-1-333-94736-3)
2. Oracle 12c: SQL; 3rd Edition; Casteel, Joan; Cengage Learning; 2016 (ISBN  978-1-305-25103-8

Optional Course Text and Teaching Materials:

1. Oracle Database 12c PL/SQL Programming – 14th Edition, McLaughlin – McGraw Hill, 2016,  (ISBN –  9780071812436)
2. Tutorials on the Instructor’s Drive

Software: 

        Microsoft Windows 11 and Oracle 21c

 COURSE OBJECTIVES / LEARNING OUTCOMES:

1. Recognize the basic concepts of Database analysis and design.
2. Recognize the processes of Database Development and Administration using SQL and PL/SQL.
3. Develop Programming and Software Engineering skills and techniques using SQL and PL/SQL.
4. Investigate background materials and documentation needed for Technical Support using SQL and PL/SQL.
5. Recognize the Relational model and how it is supported by SQL and PL/SQL.

SCANS COMPETENCIES:

SCANS (Secretary’s Commission on Achieving Necessary Skills):

Refer to http://www.austincc.edu/cit/courses/scans.pdf for a complete definition and explanation of SCANS.  The following list summarizes the SCANS competencies addressed in this particular course:

INSTRUCTIONAL METHODOLOGY:

This course will have 75% lecture and 25% laboratory.  The student will be required to do assigned readings from the text and handouts as well as scheduled individual labs to reinforce the material covered in class.  Scheduled tests will be used to assess the progress of the student toward achievement of the course objectives.  The COSC/CIT open labs are available for students for work outside of scheduled lab time.
 

GRADING SYSTEM

Grade Policy: Grade will be assigned based both on concepts and practical application. Exams, homeworks, and programming assignments will be a part of the grade. There are no extra credit assignments given in this course.

Examinations: Three major exams will be given during the semester.  If you miss an exam, a make-up exam will be given for excused absences only.  Contact the instructor before or immediately after the emergency that caused you to miss the exam.  Only one exam, exam 1 or exam 2, may be missed and eligible for make-up.  There will be NO make up for EXAM 3.  If you miss EXAM 3, you will receive a grade of zero (0).

Grading Criteria: Each student’s grade for this course consists of the following four parts:

            Semester Exams (2 @ 21% each)     42%
            Final Exam (Comprehensive)              24%
            Programming Assignments                 24%
            Homework Assignments                     10%

   An overall grade will be assigned on the following grading scale:

            A - 90.00% to 100%
            B - 80.00% to  89.99%
            C - 70.00% to  79.99%
            D - 60.00% to  69.99%
            F  - Below   60%

Attendance/Class Participation: Regular and timely class participation in discussions and laboratory attendance is expected of all students.  If attendance or compliance with other course policies is unsatisfactory, the instructor may withdraw students from the class.

In the event the college or campus closes due to unforeseen circumstances (for example, severe weather or other emergency), the student is responsible for communicating with their professor during the closure and completing any assignment or other activities designated by their professor as a result of class sessions being missed.

Students who do not come to class and do not contact the instructor during the first week of class will be classified as "Never Attended" and will be ineligible for financial aid and automatically withdrawn from the course.

Course Schedule: Please note that schedule changes may occur during the semester.  Any changes will be reflected in the schedule in Blackboard and will be accompanied by an email to all students.

Programming assignments:  Programming assignments must be the product of the student's independent effort.  Each programming assignment must be submitted on Blackboard on before the due date and time indicated on Blackboard and also in the programming assignment schedule. Programming assignments, except Program 10,  can be turned in up to seven days after the due date with a late penalty of 50% per week.  Scheduling of computer time outside of regular lab time is the student’s responsibility.

Homework assignments:  All homework assignments must be submitted on Blackboard on or before the due date and time indicated on Blackboard and also in the homework schedule.

Guidelines for Programming Assignments:

1. Begin each programming assignment with an initial comment block that includes the following:  your name, instructor’s name, assignment number, assignment due date, course and section number, and name of Java file.  See the Coding Rules document for details.
2. You will be graded on BOTH program accuracy and program style.
3. Programming assignments must meet requirements, exactly as specified, and pass testing to receive full credit.
4. All programming assignments must be submitted to Blackboard to receive credit.  No programming assignment will be accepted via e-mail.
5. Programming assignment links are automatically/programmatically removed from Blackboard at 11:59pm Central Time two weeks after the due date.  Therefore, it is not possible to submit programming assignments two weeks after the due date.

Class and Lab Preparation:  All students are expected to read the chapters to be covered in class and familiarize themselves with the week’s assignments before class.  In this way, you will obtain much better value from the class, and can make best use of lab time.

Withdrawal:  It is the responsibility of each student to ensure that his or her name is removed from the roll should he or she decides to withdraw from the class.  The instructor does, however, reserve the right to drop a student should he or she feel it is necessary.  If a student decides to withdraw, he or she should also verify that the withdrawal is submitted before the Final Withdrawal Date.  The Final Withdrawal Date for this semester is Monday, April 27, 2026.  The student is also strongly encouraged to keep any paperwork in cases a problem arises.

Students are responsible for understanding the impact that withdrawal from a course may have on their financial aid, veterans’ benefits, and international student status.  Per state law, students enrolling for the first time in Fall 2007 or later at any public Texas college or university many not withdraw (receive a W) from more than six courses during their undergraduate college education.  Some exemptions for good cause could allow a student to withdraw from a course without having it count towards this limit.  Students are strongly encouraged to meet with an advisor when making decisions about course selection, course loads, and course withdrawals.

In situations where the student fails to withdraw before the withdrawal date, and the student's work is below the minimum acceptable standards, a letter grade of F will be given.

Incomplete Grade: A student may receive a temporary grade of “I” (Incomplete) at the end of the semester only if ALL of the following conditions are satisfied:

1. The student is unable to complete the course during the semester due to circumstances beyond their control.

1. The student has earned at least half of the grade points needed for a “C” by the end of the semester.

1. The student requests the grade in person at the instructor’s office and necessary documents are completed before the last day of the semester.

To remove an “I”, the student must complete the course by two weeks before the end of the following semester.  Failure to do so will result in the grade automatically reverting to an “F”.

Miscellaneous:  Classes will start and end on time.  If you must arrive late or leave early, please minimize any disruption to your fellow students by sitting quietly close to the door.

Click here for the College Policies.

Click here for the Student Support Services

Click here for the COSC/CIT Generative AI (GAI) Policy

Please note that schedule changes may occur during the semester.  Any changes will be announced in class and posted as a Blackboard Announcement.  Students are expected to read and study the assigned material, per the course schedule, BEFORE each class, this includes programming assignments!