MySQL for Database Administrators

Describe the MySQL Architecture, general operational characteristics and resources utilized for running it; Perform the most common Database Administration (DBA) tasks utilizing the various programs contained within the MySQL application; Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server; Use the INFORMATION_SCHEMA database to access metadata; Install and Upgrade MySQL 5.0 […]

Describe the MySQL Architecture, general operational characteristics and resources utilized for running it; Perform the most common Database Administration (DBA) tasks utilizing the various programs contained within the MySQL application; Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server; Use the INFORMATION_SCHEMA database to access metadata; Install and Upgrade MySQL 5.0 for the most common operating systems; Perform the MySQL start and shutdown operations; Configure MySQL server options at runtime; Activate and manage numerous server logs; Evaluate data types and character sets for performance issues; Understand data locking concepts and the different levels of locking in MySQL; Differentiate between the multiple storage engines available in MySQL; Create, Maintain and Manage MySQL tables; Perform backup and restore operations utilizing multiple MySQL tools; Manage user maintenance and access to a MySQL Server; Maintain integrity of a MySQL installation utilizing security protocols; Use stored routines and triggers for administration tasks; Manage, apply and understand the reason for using views; Improve performance through query optimization; Optimize Schemas (Databases) utilizing multiple techniques; Utilize MySQL monitoring tools to improve server performance; Compare multiple environment options to improve server performance; Scale MySQL operations up.

 

When ?

20-11-17

From 9 am to 5 pm

Email contact

training@devoteam.lu

vanessa.mameri@devoteam.lu

Price : €2120.00

Register now!

Ajouter au calendrier