ClassInfo

CSC 452 Database Programming

Office: CDM 607
Fall 2019-2020
Class number: 12578
Section number: 701
M 5:45PM - 9:00PM
CDM 00206 Loop Campus
Course homepage: D2L

Summary

Programming in a large-scale relational database environment using procedural languages. Topics covered in the course include: procedural extension of query languages, runtime error handling, subprograms (procedures and functions), packages, database triggers, dynamic query language. Optional topics include transaction management, reliability, and security.

Detailed weekly tentative plan will be discussed in the first class. 


 



Texts

Oracle Database PL/SQL Language Reference. 12c Release 2 (12.2). January 2019.

It is available online for free download. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/lnpls/database-pl-sql-language-reference.pdf

Each week, detailed lecture notes will be provided.



Grading

Homework:                 40%
Midterm Exam:           30%
Final exam:                 30%

 



Prerequisites

(CSC453-Database Technologies or
 CSC451-Database Design or
 CSC455-Databases for Large Scale Processing)
and

( CSC401-Introduction to Programming
  or IT 411)



School policies:

Changes to Syllabus

This syllabus is subject to change as necessary during the quarter. If a change occurs, it will be thoroughly addressed during class, posted under Announcements in D2L and sent via email.

Online Course Evaluations

Evaluations are a way for students to provide valuable feedback regarding their instructor and the course. Detailed feedback will enable the instructor to continuously tailor teaching methods and course content to meet the learning goals of the course and the academic needs of the students. They are a requirement of the course and are key to continue to provide you with the highest quality of teaching. The evaluations are anonymous; the instructor and administration do not track who entered what responses. A program is used to check if the student completed the evaluations, but the evaluation is completely separate from the student’s identity. Since 100% participation is our goal, students are sent periodic reminders over three weeks. Students do not receive reminders once they complete the evaluation. Students complete the evaluation online in CampusConnect.

Academic Integrity and Plagiarism

This course will be subject to the university's academic integrity policy. More information can be found at http://academicintegrity.depaul.edu/ If you have any questions be sure to consult with your professor.

Academic Policies

All students are required to manage their class schedules each term in accordance with the deadlines for enrolling and withdrawing as indicated in the University Academic Calendar. Information on enrollment, withdrawal, grading and incompletes can be found at http://www.cdm.depaul.edu/Current%20Students/Pages/PoliciesandProcedures.aspx.

Students with Disabilities

Students who feel they may need an accommodation based on the impact of a disability should contact the instructor privately to discuss their specific needs. All discussions will remain confidential.
To ensure that you receive the most appropriate accommodation based on your needs, contact the instructor as early as possible in the quarter (preferably within the first week of class), and make sure that you have contacted the Center for Students with Disabilities (CSD) at:
Lewis Center 1420, 25 East Jackson Blvd.
Phone number: (312)362-8002
Fax: (312)362-6544
TTY: (773)325.7296