BCA Database Administration

bcasemester 7Elective

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 installment in network environment, implementing user role and privileges, multitenant database management, back and recovery.

Chapter Wise Notes Question Banks Syllabus Chapter Wise Questions Viva Practical

Database Administration

Subject Code: CACS405

Course Title: Database Administration

Course No: CACS405

Nature of Course: Theory & Practical

Full Marks: 60+20+20

Pass Marks: 24+8+8

Credit Hours: 3

Course Description

Course Objective

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

Course Contents

Unit 1. Introduction to an Oracle database 12 Hrs.

Overview of the Oracle Database Architecture (process, memory, storage structure), DBA roles and responsibilities, Familiar with SQL*Plus, Accepting Values at Runtime, Overview of SQL Command (DDL (Tables, Constraints, Indexes Views, Synonyms, Sequences Partitioning and Materialized Views), DML, Join and Subquery)

Unit 2. Managing Database Instances 5 Hrs.

Oracle Database installation, Database creation, starting up and shutting down oracle instance, Oracle Network component, communicating between Databases, Using Dynamic Performance Views, Using the Automatic Diagnostic Repository (ADR), Using the Alert Log and Trace Files, Managing Initialization Parameter Files

Unit 3. Tablespace and Storage management 4 Hrs.

Working with Tablespaces and Data Files, Creating and adding tablespace and datafiles, Managing Control Files, Online Redo Logs and Archive logs, Multiplexing online redo logs and control files, database archiving

Unit 4. Managing Users, Roles and Privileges 6 Hrs.

Assigning Quotas to Users, Applying the Principal of Least Privilege, Creating and Assigning Profiles, Administering User Authentication Methods, Managing Oracle Database Users, Privileges, and Roles

Unit 5. Multitenant Database Architecture 7 Hrs.

Understanding the Multitenant Architecture, Pluggable Architecture, Creating CDB, Creating Pluggable Databases (PDBs) within a CDB, Manage CDBs and PDBs, Backup and Duplicate, Manage Security in Multitenant databases

Unit 6. Configure the Oracle Network Environment 5 Hrs.

Overview of Network Configuration, Oracle Net Listener Configuration and Management, Oracle Net Naming Methods, Networking the Net Configuration Assistant, Configure Client Connections with Net Manager, View Listener Configuration, Start and Stop the Oracle Listener, Use TNSPING to Test Oracle Net Connectivity, Connect to the Database, Configure NetServices with Enterprise Manager

Unit 7. Backup and Recovery 5 Hrs.

Backup and Recovery Concepts, Database backup, restoration and recovery, defining a backup and recovery strategy, Backup and Recovery options, Data Dump, User-Managed Backup and Recovery, Configuring RMAN, RMAN Backups, Restore and Recovery, Perform CDB and PDB flashback

Unit 8. Automate Tasks with the Scheduler 4 Hrs.

Introduction to the Scheduler, Access Rights, Scheduler Components and Workflow, create a Job, Job Classes, Use Time Based, Event-Based Schedules, Create an Event-Based Schedule

Reference Books

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

Lab Works

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.