DATABASE ADMINISTRATION- MYSQL

Background:
In view of the changing IT-IS setup in LIC, Database Administration activities will become very important at data-centers. To perform DBA related activities, to manage security issues in centralized environment, and to perform overall data Center administration, sound knowledge, skills and practices related to these areas have become necessary.

Objectives:
At the end of this programme, the participants will able to get detailed understanding of:

§ Roles and activities of Database Administrator

§ Database Administration features (with reference to the RDBMS product to be decided in due course) with related hands-on

§ Security issues in centralized environment, and how to manage these issues

§ Data Center Administration

§ How to create and manage database users, implement a security system to control their activities, backup and recovery aspects and tune the database to optimize performance.

Contents:
§ RDBMS with reference to MySQL

§ MySQL Database Architecture

§ SQL commands in MySQL

§ Creating a database, Tables, indexes and other objects

§ Managing and optimising disk space

§ Database Tuning

§ User administration

§ Backup & recovery

§ Related Utilities

§ Data Center Administration