ITSE-1345 Introduction to Oracle SQL and PL/SQL


Foluke Sylvester

Credit Spring 2024


Section(s)

ITSE-1345-002 (76362)
LEC DIL ONL DIL

Course Requirements

  • Each student is responsible for monitoring his/her email account frequently. 
  • 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.
  • 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 are 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 each week the assignment is due, assignments more than a week late will earn a zero. 

Attendance/Class Participation

Attendance is mandatory. Regular and punctual class and laboratory attendance is expected of all students. If attendance or compliance with other course policies are unsatisfactory, the instructor may withdraw students from the class.


Readings

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

(lab) Oracle 11g PL/SQL Programming 2e – 

       Joan Casteel –

       978-1-133-94736-3


Course Subjects

ITSE 1345 – COURSE SCHEDULE 16 Weeks

Week

Weekly Activities

Week end dates

1

Oracle Environment

Oracle PL/SQL Development Overview – 12c PL/SQL – Chapter 1

Discussions

01/21/2024

2

Introduction to PL/SQL – Ch1

Quiz and Lab

01/28/2024

3

New Features – 12c PL/SQL – Chapter 2

PL/SQL Basics – 12c PL/SQL - Chapter3

Basic PL/SQL Block - Chapter 2 – 11g PL/SQL

Discussion and Project

02/04/2024

4

Basic PL/SQL Block - Chapter 2 – 11g PL/SQL

Quiz and Lab

02/11/2024

5

Data Handling in PL/SQL Blocks Chapter 3– 11g PL/SQL

Language Fundamentals – 12c PL/SQL – Chapter 4

Quiz, lab

02/18/2024

6

Cursors and Exception Chapter 4 – 11g PL/SQL

Control Structures – 12c PL/SQL – Chapter 5

Project and Discussion

02/25/2024

7

Cursors and Exception Chapter 4 – 11g PL/SQL

Error Management – 12c PL/SQL – Chapter 7

Quiz and lab

03/03/2024

8

Procedures - Chapter 5 – 11g PL/SQL

Collections – 12c PL/SQL – Chapter 6

Quiz and lab

03/10/2024

9

Functions - Chapter 6 – 11g PL/SQL

Project and Discussion

03/24/2024

10

Functions - Chapter 6 – 11g PL/SQL

Functions and Procedures – 12c PL/SQL – Chapter 8

Quiz and lab

03/31/2024

11

PL/SQL Packages Chapter 7 – 11g PL/SQL

Packages – 12c PL/SQL – Chapter 9

Quiz and lab

04/07/2024

12

Dependencies, Privileges - Chapter 8 – 11g PL/SQL

Triggers – 12c PL/SQL – Chapter 12

Quiz, lab, and discussion

04/14/2024

13

Database Trigger Chapter 9 – 11g PL/SQL

Large object – 12c PL/SQL – Chapter 10

Quiz and lab

04/21/2024

14

Packages and Dynamic SQL - Chapter 10 – 11g PL/SQL

Dynamic SQL – 12c PL/SQL – Chapter 13

Project and Discussion

04/28/2024

15

Packages and Dynamic SQL - Chapter 10 – 11g PL/SQL

Object Types – 12c PL/SQL – Chapter 11

Quiz and lab

05/05/2024

16

Discussion

Final Exam 12c

05/12/2024

 


Student Learning Outcomes/Learning Objectives

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.

 


Office Hours

T Th F 2:00 PM - 4:00 PM Virtual

NOTE

T Th F 2:00 PM - 4:00 PM Virtual

NOTE

Published: 01/15/2024 21:56:47