Seventh Semester

Database Administration

Course Title:Database Administration

Course No.: CSC406

Course Nature: Theory + Lab

Semester: Seventh

Year: Fourth

Full Marks: 60 + 20 + 20

Pass Marks: 24 + 8 + 8

Credit Hours: 3

Course Synopsis: DBA Roles, DB backup, restoration and recovery, Tuning of database

Course Goal: The course covers about: principles of DBA Roles, DB backup, restoration and recovery, Tuning of database and overall DB administration which could be useful for administrator in the future.

Contents of Chapter
Unit 1: (5 Hrs.) DBMS architecture and data independence, DBA roles and responsibilities, SQL PLUS SQL Plus Fundamentals, Producing more readable outputs, Accepting values at urntime, Using iSQL Plus.
Unit 2: (5 Hrs.) Managing the control files, Maintaining and monitoring redo log files.
Unit 3: (10 Hrs.) Profiles, Managing users, managing privileges, managing roles, querying role information, Database Security and Auditing, Creating and managing DB’s , tables, indexes, triggers, views, stored procedures, Advanced Stored Procedures, analysis and integration services.
Unit 4: (10 Hrs.) Backup and Recovery Overview, Database backup, restoration and recovery, defining a backup and recovery strategy, Testing the backup and recovery plan, parallel instance recovery , recovering from non-critical loses
Unit 5: (5 Hrs.) Database corruption, automatic database management, automatic storage management, RMAN
Unit 6: (10 Hrs.) brief overview of Tuning methodology, general tuning concepts, AADM (Automatic Database Diagnostic Monitor) and SQL Tuning Advisor. policy types, selective columns, column masking.

Contents of Chapter

Unit 1: (5 Hrs.)

DBMS architecture and data independence, DBA roles and responsibilities, SQL *PLUS SQL Plus Fundamentals, Producing more readable outputs, Accepting values at urntime, Using iSQL *Plus.

Unit 2: (5 Hrs.)

Managing the control files, Maintaining and monitoring redo log files.

Unit 3: (10 Hrs.)

Profiles, Managing users, managing privileges, managing roles, querying role information, Database Security and Auditing, Creating and managing DB’s , tables, indexes, triggers, views, stored procedures, Advanced Stored Procedures, analysis and integration services.

Unit 4: (10 Hrs.)

Backup and Recovery Overview, Database backup, restoration and recovery, defining a backup and recovery strategy, Testing the backup and recovery plan, parallel instance recovery , recovering from non-critical loses

Unit 5: (5 Hrs.)

Database corruption, automatic database management, automatic storage management, RMAN

Unit 6: (10 Hrs.)

brief overview of Tuning methodology, general tuning concepts, AADM (Automatic Database Diagnostic Monitor) and SQL Tuning Advisor. policy types, selective columns, column masking.

Laboratory Works:

Labs should cover all the chapters using Oracle/SQL-Server or any other database server tools.

Reference Books:

C.J. Date, Database Systems, Addison Wesley, 2000
Introduction to Database Administration, by O’reilly
ORACLE DBA handbooks