IT 314: Guide to Oracle 10g
Spring 2008, Section 001
Time: Instructor: e-mail:
M: 7:20 pm - 10:00 pm Dr. Lam Phung lphung@gmu.edu
Place: Office: Office Hours:
Prince William: Bull Run Hall 132 Prince William: Bull Run Hall, suite 2 M: 6:00 pm - 7:00 pm, or by appointment
TA: TA’s ofiice hours: Office:
M: 6:00 pm – 7:00 pm Prince William: Bull Run Hall 122B
Course Description
This course provides coverage of Oracle database applications development, including client/server database architecture, SQL commands, Forms Builder, and more. Discussions will include new technologies, such as the new browser interface for the Enterprise Manager and iSQL. Examples of the entity-relationship model and the normalization process will be provided. Prerequisite IT 103, IT 214
Course Objectives
Upon completion of this course, successful students will be able to exhibit competency in the following topics: Client/Server Databases and the Oracle 10g Relational Database Creating and Modifying Database Tables Using SQL Queries to Insert, Update, Delete, and View Data Introduction to PL/SQL Creating Custom Forms Creating Database Reports Creating an Integrated Database Application Advanced SQL Introduction to Oracle 10g Database Administration
Textbook and Required Supplies
Text: Joline Morrison, Mike Morrison, Rocky Conrad, Guide to Oracle 10g, Course Technology 2006, ISBN 0-619-21629-8 Software: Oracle 10g
Methods of Instruction
The course will be taught through a combination of lectures, demonstrations, hands-on classroom exercises, and homework assignments.
Course Schedule
As many factors may affect the development and progress of a class, the instructor reserves the right to alter the schedule as may be required to assure attainment of course objectives. Class Date January 28 February 4 Topics Chapter 1: Oracle 10g Relational Database Quiz 1 Chapter 2: Creating and Modifying Database Tables Appendix: iSQL Quiz 2 Chapter 3: Using SQL Queries to Insert, Update, Delete, and View Data (Lessons A and B) Quiz 3 Chapter 3: Using SQL Queries to Insert, Update, Delete, and View Data (cont.) (Lesson C) Review Exam 1: Chapters 1 – 3 Chapter 4: Introduction to PL/SQL (Lesson A) Classes do not meet (Spring Break) Quiz 4 Chapter 4: Introduction to PL/SQL (Lesson B) Quiz 5 Chapter 5: Introduction to Forms Builder (Lessons A and B) Quiz 6 Chapter 5: Introduction to Forms Builder (Lesson C) Quiz 7 Chapter 7: Creating Database Reports (Lesson A) Quiz 8 Chapter 7: Creating Database Reports (Lesson B) Review Exam 2: Chapters 4, 5 and 7 Chapter 8: Creating an Integrated Database Application (Lesson A) Quiz 9 Chapter 8: Creating an Integrated Database Application (Lesson B) Quiz 10 Chapter 11: Introduction to Oracle 10g database administration Review for the Final Exam Cumulative Final Exam Due In HW 1
February 11
HW 2
February 18
HW 3
February 25 March 3 March 10 March 17 March 24 March 31 April 7 April 14
HW 4
HW 5 HW 6 HW 7 HW 8 HW 9
April 21 April 28 May 5
HW 10 HW 11 HW 12
May 12
Assignments
Homework will be assigned weekly, and you will have one week to complete each homework assignment. Homework assignments may consist of hands-on lab assignments or written questions. Labs will be hold approximately weekly. You must submit your solutions electronically through WebCT. Homework assignments will be accepted up to 48 hours past the time it was due for 80% credit. After that time, late homework will not be accepted.
If you are having trouble with a concept, you are responsible to come to office hours or to email the instructor or TA before the assignment is due. Much of your grade is determined by your performance on the homework; please do not sabotage your grade by starting assignments so late that you are unable to seek help if necessary.
Collaboration
Assignments are to be done without collaboration. If you need assistance with an assignment, you should attend my office hours or the TA's office hours, set up an appointment with either of us, or just send us email. You may not discuss a homework assignment with anyone other than the TA or your instructor. Any apparent incidents of academic dishonesty will be reported to the Honor Committee. Please consult http://www.gmu.edu/departments/unilife/honorcode.html to learn more about the Honor Code. If you have any question about whether something is permissible, ask me.
WebCT and Email
This course uses the WebCT system, which you can access at https://webct41.gmu.edu. This page contains instructions on what to do if you do not have access to WebCT. You should make sure you have access to the folder for this course through WebCT, since documents, assignments, or other important information may be distributed through this web page, and assignments must be submitted through it. You should also make sure that you read your GMU email regularly. If you want to forward this mail to another account, see the email forwarding information at http://itusupport.gmu.edu/help/keywordcontent.cfm?contentid=196.
Grading
Final grades will be calculated according to the following percentages: Homeworks (Three worst grades will be dropped) Quizzes (Two worst grades will be dropped) Midterm 1 Midterm 2 Final Exam 20% 15% 20% 20% 25%
Letter grades will then be assigned according to the following scale: Numeric Score 97 – 100 93 – 96 90 – 92 87 – 89 83 – 86 80 – 82 77 – 79 70 – 76 Letter Grade A+ A A– B+ B B– C+ C
60 – 69 0 – 59
D F
For borderline grades, class participation will be taken into account.