twg-group-chennai

MySQL DBA TRAINING IN CHENNAI :

SYLLABUS :


Database Basics :


  • Basics of RDBMS
  • ACID Properties
  • Isolation Levels
  • MySQL Intro
  • Architecture of MySQL(Physical, Logical)
 

Installation and Configuration :


  • Installation of MySQL: Windows, Linux
  • Working with mysql objects: (Tables, Views, Stored procedure, Events)
  • Error handling
  • Pluggable engines: (MyISAM, InnoDB, Memory, CSV, Federated, Blackhole, Merge)
  • Working with MySQL configuration file.
 

Configuration :


  • Config file for InnoDB in detail.
  • Congifuring log files (slow log, general log)
 

Users and security, Mysql Backup :


  • Topics: Creating Users
  • Granting and revoking privileges
  • Taking user backup, changing password.
  • Topics: Backup requirement
  • Physical and logical backup
  • Cold and hot backup
  • Enabling and disabling binary logging
  • Understanding the binary log architecture
  • Different backup techniques in mysql (MySQL dump, Full backup, Transactional backup, Percona Xtrabackup)
  • Restoring mysql backup, Purging old logs
  • Mysql Binlog utility and PITR.
 

Trouble shooting and Performance Tuning/Optimization for large db's :


  • General Problems and their resolution,
  • Connection problems, and understanding the error log.
  • Performance tuning - Index suggestions
  • Usage of HeidiSQL Tool.
  • Optimization - Optimizing the Mysql database.
 

Replication:


  • Master-Slave Replication
  • Master-Master replication
 

Monitoring and Security Practices :


  • Monitoring the availability of MySQL,
  • Monitoring different aspects of MySQL.
  • Using tools for monitoring.
  • Necessary Reporting for a mysql DBA.
  • Mysql Workbench,Percona Toolkit.
 

Bash Scripting :


  • Scripting for monitoring and backup and other DBA related basic scripts

 

CONTACT ADDRESS :

CHENNAI BRANCH

no.5, boopathy street, virugambakkam,
virugambakkam - bus stop opposite chennai , tamil nadu , india.
tel: 044 - 420 77677, 044 - 430 72173
cell : 093845 77677
email : twggroupchennai@gmail.com

KOCHI BRANCH

Near LULU Shopping Mall
Edappally Toll Junction,
Opposite - Metro Bridge Piller No. 387,
V.P Marakkar Building,
V.P Marakkar Road,
Via - Vanitha and Vinitha Theatre
Edappally P.O, Kochi - Kerala
Contact :073580 27788 , 093810 48884,
Email : twggroupcochin@gmail.com ,
Email : twggroupchennai@gmail.com

MUMBAI BRANCH

crescent business square" No.810, kherani road,
opposite - sj studios sakinaka metro
junction, andheri (east) mumbai - 400 059.
cell : 093810 48884, 073580 27788, 093810 77677
email : twggroupmumbai@gmail.com
email : twggroupchennai@gmail.com

TRICHY BRANCH

sri gem plaza no.3, 4th floor,
sankaran pillai street, s.r.c.college road,
chathiram bus stand, trichy - 620 002
Tamil nadu , india.
contact : jenifer : 093845 77677, 93810 77677
contact : suganya : 093825 88890
email : twggroupchennai@gmail.com

COIMBATORE BRANCH

dheepam complex no.574 to 581, 100 feet road,
near g.p.signal, landmark: kalyan jewellery,
gandhipuram, coimbatore - 641 012 tamil nadu , india.
contact : jasmine : 093810 77677, 093845 77677,
contact : sandhiya : 093825 88890
email : twggroupchennai@gmail.com

VIZAG BRANCH

twg group vizag no. 8 - 12 - 1/1,
2nd floor, gayathri nilay, gokul nagar,
karur vysya bank back side opposite - holy cross church,
old gajuwaka junction, vishakapatnam - 530 026.
Andhra pradesh , india.
contact : 073580 27788, 093810 48884, 76692 48884.
email : twggroupchennai@gmail.com

BANGALORE BRANCH

No.54, 15th Main Road ,
2nd Floor,
East of Chord Road
Vijaya Nagar,
Opposite Vijaya Nagar Metro Station,
Bangalore - 560 040.
Karnataka, India.
Contact : 073580 27788 , 093810 77677
Email : twggroupchennai@gmail.com

HYDERABAD BRANCH

twg group hyderabad contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

DELHI BRANCH

twg group delhi contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

PUNE BRANCH

twg group pune contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

TRIVANDRUM BRANCH

twg group trivandrum contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

CALICUT BRANCH

twg group calicut contact : shopia : 076679 78887 contact : office : 093810 48884
email : twggroupchennai@gmail.com

TRAINING COURSES