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 . BCA-OLD

Database Administration

0%

Course Title: Database Administration

Course No: CACS405

Nature of the Course: Theory + Lab

Semester: 7

Full Marks: 20 + 20 + 60

Pass Marks: 8 + 8 + 24

Credit Hours: 3

Course Description

Course Objectives

Course Contents

1. Introduction to an Oracle database

12 hrs

1.1. Overview of the Oracle Database Architecture (process, memory, storage structure)

1.2. DBA roles and responsibilities

1.3. Familiar with SQL*Plus

1.4. Accepting Values at Runtime

1.5. Overview of SQL Command (DDL, Tables, Constraints, Indexes, Views, Synonyms, Sequences, Partitioning and Materialized Views)

1.6. DML, Join and Subquery

2. Managing Database Instances

5 hrs

2.1. Oracle Database installation

2.2. Database creation, starting up and shutting down oracle instance

2.3. Oracle Network component, communicating between Databases

2.4. Using Dynamic Performance Views

2.5. Using the Automatic Diagnostic Repository (ADR)

2.6. Using the Alert Log and Trace Files

2.7. Managing Initialization Parameter Files

3. Tablespace and Storage management

4 hrs

3.1. Working with Tablespaces and Data Files

3.2. Creating and adding tablespace and datafiles

3.3. Managing Control Files

3.4. Online Redo Logs and Archive logs

3.5. Multiplexing online redo logs and control files

3.6. Database archiving

4. Managing Users, Roles and Privileges

6 hrs

4.1. Assigning Quotas to Users

4.2. Applying the Principal of Least Privilege

4.3. Creating and Assigning Profiles

4.4. Administering User Authentication Methods

4.5. Managing Oracle Database Users, Privileges, and Roles

5. Multitenant Database Architecture

7 hrs

5.1. Understanding the Multitenant Architecture

5.2. Pluggable Architecture

5.3. Creating CDB

5.4. Creating Pluggable Databases (PDBs) within a CDB

5.5. Manage CDBs and PDBs

5.6. Backup and Duplicate

5.7. Manage Security in Multitenant databases

6. Configure the Oracle Network Environment

5 hrs

6.1. Overview of Network Configuration

6.2. Oracle Net Listener Configuration and Management

6.3. Oracle Net Naming Methods

6.4. Networking the Net Configuration Assistant

6.5. Configure Client Connections with Net Manager

6.6. View Listener Configuration

6.7. Start and Stop the Oracle Listener

6.8. Use TNS PING to Test Oracle Net Connectivity

6.9. Connect to the Database

6.10. Configure Net Services with Enterprise Manager

7. Backup and Recovery

5 hrs

7.1. Backup and Recovery Concepts

7.2. Database backup, restoration and recovery

7.3. Defining a backup and recovery strategy

7.4. Backup and Recovery options

7.6. User-Managed Backup and Recovery

7.7. Configuring RMAN

7.8. RMAN Backups, Restore and Recovery

7.9. Perform CDB and PDB flashback

8. Automate Tasks with the Scheduler

4 hrs

8.1. Introduction to the Scheduler

8.2. Access Rights

8.3. Scheduler Components and Workflow

8.4. Create a Job

8.5. Job Classes

8.6. Use Time Based, Event-Based Schedules

8.7. Create an Event-Based Schedule

Laboratory Works

1.Laboratory Works

Reference Books

1.Fernandez, I. Beginning Oracle Database 12c Administration. Apress.
2.Press, O. Oracle Database 19C: Administration Workshop vol-I/II.
3.Thomas, B. Oracle Database 12C Administration Certified Associate. Sybex.
4.Pro Oracle Database 18c Administration: Manage and Safeguard Your Organization’s Data, Michelle Malcher and Darl Kuhn, Third Edition.
5.Oracle Database 12c DBA Handbook, Manage a Scalable Secure Oracle Enterprise Database Environment, Bob Bryla.

Notes:

Source:

This course provides the comprehensive knowledge about relational database management system in administrative approach to integrate in enterprise level of database in network environment which encompasses with oracle database instances Management, database installation in network environment, implementing user role and privileges, multitenant database management, back and recovery.

The general objectives of this course is to provide core knowledge of administrative works on relational database management system.

Laboratory works should be done covering all the topics listed above and a small work should be carried out using the concept learnt in each unit in the group. Work should be assigned on individual basis.

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