| Week -Date |
Classroom Prep & Assignments |
Lab Assignments |
Week 1
Jan 5 |
Chapter 1 - Client/Server
Databases and
the Oracle9i Relational Database
Ch2 Lab Exercise:
Register for Oracle Tech Net and
learn to find error message code explanations. Print out the error message
code as instructed.
Start Chapter 2 Presentation.
Assignment: Read chapter 2 and complete the
Chapter 2 Worksheet due
January 15. Note: you may do this assignment with a partner.
|
Follow instructions to create folders on C:/ then, right click this link
to download the zipped student data files, select Save Target As and save
it into the newly created OraData folder on C:
Install Oracle Development Suite
(for those who do not already have it - If using the book CD,
follow these
instructions.) NOTE: This requires 1.8 GB of space.
|
Week 2
Jan 12 |
Chapter 2 -
Creating and Modifying Database Tables
Lab Assignment: Follow Chapter 2
Tutorial Guide & turn
in Ch2Queries.sq due Jan 15.
Read Chapter 3Click to get
Homework
for 3A Tutorial instructions.
FYI: How to Create a
Spool File
FYI: Visual
Overview of Ch3A Tutorial
|
In class lab:
Install Oracle 9i database
which requires 2.8 GB and minimum 128 MB RAM, 256 recommended.
Change Oracle Services (Step
1)
Start Oracle Services (Step
2)
Configure ORADEV connect (Step
3) |
Week 3
Jan 19 |
 Jan 19 - No School
January 20 - No School
Chapter 3:
Using SQL Queries to Insert, Update, Delete, and View Data
|
3A Tutorial - email Spool File and print out Notepad 3AQueries.sql file |
Week 4
Jan 26
|
Chapter 3A continued, Chapter 3B
Retrieving Data from a Single DB Table
Download corrected chapter 3 script:
3Northwoods.sql and save
it in
C:\OraData\Chapter3\ folder. 3B Tutorial starts with
running this script. |
Chapter 3A Cases Assignment:
3ACases 4,5,6,7 Due Feb 3
|
Week 5
Feb 2
|
Finish 3B
Start Chapter 3C Joining Multiple Tables
 Demo:
TOAD (www.toadsoft.com)
|
Chapter 3B Review Questions 1-6, 11, 12
Chapter 3B Cases: 3,4 Due Feb 10
Examples of Single-Row
Functions from 3B
|
Week 6
Feb 9
|
Chapter 3C Joining Multiple Tables
|
Chapter 3C Review Questions 1,2,4-11
Due Feb 17
Chapter 3C Cases: 4a,b;5a,b;7a,8
Due Feb 17
|
Week 7
Feb 16
|
 Feb
16
President's Day
Chapter 3C Joining Multiple Tables |
Chapter 1-3 Exam, Thurs Feb 19
 |
Week 8
Feb 23
|
Start
Chapter 4:
Introduction to PL/SQL
Download the corrected chapter 4 script:
4Northwoods.sql and save
it in
C:\OraData\Chapter4 folder. Chapter 4 requires the
corrections in this script
|
ASSIGNMENTS:Chapter 4A Tutorial - Do in class and hand in.
Chapter 4A Quiz - 5 Points
Homework: Chapter 4A Cases: 1, 2, 4, 7
- Due March 2
Chapter 4 B Tutorial - Fig 4-17, 4-21
Do in class and hand in. |
Week 9
Mar 1
|
Tues, Mar 2 - ADVISING in PM
Thurs, Mar 4 - ADVISING in AM (no class)
Chapter 4 Lesson B
Loops,Cursors |
4B Tutorial Assignment: (10 Points)
__ page 238 Step 1 and 2. See Figure 4-31.
__ page 239 Step 1 and 2. See Figure 4-32.
__ page 243 Step 1 and page 244 Step 2. See Figure 4-36.
__ page 246 Step 1 and page 247 Step 2. See Figure 4-39.
Homework:
Chapter 4B Cases: 1, 5, 6 - Due March 9
Chapter 4B Quiz - 5 Points |
Week 10
Mar 8 |
Complete Chapter 4 Lesson B
Loops & Cursors
|
Homework:
Chapter 4B Cases: 1, 5, 6 - Due March 9
Chapter 4B Quiz - 5 Points |
|
March 15-20 Spring Break
|
 Mar
17
St. Patrick's Day |
Week 11
Mar 22 |
Download the corrected chapter 5 script:
5Northwoods.sql and save
it in
C:\OraData\Chapter5 folder. Chapter 5 requires the
corrections in this script
Introduction to Forms Builder
(5A) Presentation
|
Chapter 4 Exam PL/SQL
5A
Tutorial 1
Instructions &
Powerpoint
5A Tutorial 2
Instructions
5A Tutorial Due Tuesday March 29th
Chapter 5A Quiz |
Week 12
Mar 29
|
Introduction to Forms Builder
(5B) |
5B Tutorial: Your form should resemble
Figure 5-31 Due 4/8
5B Case 3, Due 4/13 |
Week 13
Apr 5
|
 Friday
April 9 - No School
Introduction to Forms Builder (5C) |
5C Tutorial to p. 359; Your form should resemble Figure 5-43
5C Case 5, p. 367. Due 4/15
|
Wk14
Apr 12 |
Monday April 12 - No School
Chapter 5 Term form for 5C
Chapter 6A
Creating Custom
Forms Tutorial
Download corrected Northwoods sql script to use for refreshing the
database. |
Chapter 5C Quiz |
Wk15
Apr 19
|
Finish 6A and start 6B
|
Chapter 5 Forms Written and Practical Exam
|
Wk16
Apr 26
|
Chapter 6B Creating Custom Forms Tutorial
Oracle Certification: Visit www.oracle.com/education |
Complete the 6A Tutorial; Do a print screen of
Fig 6-5 and the code in Fig 6-9 with the correction to the code made at the
end of the tutorial.
6A: Due May 4
6B Tutorial: Print screen of code in Figure 6-28. Due May 6
|
Wk17
May 3 |
Download corrected Ch7 Northwoods sql script to use for refreshing the
database.
Chapter 7A Creating Database Reports |
Tuesday, May 4: 9
AM Higher Learning Commission Student Meeting - MC101 - please attend....
there will be no lecture 8-9 so you can work on your tutorials then go to
MC101 to provide your input to the HLC site visit team. |
Wk18
May 10
|
Graduation May 14....
|
Chapter 6A, B, 7A Forms & Reports Exam
Final Practical Exam |
