Skip Navigation
 

INFO371 - Relational Databases With Oracle: PL/SQL

Course Details

Course Code: INFO371 Course ID: 2650 Credit Hours: 3 Level: Undergraduate

This course is a study and application of the procedural language overlay on the ANSI standard Structured Query Language (SQL) to enable students to access tuples, one at a time. Knowledge of this complex procedural component will enable students to develop Programming Units that are characterized by block structure, control structures, variables, constants, operators, implicit and explicit cursors, and exception handling (both system- and user-defined). This course examines study and application of procedures, functions, packages, and triggers. Knowledge of procedures, functions, packages, triggers, events, restrictions on triggers, the trigger firing sequence, and the use of triggers to perform auditing functions. This course also covers Object-Relational database concepts and Object Oriented Programming Structures (OOPS) and explores dependencies in Procedures and Functions. Students must have access to Oracle software. This software is not provided by the course material grant and must be purchased/provided by the student. Course software requirements with the appropriate versions are listed under the course materials site. (Prerequisite: INFO171 or equivalent)





Prerequisites

Course Schedule

Registration Dates Course Dates Session Weeks
07/29/19 - 01/03/20 01/06/20 - 03/01/20 Winter 2020 Session B 8 Week session
10/28/19 - 04/03/20 04/06/20 - 05/31/20 Spring 2020 Session B 8 Week session

Current Syllabi

After completing this course the student will be able to:

  • Create PL/SQL Blocks
  • Use a variety of variable types to handle data in a block
  • Process statements conditionally with control structures
  • Reuse lines of code with looping structures
  • Manage errors with exception handlers
  • Create and use procedures and functions
  • Bundle program units with packages
  • Develop database triggers
  • Use the features of Oracle-supplied packages
  • Identify program unit dependencies
  • Use dynamic SQL

Students are expected to maintain routine contact with the instructor throughout the course. While the number of contacts may vary according to the specific course and individual student need, the University requires periodic weekly contacts during the semester. Contact will consist of professor notes and email feedback. The method of the forums will be on-line related to issues concerning forum assignments, quizzes, mini case lab assignments, and exams.

TEXTBOOK READINGS
The main book for the course, Oracle9i Developer: PL/SQL Programming, will be used for textbook readings. Review the table at the end of the syllabus to see assigned readings for each week. Access the E-Book through the Resources in the classroom.


ASSIGNMENTS

There are 8 assignments for this course. The weekly assignments for this course are located under the Assignments Section of the course. You will find all the files needed to complete the projects located under Resources on the left side of the APUS classroom. The projects that are required to be completed for this course will be listed as part of the forum for the week it is due. Also, see the table at the end of the syllabus for a short list of projects and due dates.


FORUMS

The Forum assignments for this course are designed to promote interactivity among students and enhance the online learning process. The Forum provides maximum flexibility because you do not have to be online at the same time as another person and you can read what other students have written.

Forum Timing: For the forums, post your work by midnight on Wednesday, and continue to follow your classmates' posts for the remainder of the week, and post the follow-up peer responses prior to midnight on Sunday. The deadline for your Forum Posts is midnight on Wednesday evening of each week. Your follow-up posts can add additional insight to a classmate's opinions or can challenge their opinions. Use examples from the readings, or from your own research, to support your views, as appropriate. Be sure to read the follow-up posts to your own posts and reply to any questions or requests for clarification. You are encouraged to conduct research and use other sources to support your answers.

Required Participation: Please keep in mind that the forum assignments require you to make at least 1 post to the forum with at least 350 words about the topic and also respond to at least 2 peers’ posts with at least 150 words. Please be advised that there will be point deductions if you do not comply with these requirements of the assignment. Each one of you will have a different and unique experience that we can all learn from. Your participation in the Forums unleashes the power of synergy in our classroom. To facilitate this interaction, please be prompt when posting your forum work for each week; this provides time for the others to actively engage in the dialogue. For practical reasons, when you respond to other learners’ posts, please start your response by referencing their name. I will read and grade your participation by reading the forum. There is no need to also post your forum work in the assignments area of the classroom. Refer to the forum matrix at the end of the syllabus for more details on grading. I hope this is a great learning experience in this class.

