About This Course

<p><span style="font-family:Tahoma,Geneva,sans-serif"><strong> Course Overview</strong></span></p> <p style="text-align:justify"><span style="font-size:12pt"><span style="background-color:white"><span style="font-family:"Times New Roman",serif"><span style="font-family:"Cambria",serif"><span style="color:#333333">This MySQL Database Administration course is designed for MySQL Database Administrators who have a basic understanding of a MySQL database and SQL commands. The course provides practical experience in setting up and maintaining a MySQL server, including backing up, recovery, and configuration and tuning.</span></span></span></span></span></p> <p style="text-align:justify"><span style="font-family:Tahoma,Geneva,sans-serif"><strong>Who Should Attend</strong></span></p> <p style="text-align:justify"><span style="font-size:12pt"><span style="background-color:white"><span style="font-family:"Times New Roman",serif"><span style="font-family:"Cambria",serif"><span style="color:#333333">Anyone who needs to administer, monitor and support MySQL databases and servers. Database Administrators, Database Developers, Technical Consultant.</span></span></span></span></span></p> <p style="text-align:justify"><span style="font-family:Tahoma,Geneva,sans-serif"><strong>Course Objectives</strong></span></p> <p style="text-align:justify"><span style="font-size:12pt"><span style="background-color:white"><span style="font-family:"Times New Roman",serif"><span style="font-family:"Cambria",serif"><span style="color:#333333">To provide the skills necessary to administer, monitor and support MySQL databases and servers. Using Client Programs for MySQL DBA Work, Obtaining Metadata, Configuring the Server, Server Installation, Administration and Upgrading, Setting up Character Set Support, Configuring Log Files, Interpreting Error Messages, Creating, Altering and Dropping Databases and Tables, Locking and Transactions, Using Storage Engines, including the MyISAM and InnoDB engines, Table Maintenance, Backup and Recovery, including Exporting (mysqldump) and Importing (mysqlimport), Administering Users and Privileges, Using Stored Procedures and Triggers for Database Administration Tasks, Securing the Server, Tuning Queries, Tuning Tables and Indexes, Tuning the Server, Using the Event Scheduler, Creating Partitioned Tables, Replication, Using MySQL Workbench.</span></span></span></span></span></p> <p style="text-align:justify"><span style="font-family:Tahoma,Geneva,sans-serif"><strong>Prerequisites</strong></span></p> <p style="text-align:justify"><span style="font-size:11pt"><span style="font-family:Calibri,sans-serif"><span style="font-size:12.0pt"><span style="font-family:"Cambria",serif"><span style="color:#333333">A working knowledge of MySQL is required. This can be gained by attendance on the </span></span></span><a href="http://www.stayahead.com/training-courses/mysql-training-courses/Introduction-to-MySQL-Outline--MYSI.html"><span style="font-size:12.0pt"><span style="font-family:"Cambria",serif"><span style="color:#333333">Introduction to MySQL</span></span></span></a><span style="font-size:12.0pt"><span style="font-family:"Cambria",serif"><span style="color:#333333"> course.</span></span></span></span></span></p>

• Learning Objectives

• Find a new position involving
  Data modeling.
• Expanded responsibilities as part of
  an existing role.
• Ready to begin working on real-world
  data modeling projects.

• Other Instructors

• Eleanor Fant Instructor
• Lauren Stamps Teacher
• Jonquil Von Associate