King Fahd University of Petroleum and Minerals
Semester 2005-2006 (052)
ICS 034 Database Administration using Oracle(DBA)
1. Instructor
Name Ejaz
Ahmed
E-mail eahmed@ccse.kfupm.edu.sa
Office 22/124-6
Phone 1141
Class ICS034: Wednesday
Sunday
2. Course
Course Objectives
·
To understand the basic concepts of Database and
Architecture.
·
To understand Database Installation, Configuration
and Management
·
To understand and experience Database Administration.
·
Get an experience to work in a team environment
Catalog Description
Basic database concepts and
SQL. Introduction to PL/SQL. Database Architecture. Database installation and
creation. Managing background process and various database files. Database
security and integrity. Data loading and migration. Backup & recovery.
Prerequisite: ICS 014 – Database Systems
Software Applications’
Standards
Oracle 9i/ 10g
Textbook
Recommended:
Oracle Press Material
Grading
Quizzes
---------------------------- 10 %
Home Work
---------------------------- 20 %
Exam I
---------------------------- 20% (
Exam II ---------------------------- 20 % (26-APR-2005:
WED
Final Exam
-----------------------------30 % (Comprehensive)
|
S# |
Topic |
Chapter |
# Of Lectures, Lab/ Week |
Exam |
Quiz |
HW |
|
1 |
Relational Data Model
& Constraints |
Relational Data Model & Constraints.ppt |
4, 1 (Week-1,2) |
1 |
|
|
|
2 |
Introduction to SQL,
SQL/PLSQL |
SQL.ppt, PL_SQL.ppt |
4, 2 (Week-3 to 5) |
1 |
1 |
1 |
|
3 |
Oracle Architecture Components. Getting start with oracle
server |
Slides, material |
2,1
(Week-6) |
1 |
|
2 |
|
4 |
Using Data Dictionary and Dynamic Performance Views. Maintaining the Control File |
Slides, material |
2,1 (Week-6) |
2 |
2 |
|
|
5 |
Maintaining Online RedoLog Files. Managing Tablespaces and
Data Files |
Slides, material |
2,1 (Week-7) |
2 |
|
3 |
|
6 |
Managing Tables and Indexes. Maintain Data Integrity |
Slides, material |
2,1 (Week-8) |
2 |
|
|
|
7 |
Managing
Password security and Resources. Managing Roles, Users and Privileges |
Slides, material |
4,2 (Week-9, 10) |
|
3 |
4 |
|
8 |
Managing Data Loading |
Slides, material |
4,2 (Week-11, 12) |
|
|
|
|
10 |
Backup and Recovery (Concepts and implementation issues) |
Slides, material |
4,2 (Week-13, 14) |
|
|
|
3. General Policies
Attendance
·
Regular attendance is the university requirement.
Attendance will be taken in the beginning of every class.
·
Whenever the number of unexcused absences exceeds 20% of
the held classes, the grade DN will be reported without any formal warning.
·
Two late attendances will result one absence.
·
Final exam will be selective comprehensive.
Home Work Submission
·
The home work can be submitted in a class on the due
date.
·
Any late submission will not be accepted.
Class Discussion
·
Participation in class discussion is very much
encouraged. Asking questions during lectures helps both the instructor and the
student. The instructor gets the feedback and the students get the point
clarified. Students are encouraging in study book for
the preparation of course rather than lecture slides.
Grading Issues
·
All the grading issues must be resolved within a
week after the return of graded material.
·
Exam grades will be submitted a week after the exam
date.
·
3 quizzes will be considered in the final grade.
Make Ups
·
No make up exams will be given.
Software Applications’
Standards
·
Oracle 9i Enterprise Edition, MS SQL & Oracle
SQL standards (ANSI standards)