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.

semester photo

Chapter Wise Notes Question Banks Syllabus Chapter Wise Questions Viva Practical

Unit 1:Introduction to an Oracle database

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

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

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

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

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

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

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

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