| |
|
CIS 338 Schedule |
|
|
|
|
|
| |
|
Fall 2008 |
|
|
|
|
|
| |
|
Online Web_CT |
|
12/4/2008 |
|
|
|
| |
Week |
What will we be doing? |
Week Of |
Changes!!! |
|
|
|
| |
1 |
Course Introduction |
8/25/2008 |
|
|
|
|
| |
|
Oracle
Syllabus |
|
|
|
|
|
| |
|
Logins |
|
Warm up exercise |
|
|
|
| |
|
SQL*Plus Brush-Up |
|
|
|
|
|
| |
|
present reading assignment
and review assignment |
|
|
|
|
|
| |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
| |
|
Holiday |
9/1/2008 |
Holiday |
|
|
|
| |
|
|
|
|
|
|
|
| |
2 |
PL/SQL – What and Why |
9/8/2008 |
|
|
|
|
| |
|
Block Structure |
|
|
|
|
|
| |
|
Present 1st lab assignment |
|
|
|
|
|
| |
|
Declaring Variables |
|
|
|
|
|
| |
3 |
Writing Executable
Statements |
9/15/2008 |
|
|
|
|
| |
|
Interacting with the Oracle
Server |
|
Warm up scripts are due |
|
|
|
| |
|
Writing control statements |
|
|
|
|
|
| |
5 |
Assessment Exam 1 coming due |
9/29/2008 |
|
|
|
|
| |
|
CIS 332 "Warm
Up" Scripts Due this week |
|
|
|
|
|
| |
|
Distribute Documentation
Assignments & Lab 2-control structures |
|
|
|
|
|
| |
6 |
Selection Structures |
10/6/2008 |
|
|
|
|
| |
|
Cursors |
|
|
|
|
|
| |
|
Assessment Exam 2 coming
due |
|
|
|
|
|
| |
|
Exception Documentation 2 Due |
|
|
|
|
|
| |
7 |
Handling Exceptions |
10/20/2008 |
|
|
|
|
| |
|
Procedures & Functions |
|
|
|
|
|
| |
|
Procedures & Functions |
|
|
|
|
|
| |
9 |
Cursors Due |
11/3/2008 |
|
|
|
|
| |
|
Procedures & Functions |
|
|
|
|
|
| |
|
| Assessment
Exam 3 coming due |
|
|
|
|
|
|
| |
|
Packages |
|
|
|
|
|
| |
|
Exceptions Due |
|
|
|
|
|
| |
|
Packages Overload |
11/17/2008 |
|
|
|
|
| |
|
Packages Overload |
|
|
|
|
|
| |
|
|
|
|
|
|
|
| |
13 |
Triggers |
12/1/2008 |
|
|
|
|
| |
|
Packages/Procedures/Functions
Due at MIDNIGHT (11:59PM) |
12/8/2008 |
|
|
|
|
| |
|
Assessment Exam 4 is due |
12/8/2008 |
|
|
|
|
| |
|
|
|
|
|
|
|
| |
|
Approximate Schedule |
|
|
|
|
|
| |
|
|
|
|
|
|
|
| |
|
Ken's web site |
|
|
|
|
|
| |
|
|
|
|
|
|
|
| |
|
Email
Ken |
|
|
|
|
|
| |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|