An-Najah Staff

Course title and number

Database Administration 10681255

Instructor(s) name(s)

Dr. Fady Draidi

Course Objectives

The aim of this course is to teach the students the principles of the administration phase for the DBMS. This course is continuity for the database course. Different topics will be covered like physical database design and tuning, applying different security features, transaction management, concurrency control, and crash recovery.

Intended learning

Outcomes and

Competences

At the end of this course students should be able to;

1.   Familiarize with the administration principles of DBMSs

2.   Manage database users and their privileges

3.   Manage DB security and access control

4.   Manage  and securities on different levels of DB

5.   Know the DB transaction management

6.   Know the principles of transaction concurrency control

7.   Apply the database crash recovery

Textbook and  References

(Online Resources)

Database Management Systems, 2^nd Edition, Raghu Ramakrishnan.

Assessment Criteria

Activity

Date

Percent (%)

First Exam

20

Second Exam

20

Homework and  quizzes

Lab

20

Final Exam

40

Week

Subject

1

Introduction to Physical Database Design

2

Guidelines for Index Selection with examples

3

Clustering

4

Tuning, Impact of Concurrency

5

Introduction to DB Security, Access Control.

6

The concept of transactions, Schedules, Concurrency

7

8

Lock-Based Concurrency Control, Introduction to Crash Recovery

9

10

Lock Management, Specialized Locking Techniques, Concurrency Control without Locking

11

12

13

Crash Recovery, Recovery from System Crash

14

15

Media Recovery, Algorithms for Concurrency Control

16