• Course Requirements

• Each student is responsible for monitoring his/her email account frequently. 
• Students are not permitted to use AI in this course
• Students should check for e-mail and class announcements
• Students are expected to find out class assignments for missed classes and make up missed work. 
• Students are expected to find out if any changes have been made in the class or assignment schedule.
• Students are responsible for submitting a completed assignment. Make sure it is submitted otherwise you earn a zero.
• Written work must be presented in a professional manner. Work that is not submitted in a professional manner will not be evaluated and will be returned as unacceptable.
  • There is a craft to writing.  Spelling, grammar, punctuation and diction (word usage) are all tools of that craft.  Writing at the collegiate level will show careful attention to these elements of craft.  Work that does not exhibit care with regard to these elements will be considered as inadequate for college writing and graded accordingly. 
• Students are expected to take the examinations on the designated dates.  If you are unable to take the exam on the scheduled date and know in advance, you have to make arrangements with your professor before the designated date.   

Late Work:  Assignments, including postings on discussion threads, are to be completed on time according to the timeline posted by the instructor. It is important to keep up and complete work on time.  There are no make-up exams without prior consent of the instructor. You will be deducted 10% of your grade if you submit your assignment past the due date. Assignments submitted more than a week late will earn a zero. Note that you cannot submit a late discussion post. Discussions not submitted by the due date will earn a zero.

Oracle Database 12c PL/ SQL Programming– 1st Edition By Mclaughlin, Michael ISBN 9780071812436

Oracle 12c: SQL – 3rd Edition by Casteel ISBN: 978-1-305-25103-8

Oracle 11g PL/SQL Programming 2e – 

       Joan Casteel –

       978-1-133-94736-3

ITSE 1345 – COURSE SCHEDULE 

Enhance the knowledge and understanding of Database analysis and design.

Enhance the knowledge of the processes of Database Development and Administration using SQL and PL/SQL.

Enhance Programming and Software Engineering skills and techniques using SQL and PL/SQL.

Preparation of background materials and documentation needed for Technical Support using SQL and PL/SQL.

Use the Relational model and how it is supported by SQL and PL/SQL.

Use the PL/SQL code constructs of IF-THEN-ELSE and LOOP types as well as syntax and command functions.

Solve Database problems using Oracle 12c SQL and PL/SQL. This will include the use of Procedures, Functions, Packages, and Triggers.