 | 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 |
|
Perform queries and analysis of data utilizing the MySQL Query Browser graphical user interface (GUI) |
|
Utilize MySQL monitoring tools to improve server performance |
|
Compare multiple environment options to improve server performance |
|
Explain the MySQL connectors that provide connectivity for client programs |
|
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 |
|
Maintain integrity of a MySQL installation utilizing security protocols |
|
Manage user maintenance and access to a MySQL Server |
|
Manage the structural characteristics of your databases |
|
Create, Maintain and Manage MySQL tables |
|
Manage the structural characteristics of the tables within your databases |
|
Select the best data type for representing information and managing performance in MySQL |
|
Differentiate between the multiple storage engines available in MySQL |
|
Perform bulk data import and export operations |
|
Utilize the SELECT statement to retrieve information from database tables |
|
Utilize expressions in SQL statements to retrieve more detailed information |
|
Write join expressions in your SQL statements to obtain information from multiple tables |
|
Utilize SQL statements to modify the contents of database tables |
|
Utilize subqueries in your SQL statements |
|
Understand data locking concepts and the different levels of locking in MySQL |
|
Perform backup and restore operations utilizing multiple MySQL tools |
|
Improve performance though query optimization |
|
Optimize Schemas (Databases) utilizing multiple techniques |
|
Create user defined variables, prepared statements and stored routines |
|
Create and manage triggers |
|
Use the INFORMATION_SCHEMA database to access metadata |
|
Manage, apply and understand the reason for using views |
|
Debug MySQL applications |
|
Scale-out deployments of MySQL |
