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.