DATABASE ADMINISTRATION- MYSQL

National Insurance Academy
In Pune

Price on request
You can also call the Study Centre
20272... More

Important information

  • Training
  • Pune
  • Duration:
    3 Days
Description

Important information
Venues

Where and when

Starts Location
On request
Pune
25, Baner Road, Balewadi, 411045, Maharashtra, India
See map

Course programme

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