INTRODUCTION

This introductory course teaches the fundamentals of administering relational database management systems. The course utilizes the Oracle relational database management system. This course is a continuation of the basic concepts, organization, and implementation models taught in the Database Systems course. Among the topics covered are: Oracle Database Architecture, Database Installation, Creating Database Using DBCA, Database Instances, ASM Instances, Network Environment, Storage Structures, User Security, Concurrency Control Mechanisms, Database Auditing and Maintenance, Performance Management, and Backup and Recovery Concepts.

COURSE CODE: IT-3441

CREDIT HOURS: 3

PRE-REQUISITE: Database Systems

LEARNING OUTCOMES:

• Student should be able to fully understand the concepts and technical issues of database administration.

• Student should be able to develop understanding of internal functionality of DBMS.

• Student should be able to perform database administration tasks like backup and recovery and performance tuning of databases.

TEXT BOOK:

1. Oracle Essentials, 5th Edition by Jonathan Stern, Rick Greenwald, Robert Stackowiak, O'Reilly Media, Inc. ISBN: 9781449343033

COURSE CONTENTS:

• Installation; SQL* Plus; Oracle Enterprise Manager; DBA Tools. Oracle Architectural Components: Oracle Server; Oracle Instance.

• Physical Structure; SGA; Shared Pool; Library Cache; Data Dictionary Cache; Large Pool; User Process; Server Process; Background Processes.

• Managing an Oracle Instance: Parameter File; Creating SPFILE; Oracle Managed Files;

• Startup and Shutdown Database; Alert Log File; Background Trace File; User Trace File.

• Creating Database and Data dictionary.

• Managing Control Files and Redo Log Files.

• Managing Tablespaces, Operations with Tablespaces.

• Data File Management, Segments, Block.

• Managing Undo Data, Undo Data Statistics: Managing Tables and Users:

• Indexes Management, Maintaining Data Integrity, Constraints. Managing Privileges.

• Basic Oracle Net Architecture: Types of Networks, Oracle Net Services, Oracle Shared Server, Connection Manager, Oracle Net Connections.

• Server-Side Configuration: The Listener Process; Configuring Listener, Sessions, Creating and Managing Listener.

• Client-Side Configuration: Host Naming Method, Local Naming Method, Net Assistant, Configurations. Usage and Configuration of Oracle Shared Server.

• Backup and Recovery, Instance and Media Recovery, Configuration of Archive log mode, User Managed Complete Recovery

COURSE ASSESSMENT:

• Final Term Exam: 50 Marks

• Mid Term Exam: 30 Marks

• Sessional: 20 Marks

CLASS TIMMING:

• BSIT 5th Regular (Wed 08:00-9:30) (Fri 09:20-10:40)

• BSIT 5th Self Support (Tue 08:00-09:30) (Fri 08:00-09:20)