ITSE-1345 Introduction to Oracle SQL and PL/SQL
Foluke Sylvester
Credit Spring 2023
Section(s)
ITSE-1345-001 (56932)
LEC MW 5:30pm - 6:50pm DIL DLS DIL
LAB MW 6:50pm - 7:15pm DIL DLS 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.
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
|
Week |
Weekly Activities |
Week end dates |
|
1 |
Introduction Oracle Environment |
01/22/2023 |
|
2 |
Introduction to PL/SQL – Ch1 Quiz, Lab |
01/29/2023 |
|
3 |
PL/SQL Basics – Chapter3 Quiz, Lab |
02/05/2023 |
|
4 |
New Features – 12c PL/SQL – Chapter 2 Basic PL/SQL Block - Chapter 2 – 11g PL/SQL Quiz, Project |
02/12/2023 |
|
5 |
Language Fundamentals – 12c PL/SQL – Chapter 4 Data Handling in PL/SQSL Blocks Chapter 3– 11g PL/SQL Quiz, lab |
02/19/2023 |
|
6 |
Control Structures – 12c PL/SQL – Chapter 5 Cursors and Exception Chapter 4 – 11g PL/SQL Quiz, Project |
02/26/2023 |
|
7 |
Error Management – 12c PL/SQL – Chapter 7 Cursors and Exception Chapter 4 – 11g PL/SQL Quiz, lab |
03/05/2023 |
|
8 |
Collections – 12c PL/SQL – Chapter 6 Procedures - Chapter 5 – 11g PL/SQL Quiz, lab |
03/12/2023 |
|
|
Spring Break |
03/19/2023 |
|
9 |
Functions - Chapter 6 – 11g PL/SQL Project |
03/26/2023 |
|
10 |
Functions and Procedures – 12c PL/SQL – Chapter 8 Functions - Chapter 6 – 11g PL/SQL Quiz, lab |
04/02/2023 |
|
11 |
Packages – 12c PL/SQL – Chapter 9 PL/SQL Packages Chapter 7 – 11g PL/SQL Quizzes, lab |
04/09/2023 |
|
12 |
Triggers – 12c PL/SQL – Chapter 12 Dependencies, Privileges - Chapter 8 – 11g PL/SQL Quiz, lab |
04/16/2023 |
|
13 |
Large object – 12c PL/SQL – Chapter 10 Database Trigger Chapter 9 – 11g PL/SQL Quiz, lab |
04/23/2023 |
|
14 |
Dynamic SQL – 12c PL/SQL – Chapter 13 Packages and Dynamic SQL - Chapter 10 – 11g PL/SQL Quiz, Project |
04/30/2023 |
|
15 |
Object Types – 12c PL/SQL – Chapter 11 Packages and Dynamic SQL - Chapter 10 – 11g PL/SQL Quiz, Lab |
05/07/2023 |
|
16 |
Review Final Exam 12c |
05/14/2023 |
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
Th F 6:00 PM - 7:00 PM Zoom
NOTEPublished: 02/10/2023 19:21:25