DBA (MCA 3rd)

Section-A

(Introduction)

Understanding role and responsibilities of DBA, Database Environment management (network, CPU, disk

and RAM), Installing and upgrading various database packages (MS SQL Server, Oracle, MySQL), Comparing

various database packages, Configuring various services and components, Understanding the client/server

model, Communication protocols, Database instance management, Creating and managing various database

objects (tables, views, indexes)

Section-B (Managing Database Servers)

Understating client tools for administrative tasks, Task Automation, Implementing migration, consolidation,

and upgrade strategy, Hardware resource allocation, Business policy implementation, Monitoring and

trouble-shooting, Implementing database compression, Database Replication and multiple servers,

Exporting and Importing data, Managing Data integrity

Section-C (Security and Availability)

Understanding User Access and Security, Creating and modifying user accounts, Creating, Modifying and

Using roles, Granting and Revoking Privileges, Querying role information, Auditing User activity,

Implementing database encryption, Database backup, restoration and recovery, Types of failure, Defining a

backup and recovery strategy, Testing the backup and recovery plan, RAID implementation, High-availability

and disaster recovery

Section-D (Performance Tuning)

Introduction to performance tuning and its requirement, performance tuning methodology and concepts,

Monitoring status variables that affect performance, General Table Optimizations, Using indexes to improve

performance, Monitoring and optimizing the performance of the database, Identifying full-tables cans, Rewriting

SQL queries, Tuning sub-queries, Database mirroring, clustering

Note: Subject Coverage will be preferably based on MySQL.