Best Software Training Institute in Chennai with 100% Placement
Mail Us Today
Call us for more details
+91 86087 00340 | + 91 90874 73900
Company Locations
K.K. Nagar, Anna Nagar

MySQL Training Course Syllabus

Database Basics:
Basics of RDBMS | ACID Properties | Isolation Levels | MySQL Intro | Architecture of MySQL(Physical, Logical)

Formatting text with HTML: Paragraph Formatting with HTML | Character Formatting with HTML | Comparing Procedural and Descriptive Formatting

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.

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.

To know more about the course fee please call me at 86087 00340

Enquire Now