Oracle MySQL 5.5.8 for Database Administrators (DBA) Training course lays the foundation for the understanding of the powerful database, MySQL. The participants acquire the skills for securing access controls, defining user privileges, and setting recourse limitations. The training will also guide the attendees about the creation and usage of view, triggers, and stored procedures.
Oracle MySQL 5.5.8 for Database Administrators course will prepare you for Oracle Certified Professional, MySQL 5.6 Database Administrator.
By the end of this training, the participants will hold the following capabilities:
- Understand MySQL architecture and its types of distributions
- Installation and configuration of MySQL for different operating systems
- Understand client-server architecture and use mysql client
- Configure MySQL server options at runtime
- Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server
- Usage of different data types
- Evaluate different types of storage engines and choose the appropriate one
- Obtain partition information and explore the ways of creating, modifying and removing partitions
- Understand data locking concept and its implications
- Implement security by maintaining user accounts and controlling access to the resources at different levels
- Execute SQL statements for table maintenance
- Export and Import data using SQL
- Use MySQL to create, execute, and modify the stored procedures, triggers, and views for administrative tasks
- Define and schedule events
- Understand the use of the InnoDB storage engine with MySQL
- Use MySQL tools to perform backup and restore operations
- Improve performance through query optimization
Target audience
- Developers who want to administer MySQL
- Database Administrators
- Database Professionals
Prerequisites
Knowledge of relational database and prior hands-on experience on MySQL is required to attend this training program.
Exams
MySQL 5.6 Database Administrator 1Z0-883