CIS119DP Logo CIS119DP
Oracle: Database
Administration

 
Home PDF of Course Syllabus Introduction - Overview Assignments Grading and Class Procedures Books, Software, Files, Login Instructions Useful Links Email Phillip Jalowiec Phillip Jalowiec Instructor Site Phillip Jalowiec Instructor Site Legal Disclaimer

Revised
12 Feb 2009
Assignments
WK
DATE
TOPICSREADINGPTSASSIGNMENT
1
01/21
Introduction, Survey
Architecture Overview
Virtual Machines, Installation
 
T01:1-30
W01
20 Survey
30 Pgs OLQ
24 Pgs OLQ
2
01/28
Architecture and Tools
Create Instance, Reinstallation
T02:35-81
T03:87-130
  47 Pgs OLQ
44 Pgs OLQ
3
02/04
Physical Architecture and
Data Dictionary Views
T04:137-189   53 Pgs OLQ
4
02/11
Storage Concepts
Test Review
T05:199-245
W05, W09
  47 Pgs OLQ
30+18 Pgs
5
02/18
Test: Ch: 1-5
Querying

T06:251-287
200 50 Lab Audit
37 Pgs OLQ
6
02/25
Table Management T07:291-347   57 Pgs OLQ
7
03/04
Advanced Table Management T08:357-387   31 Pgs OLQ
8
03/11
Constraints, Indexes, Objects
Test Review
T09:395-451
W07, W08
  57 Pgs OLQ
49+34 Pgs OLQ
9
03/18
Semester Break
No Class
     
10
03/25
Test: Ch: 6-9
Data Management
 
T10:465-482
T11:485-512
160 100 Lab Audit
18 Pgs OLQ
28 Pgs OLQ
ILA Topic Due
11
04/01
Data Management (continued)
Security Management
Test Review
W18
T12:515-586
W10
  35 Pgs
72 Pgs OLQ
30 Pgs
12
04/08
No Class      
13
04/15
Test: Ch: 10-12
Performance Monitoring
 
T13:601-631
W13
160 72 Lab Audit
31 Pgs OLQ
28 Pgs
14
04/22
Proactive Maintenance T14:635-673
W12
  39 Pgs OLQ
32 Pgs
15
04/29
Backup & Recovery T15:677-706
W14, W15
  30 Pgs OLQ
28+21 Pgs
16
05/06
Backup & Recovery (continued)
Test Review
W16, W17  
120
13+30 Pgs
ILA Due
17
05/13
Test: Ch: 13-15   160 58
30
Lab Audit
Evaluations
*OLQ=Online Quiz  *ILA=Information Literacy Assessment ILA Examples
*T=Course Technology Book,  *W=Workshop Text