Week 1 Forum: The Forum Introduction and an introduction to PL/SQL will consist of an introduction of yourself and research and analysis by students on PL/SQL. For this week, we will be discussing how you would define PL/SQL, and what some real world applications for PL/SQL are. We will also look at some advantages and disadvantages associated with PL/SQL? Finally, we will look at the PL/SQL Block Structure. In your response, be sure to include the four main sections of the block structure.
You can use your text book as well as a web search for relevant articles and information to assist you in your response. Please be advised that there will be point deductions if you do not comply with the requirements of the assignment. To get the maximum value from this class, I would encourage you to go over and above the required minimum number of responses to posts by responding to at least 2 other post as described in the instructions. Each one of you has personal insight and life experiences that are unique and invaluable to our class experience. Your participation in the Forum unleashes the power of synergy into our classroom. The main post is due by Wednesday of the week the final posting are due by Sunday. For practical reasons, when you respond to other learners’ posts, please start your response by referencing their name. I will read and grade your participation by reading the forum. I hope this is a great start to learning in this class.

Week 2 Forum: For this week’s Forum, we will be looking at errors in database technology. When writing code and working with queries in database technology, you can receive error messages. List 3 different errors that you can receive. Discuss why it is important to know how to handle these errors. A web search for relevant articles and information should be employed to assist you in your response. Also be sure to refer to your textbook for additional ideas. I want to also see that you have put some thought into the question. Also, read and respond to AT LEAST 2 other student to show that you have learned what they are describing. I want to see some good interaction for full points. To facilitate this interaction, please be prompt when posting your forum work for each week (by Wednesday); this provides time for the others to actively engage in the dialogue and post responses to you (by Sunday). For practical reasons, when you respond to other learners’ posts, please start your response by referencing their name. I will read and grade your participation by reading the forum. I hope this adds to your learning in this class.

Week 3 Forum: For the Week 3 Forum, you will be exploring cursors. How would you define a cursor? In your discussion, be sure to include 2 different types of cursors. A web search for relevant articles and information should be employed to assist you in your response. Also be sure to refer to your textbook for additional ideas. Please include any aspects that you have learned so far in the course. Discuss your findings, your experiences, likes and dislikes, and the added benefits to you as well. Explain what you struggled with or what you found that was new and exciting that you plan to use personally. I want to see that you have put some thought into the discussion. Also, read and respond to AT LEAST 2 other students to show that you have learned and can also appreciate what they are describing. Ask them questions to get a good discussion going. I want to see some good interaction for full points. To facilitate this interaction, please be prompt when posting your forum work for each week (by Wednesday); this provides time for the others to actively engage in the dialogue and post responses to you (by Sunday). For practical reasons, when you respond to other learners’ posts, please start your response by referencing their name. I will read and grade your participation by reading the forum. I hope this adds to your learning in this class.

Week 4 Forum: For the Week 4 Forum, we will be discussing program units. How would you define a program unit? Be sure to include the different types of program units in your definition. Also share a few benefits to using program units in a database environment.

A web search for relevant articles and information should be employed to assist you in your response. Also be sure to refer to your textbook for additional ideas. Please include any aspects that you have learned so far in the course. Discuss your findings, your experiences, likes and dislikes, and the added benefits to you as well. Explain what you struggled with or what you found that was new and exciting that you plan to use personally. I want to see that you have put some thought into the discussion. Also, read and respond to AT LEAST 2 other students to show that you have learned and can also appreciate what they are describing. Ask them questions to get a good discussion going. I want to see some good interaction for full points. To facilitate this interaction, please be prompt when posting your forum work for each week (by Wednesday); this provides time for the others to actively engage in the dialogue and post responses to you (by Sunday). For practical reasons, when you respond to other learners’ posts, please start your response by referencing their name. I will read and grade your participation by reading the forum. I hope this adds to your learning in this class.

Week 5 Forum: For the Week 5, we will be discussing functions and packages. We will look at what a function is, and why it is important for it to be tested prior to it being released. We will also define a package and look at they improve the efficiency of sharing data between users. We will then look at the impact this has on the end user.

A web search for relevant articles and information should be employed to assist you in your response. Also be sure to refer to your textbook for additional ideas. I want to see that you have put some thought into the discussion. Also, read and respond to AT LEAST 2 other students to show that you have learned and can appreciate what they are describing. Ask them questions to get a good discussion going. I want to see some good interaction for full points. To facilitate this interaction, please be prompt when posting your forum work for each week (by Wednesday); this provides time for the others to actively engage in the dialogue and post responses to you (by Sunday). For practical reasons, when you respond to other learners’ posts, please start your response by referencing their name. I will read and grade your participation by reading the forum.

