Database Administration(DBA) Syllabus

Syllabus Notes Old Questions & solutions Text & reference books

This page contains Syllabus of Database Administration of CSIT.

Title Database Administration
Short Name DBA
Course code CSC406
Nature of course Theory + Lab
Semester seventh-semester
Full marks 60 + 20 + 20
Pass marks 24 + 8 + 8
Credit Hrs 3
Elective/Compulsary Elective

Course Description

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


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.


Units and Unit Content

1. Introduction
teaching hours: 5 hrs

 DBMS architecture and data independence, DBA roles and responsibilities, SQL *PLUS

Overview: SQL Plus Fundamentals, Producing more readable outputs, Accepting values at urntime,

Using iSQL *Plus.


2. Control and Redo Log Files
teaching hours: 5 hrs

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


3. Managing Users and Security
teaching hours: 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.


4. Backup and Recovery
teaching hours: 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


5. Database corruption
teaching hours: 5 hrs

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


6. Introduction to performance tuning
teaching hours: 10 hrs

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


Lab and Practical works

Laboratory works:

labs should cover all the chapters using Oracle/SQL-Server or any other database

server tools.