| Instructor | Tom Gutnick tgutnick@nvcc.edu tom_gutnick@principia.edu (alternate address) 703.450.2506, ext. 37208 (NVCC voice mail) 571.449.6775 Instant messaging: mluleki [AOL], 259577982 [ICQ], tomgutnick [Yahoo!], emakati@hotmail.com [MSN], sanibonani@gmail.com [Google] |
|---|---|
| Course content | Presents a working introduction to PL/SQL programming within the Oracle RDBMS environment, including PL/SQL fundamentals of block program structure, variables, cursors, exceptions, procedures, functions, triggers, and packages. (See the college-wide course content summary at www.nvcc.edu/depts/academic/coursecont/ summaries/ITD134.pdf.) |
| Prerequisites | Successful completion of ITD 132 Structured Query Language |
| Class location and hours | Room LW 231, Thursdays 7:00–9:40 PM |
| Office hours | By appointment, Thursdays 6:15–7:00 PM. (Other times may be arranged.) Consultation also available by phone, e-mail, and IM. If you are having problems with the class material, you are encouraged to contact me right away. |
| Text | Oracle 10g Developer: PL/SQL Programming, by Joan Casteel, 2008, ISBN 1-4239-0136-3. |
| Grading | 20% quizzes 20% homework 10% class participation 25% mid-term exam 25% final exam Grading scale: A=90-100%, B=80-89%, C=70-79%, D=60-69%, F=0-59% |
| Class web site | Available through your college
Blackboard account. I will post relevant materials here, including updated versions of this syllabus and class schedule, details on class assignments (homework and projects), the PowerPoint slides used in class, additional reference material, etc. |
| Assignments |
All written assignments and projects are due at the beginning of class on the due date; if you will be absent, assignments may be turned in via e-mail. Late submissions will not receive full credit. |
| Attendance & help | Your presence, regular and thorough preparation, and participation in class are expected. If you are unable to attend a class, contact me in advance. Class sessions will often cover material beyond what is covered in the textbook. If you do not attend regularly and do all assignments, you are likely to find it difficult to complete the course successfully. If you find that you are floundering, please don't just stop coming to class. Talk to me and, together, we'll work on getting you through the semester successfully. On the other hand, if you decide to drop the class, it is your responsibility to deal with the necessary paperwork on a timely basis. Having trouble making sense of your assignments? The Counseling Center will lend you a video on how to develop better note-taking skills. Go to room LR 253. Need more help? The College will try to provide free tutoring to any student requesting it. Further information and application forms available at the Counseling Office. NVCC provides reasonable accommodations for students with disabilities to ensure that they enjoy an equal opportunity to participate in and benefit from programs available at the College. If you need such an accommodation, it is your responsibility to process your request through the Counseling Office and to provide me a copy of the appropriate form ahead of time. |
| Classroom decorum | Civility is expected at all times. Civility includes leaving class only at scheduled break times, silencing all electronic devices during class, and being awake and attentive. Any student behaving inappropriately will be dropped from the course. If in doubt about what is appropriate by college standards, consult the NVCC Student Handbook. |
| Academic integrity | It is expected that your submitted assignments and tests be your own work. Cheating and plagiarism are not acceptable. When appropriate, use footnotes or commented code. Any submissions found to be in violation will receive no credit. |
| Emergency closings | The College may decide to close due to bad weather or other circumstances. Sometimes, only evening classes are cancelled. (The College decision may differ from the decisions made by the Fairfax or Loudoun County school systems.) Be sure to check the College web site or phone 703.323.3770 for current status, or sign up for text alerts. There are no make-up days available, so we will juggle assignments as best as we can. In the event of an unscheduled closing, I will update the class web site as soon as possible with information regarding assignments. |
| Computer lab | The open computer lab is located in room LW 230.
The computers are loaded with the same software as in our classroom.
The lab phone number is 703.450.2521. Printing in the lab
costs 10¢/page, using your student ID card.
(No charge for printing in the classroom.)
Hours are: Monday–Thursday, 8 AM–10 PM Friday–Saturday, 8 AM–4 PM Sunday, 1 PM–4 PM |
| Class schedule | This schedule is tentative and subject to change. Refer to
the class Blackboard site for the latest version. The numbers in the Reading column represent textbook chapters which should be read before the class session. Be sure to check the Assignments page of the class Blackboard site every week for full details of the assignments. |
| Session | Date | Topics | Reading |
|---|---|---|---|
| 1 | 14 January | Class intro, review of DBMS concepts | |
| 2 | 21 January | Intro to PL/SQL | 1 |
| 28 January | Last day for schedule adjustments with tuition refund | ||
| 3 | 28 January | Basic block structures | 2 |
| 4 | 4 February | Embedding queries; collections | 3 |
| 5 | 11 February | Cursors, exception handling | 4 |
| 6 | 18 February | Procedures | 5 |
| 7 | 25 February | Review + projects | |
| 8 | 4 March | Mid-term exam Development environments |
|
| 11 March | No class — enjoy spring break! | ||
| 9 | 18 March | Functions | 6 |
| 10 | 25 March | Packages | 7 |
| 26 March | Last day to withdraw without grade penalty |
||
| 11 | 1 April | Program unit dependencies | 8 |
| 12 | 8 April | Triggers | 9 |
| 13 | 15 April | Oracle-supplied packages, SQL*Loader | 10 |
| 14 | 22 April | Dynamic SQL | 11 |
| 15 | 29 April | Review + projects | |
| 16 | 6 May | Final exam |