Week 6 Forum: For the Week 6 Forum, we will be discussing dependencies. For this forum, define direct and indirect dependencies. Also, discuss why a Database Administrator may grant certain privileges to some of the database users. Describe some real-world scenarios when you or an organization might consider using them. A web search for relevant articles and information should be employed to assist you in your response. Also be sure to refer to your textbook for additional ideas.

Discuss your findings, your experiences, likes and dislikes, and the added benefits to you as well. Explain what you struggled with or what you found that was new and exciting that you plan to use personally. Again, as in the other discussions, I want to see that you have put in a lot of thought. Also, read and respond to AT LEAST 2 other students to show that you have learned and can appreciate what they are describing. Ask them questions to get a good discussion going. I want to see some good interaction for full points. To facilitate this interaction, please be prompt when posting your forum work for each week (by Wednesday); this provides time for the others to actively engage in the dialogue and post responses to you (by Sunday). For practical reasons, when you respond to other learners’ posts, please start your response by referencing their name. I will read and grade your participation by reading the forum.

Week 7 Forum: For the Week 7 Forum, we will be discussing Database Triggers. For this discussion, look at the advantages and disadvantages of Database Triggers. A web search for relevant articles and information should be employed to assist you in your response. Also be sure to refer to your textbook for additional ideas.

Discuss your findings, your experiences, likes and dislikes, and the added benefits to you as well. Explain what you struggled with or what you found that was new and exciting that you plan to use personally. Again, as in the other discussions, I want to see that you have put in a lot of thought. Also, read and respond to AT LEAST 2 other students to show that you have learned and can appreciate what they are describing. Ask them questions to get a good discussion going. I want to see some good interaction for full points. To facilitate this interaction, please be prompt when posting your forum work for each week (by Wednesday); this provides time for the others to actively engage in the dialogue and post responses to you (by Sunday). For practical reasons, when you respond to other learners’ posts, please start your response by referencing their name. I will read and grade your participation by reading the forum.

Week 8 Forum: For the Week 8 Forum, we will be discussing Communication Technology. As you explore this idea, look at communication technology and the role it plays in database technology. Also look at how it affects the efficiency and effectiveness of database technology. A web search for relevant articles and information should be employed to assist you in your response. Also be sure to refer to your textbook for additional ideas.

Discuss your findings, your experiences, likes and dislikes, and the added benefits to you as well. Explain what you struggled with or what you found that was new and exciting that you plan to use personally. Again, as in the other discussions, I want to see that you have put in a lot of thought. Also, read and respond to AT LEAST 2 other students to show that you have learned and can appreciate what they are describing. Ask them questions to get a good discussion going. I want to see some good interaction for full points. To facilitate this interaction, please be prompt when posting your forum work for each week (by Wednesday); this provides time for the others to actively engage in the dialogue and post responses to you (by Sunday). For practical reasons, when you respond to other learners’ posts, please start your response by referencing their name. I will read and grade your participation by reading the forum.

QUIZZES

There will be 2 open book quizzes to be taken after the readings are completed. Each quiz is posted in the electronic classroom under the Tests and Quizzes Section. Quiz 1 covers Chapters 1-4 and Quiz 2 covers Chapters 5-8

GRADING: Please see the student handbook to reference the University’s grading scale. My typical grading schedule is to look at your assignments throughout the week after they are due. If time allows, I will grade ahead for those of you who have worked ahead but it is my policy to grade your assignments with the rest of the class as they become due

NameGrade %
Forum 40.00 %
Week 1 5.00 %
Week 2 5.00 %
Week 3 5.00 %
Week 4 5.00 %
Week 5 5.00 %
Week 6 5.00 %
Week 7 5.00 %
Week 8 5.00 %
Assignments 40.00 %
Week 1 Assignments 5.00 %
Week 2 Assignments 5.00 %
Week 3 Assignments 5.00 %
Week 4 Assignments 5.00 %
Week 5 Assignments 5.00 %
Week 6 Assignments 5.00 %
Week 7 Assignments 5.00 %
Week 8 Assignment 5.00 %
Quizzes 20.00 %
Quiz 1 10.00 %
Quiz 2 10.00 %
Book Title:Oracle9i PL/SQL Programming - the VitalSource e-book is provided inside the classroom
ISBN:9781308237220
Publication Info:VS-McGraw-Hill
Author:Scott Urman
Unit Cost:$112.56
Electronic ISBN:1259582973
Electronic Unit Cost:$35.00
Book Title:Oracle Database 12c - Download Oracle from http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
ISBN:Software Note

Previous Syllabi

Not current for future courses.