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
NOTET Th F 2:00 PM - 4:00 PM Virtual
NOTEPublished: 01/15/2024 21:56:47