DBA

BIS – 306 E-3 CREDIT 4(L-4, T-0)

(I) PREAMBLE: To be able to gain suitable expertise in maintenance of a databse its availability and to ensure security controls are adequate and are functioning as intended within the operating system.

(II) PREREQUISITE: To be able to implement a simple DBMS and design and implement information systems using DBMS technology.

(III) SHORT SYLLABUS:

S.No. Topics No. of Hours

1. Introduction

2. SQL *PLUS Overview

3. Modifying Data

4. Managing Constraints

5. Managing Views

6. User Access and Security

7. Oracle Overview and Architecture

8. Managing Oracle

9. Control and Redo Log Files

10. Managing Tables, indexes and Constraints

11. Managing Users and Security

12. Introduction to Network Administration

13. Backup and Recovery Overview

14. Introduction to performance tuning

(IV) TEXT BOOKS:

1. [CD] C.J. Date, Database Systems, Addison Wesley, 2000

2. [BT] Chip Dawes, Biju Thomas, Introduction to Oracle 9i SQL, BPB, 2002

3. [BB] Bob Bryla, Biju Thomas, Oracle 9i DBA Fundamental I, BPB, 2002

4. [DS] Doug Stums, Matthew Weshan, Oracle 9i DBA Fundamental I, BPB, 2002

5. [JJ] Joseph C. Johnson, Oracle 9i Performance Tuning., BPB, 2002

(V) REFERENCE BOOKS

Sr.	Topic	Reference	Chapter
1.	Introduction: DBMS architecture and data independence, DBA roles and responsibilities	[EN], [CD]	1, 2 2
2.	SQL PLUS Overview: SQL Plus Fundamentals, Producing more readable outputs, Accepting values at urntime, Using iSQL Plus	[BT]	2
3.	Modifying Data: Introduction to DML Statements, Truncating a table, Transaction control language	[BT]	6
4.	Managing Constraints: Creating constraints, Dropping constraints, enabling and disabling constaints, deferring constraints checks	[BT]	7
5.	Managing Views: Creating and modifying views, Using views, Inserting, Updating and deleting data through views	[BT]	8
6.	User Access and Security: Creating and modifying use accounts, creating and using roles, granting and revoking privileges, Managing user groups with profiles	[BB]	10
7.	Oracle Overview and Architecture: An overview of logical an physical storage structures, Oracle memory structures, Oracle background processes, connecting to oracle instance, processing SQL command.	[BB]	2
8.	Managing Oracle: starting up the oracle instance, managing sessions, shutting down the oracle instance, instances messages and instance alerts.	[BB]	3
9.	Control and Redo Log Files: Managing the control files, Maintaining and monitoring redo log files	[BB]	5
10.	Managing tables, indexes and constraints: Storing data (create, alter, analyzing, querying table information), Managing indexes, Managing constraints	[BB]	8
11.	Managing Users and Security: Profiles, Managing users, managing privileges, managing roles, querying role information	[BB]	9
12.	Introduction to Network Administration: Network design considerations, network responsibilities for the DBA, network configuration, Overview of oracle Net features, Oracle Net Stack Architecture	[DS]	1
13.	Backup and Recovery Overview: Database backup, restoration and recovery, Types of failure in oracle environment, defining a backup and recovery strategy, Testing the backup and recovery plan	[DS]	5
14.	Introduction to performance tuning: brief overview of Tuning methodology, General tuning concepts	[JJ]	1