TABFlux

Home Courses Universities Programs Forum

© 2026 TABFlux. All rights reserved. Built for students, by students.

Forum Privacy Policy Terms of Service Contact Us Contributors

Database Administration

Database Administration (DBA) involves the "logical" and "technical" management of software systems used to store, organize, and secure an organization's data. It ensures that databases remain accessible, high-performing, and protected against loss or unauthorized access within "Business Information Systems."

Select University

Select Program

BSC-CSIT BCA-OLD BIT

TabFlux . Database Administration . TU . BSC-CSIT

Database Administration

0%

Course Title: Database Administration

Course No: CSC424

Nature of the Course: Theory + Lab

Semester: 7

Full Marks: 60 + 20 + 20

Pass Marks: 24 + 8 + 8

Credit Hours: 3

Course Description

Course Objectives

Course Contents

1. Introduction

5 hrs

1.1. DBA Roles and Responsibilities

1.2. Database Architecture

1.3. ORACLE logical and physical database structure

1.4. Memory and Process Structure

1.5. SQLPLUS Overview

1.6. Creating a database

2. Tablespace and Storage Management

5 hrs

2.1. Working with Tablespaces and Data Files, Creating and adding tablespace and datafiles

2.2. Managing Control Files, Online Redo Logs and Archive logs

2.3. Multiplexing

3. Managing Database Objects

8 hrs

3.1. Working with Tables and Constraints

3.2. Working with Indexes, Views, Synonyms, and Sequences

3.3. Partitioning and Materialized Views

3.4. Introduction of PLSQL

Stored Procedure

Functions

Trigger

Package

4. Database Backup, Restore, and Recovery

10 hrs

4.1. Backup and Recovery Overview, Database backup, restoration and recovery, defining a backup and recovery strategy, Backup and Recovery options

4.3. User-Managed Backup and Recovery

4.4. Configuring RMAN, RMAN Backups, Restore and Recovery

4.5. High Availability Features

4.6. Oracle Data Guard

4.7. Flashback operations

5. Database Security and Auditing

7 hrs

5.1. Database Security and Auditing

5.2. Database Authentication Methods

5.3. Database Authorization Methods

5.4. Data Encryption Techniques, Virtual Private Database

5.5. Managing Users and Security

Profiles

Managing users

Managing privileges

Managing roles

6. Multitenant Database Architecture

5 hrs

6.1. Understanding the Multitenant Architecture, Pluggable Architecture, Creating CDB

6.2. Administrating Root Container

6.3. Creating Pluggable Databases (PDBs) within a CDB

6.4. Administrating Pluggable Databases

6.5. Backup and Recovery in multitenant Environment

6.6. Databases in the Cloud

7. Database Tuning

5 hrs

7.1. Tuning Application Design, Tuning Memory Usage, Tuning Data Access, Tuning Data Manipulation

7.2. Reducing Network Traffic

7.3. Using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM)

7.4. Tuning SQL, SQL Tuning Advisor

7.5. Performance Tuning in a Multitenant Environment

7.6. Distributed Databases and Networking Tool

Laboratory Works

Text Books

1.Pro Oracle Database 18c Administration: Manage and Safeguard Your Organization's Data, Michelle Malcher and Darl Kuhn, Third Edition.
2.Oracle Database 12c DBA Handbook, Manage a Scalable, Secure Oracle Enterprise Database Environment, Bob Bryla.
3.Oracle DBA Mentor: Succeding as an Oracle Database Administrator, Brian Peasland.

Notes:

Source:

This course familiarizes students with different concepts of database administration including DBA Roles and responsibilities, tablespace and storage management, DB backup, restoration and recovery, security, multitenant, and performance tuning.

The main objective of this course is to provide knowledge of different concepts of database administration so that the students will be able to:

Install DBMS Software
Create and manage databases
Manage backup and recovery
Control user security
Managing database performance and multitenant architecture

The laboratory work should include all the concepts mentioned in the course using any appropriate DBMS system.

This syllabus follows the official BSC-CSIT curriculum of Tribhuvan University. In case of any doubt or revision, the university's published syllabus shall be considered authoritative.