MySQL DBA

MySQL Training and Certification focuses on the Core Concepts & Advanced Tools and techniques to manage data and administer the MySQL Database.

MySQL DBA corporate training and certification oriented remote program aims to upskill you with MySQL Features, Relationol Database, MySQL Commands, Data Types, Server Files, Server Configuration, Log Files and Backup Strategy.

Course Content:

• Introduction to MySQL
• Versions of MySQL
• MySQL Architecture
• Relational Databases Management System
• Comparison of MySQL with other Relational Database
• Defining Module
• Interaction of Core Module
• SQL Language and MySQL
• SQL Data manipulation language
• MySQL Client/Server Model
• MySQL Connectors
• Installing MySQL
• MYSQL open source license
• Install MYSQL
• Different RPMs 
• Troubleshooting
• MYSQL command line
• Logs in MySQL
• Error Log
• General Query Log
• Update Log
• Binary Log
• Slow Query Log
• Log File Maintenance and Rotation
• Buffers in MySQL
• MySQL Administration
• Introduction to mysqld
• Using system variables
• Connection to mysql database
• Creating database in MYSQL
• Creation of tables and load data
• Different data types available in MYSQL
• Security in MySQL
• MySQL User Account Management
• Users and Passwords
• Creating New Users
• Deleting User Accounts
• Limiting User Resources
• Changing Passwords
• MySQL Database Maintanence
• Backup and Recovery
• Point-in-Time Recovery
• Maintenance and Crash Recovery
• myisamchk Syntax and Options
• Getting Table Information
• MySQL Local Setting
• National Characters and Sorting
• MySQL Server Time Zone
• Locking in MySQL
• MYSQL table locking
• MYSQL row locking
• Compare table and row locking
• Advantages and disadvantages
• Replication in MySQL
• Master to slave replication
• Troubleshooting replication
• Replication methods
• Overview of Performance Tuning in MySQL
• Hands-on Exercises
• Prog360 Assessment
• Prog360 Certification