MYSQL DB Training in Chennai

Mysql database is a popular open-source relational database management system (RDBMS).Mysql Enterprise Version comes with Oracle Support.Many of the world’s largest and fastest-growing organizations including Facebook, Google, Adobe, Alcatel Lucent and Zappos rely on MySQL to save time and money powering their high-volume Web sites, business-critical systems and packaged software.MySQL was designed and optimized for Web applications.LAMP (standing for Linux, Apache, MySQL, PHP/Perl/Python) is chosen by savvy IT leaders as a way to improve operational efficiency and reduce IT infrastructure costs.Many e-commerce applications use a combination of MongoDB and MySQL. The product page which changes rapidly uses MongoDB’s flexible data model. On the other hand, the checkout system, which requires complex transactions uses RDBMS like Mysql.We also provide knowledge of various tools that are mandatory for a DBA such as Percona toolkit,Percona Extra backup and basic concepts of Bash Scripting for automating various database functionalities.

MySQL DB Training in Chennai – Course Syllabus

Chapter 1: Database Basics
  • Basics of RDBMS
  • ACID Properties
  • Isolation Levels
  • MySQL Intro
  • Architecture of MySQL
  • Why MYSQL

Chapter 2: 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

Chapter 3: Configuration
  • Config file for InnoDB in detail
  • Configuring log files (slow log, general log)

Chapter 4: Users and security, MySQL Backup/restore
  • Creating Users
  • Granting and revoking privileges
  • 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, Incremental backup, Percona Xtrabackup)
  • Restoring mysql backup
  • Purging old logs
  • Mysql Binlog utility and PITR.

Chapter 5: Trouble shooting and Performance Tuning/Optimization for large db's
  • General Problems and their resolution
  • Using the error log
  • Performance tuning – Index suggestions , Usage of HeidiSQL Tool
  • Optimization – Optimizing the Mysql database, Mysqlcheck.

Chapter 6: Replication
  • Master-Slave Replication
  • Master-Master replication

Chapter 7: Overview
  • Monitoring the availability of MySQL
  • Monitoring different aspects of MySQL
  • Using tools for monitoring
  • MySQL Workbench

Chapter 8: Percona Toolkit Bash Scripting for MySQL
  • Scripting for monitoring and backup and other DBA related basic scripts
  • Database Reporting for a DBA working with large db’s
  • Percona Toolkit