MySQL is free and open-source software under the terms of the GNU General Public License and is also available under a variety of proprietary licenses. MySQL was owned and sponsored by the Swedish company MySQL AB, which was bought by Sun Microsystems (now Oracle Corporation). In 2010, when Oracle acquired Sun, Widenius forked the open-source MySQL project to create MariaDB. MySQL is written in C and C++. Its SQL parser is written in yacc, but it uses a home-brewed lexical analyzer. MySQL works on many system platforms. Know more about MySQL on Wikipedia.
Beginners to DBA, database designer, and developer.
Basic knowledgeable with relational database concepts and MySQL data types, and also comfortable using the MySQL command line client.
As on 2nd March, 2019, 1500+ MySQL DBA jobs available on Indeed.com
MySQL DBA Course Content
- MySQL Introduction
- MySQL Architecture (Physical + Logical)
- Study material: EBook
- Licensing and features (Community vs Enterprise)
- Install a MySQL
- Configure settings for a MySQL Server
- Access MySQL databases with MySQL Workbench
- Other clients for access
- Datatypes in a MySQL database
- Create databases and tables
- Create basic SQL queries
- Maintain Databases, Tables, and Columns
- Configure Indexes and Constraints
- Join Tables
- Partition MySQL Tables
- MySQL Setup and Configuration options
- MySQL Security
- Practical Hands-on
- MySQL Enterprise Features Audit, Encryption, authentication plugins etc.
- mysqldump – logical backup
- mysqlbackup – physical enterprise backup tool
- MySQL and Percona utilities for monitoring
- Backup and monitoring Automation.
- MySQL High Availability Solutions
- MySQL Replication
- Set up MySQL Replication using global transactionidentifiers (GTID’s) and binlog
- MySQL Cluster overview
- Replication utilities
- Deploy High Availability and Scalability features
- MySQL setup and configuration issues
- MySQL performance related issues
- MySQL Replication related issues troubleshooting
- MySQL industry use cases
- MySQL Cloud
- MySQL 8.0 and features
- About Percona and MariaDB
Join Now WinPath IT is the best Online Software Training Institute for MySQL DBA Online Training Course.