MY SQL ADMIN

Course Overview :

MySQL is the world’s second most widely used open-source relational database management system (RDBMS).It is named after co-founder Michael Widenius’s daughter, My. The SQL phrase stands for Structured Query Language.The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.MySQL is a popular choice of database for use in web applications, and is a central component of the widely used LAMP open source web application software stack . LAMP is an acronym for “Linux, Apache, MySQL, Perl/PHP/Python.” Free-software-open source projects that require a full-featured database management system often use MySQL.

Prerequisites

• All attendees should be experienced systems administrators with general relational database and SQL experience.

Course Content

• Starting, Stopping and Configuring MySQL
• Security-Related Configuration
• MySQL Database Creation
• Using Client Programs for MySQL DBA Work
• Setting up Character Set Support
• Locking
• Using Storage Engines, including the MyISAM and InnoDB engines
• Table Maintenance
• Obtaining Data from the Information_Schema Database
• Backup and Recovery, including Exporting (mysqldump) and Importing (mysqlimport
• Using Stored Procedures and Triggers for Database Administration Tasks
• User Management
• Securing the Server
• Upgrade-Related Security Issues
• Optimizing Queries
• Optimizing Schemas
• Optimizing the Server
• The Event Scheduler
• Partitioned Tables
• Interpreting Error Messages
• Optimizing the MySQL Environment
• Scaling MySQL, including Replication
• MySQL Workbench and MySQL Administrator