Database Administration and Management (BSIT 5th)

Introduction 

This course contains topics specific to the administration and management aspects of Database systems. Students will learn about concept and techniques that deal with the improving performance of database systems, such as query optimization. Topics that deal with the complexity of accessing shared data, such as transaction processing and concurrency control will be covered. Topics related to programming aspect of database systems such as stored procedures will be covered. Advanced topics in databases including XML, and distributed databases will also be covered.  

• Course Title: Database Administration and Management (ITC 607)
• Credit Hours: 3-1
• Prerequisite: Database Systems

Learning Objectives

After completing this course students will have clear understanding of key concepts and techniques related to management and administration of database systems.

Grading Policy

• Quizzes (LMS): 10%
• Assignments/ Reports(LMS): 15%
• Attendance + LMS Log: 10%
• Discussion Forum / Video / Audio Engagement: 15%
• Mid Term Exam(Oral Exams and Presentations): 20%
• Final Exam(Oral Exams and Presentations): 30%

Course contents:

• Introduction to advance data models such as object relational, object oriented.
• File organizations concepts
• Transaction processing and Concurrency control techniques,
• Recovery techniques
• Query processing and optimization
• Database Programming,
• Integrity and security
• Database Administration
• Physical database design and tuning,
• Distributed database systems
• Emerging research trends in database systems.

Recommended Books:

1. Fundamentals of Database Systems, by Ramez Elmasri and Shamkant Navathe, Addison Wesley, 5th Edition.
2. Database System Concepts by Henry F. Korth and Abraham Silberschatz, 4th edition, McGraw Hill, 2002, ISBN: 0-07-12268-0