Oracle - OCP MySQL 5 Database Administrator

Curriculum

Firebrand Training’s accelerated MySQL course will cover the following curriculum:

• 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
• Utilise 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)
• Utilise 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
• Utilise SQL statements to modify the contents of database tables
• Utilise 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
• Optimise 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