MySQL 5.7 for Database Administrators
Our MySQL 5.7 for Database Administrators training is a comprehensive course designed for both developers and administrators. It covers essential topics such as securing user privileges, setting resource limitations, and implementing access controls. The course also includes creating and using stored procedures, triggers, and views. You'll learn how to install and upgrade MySQL, use the GUI to manage a server, and access metadata through the INFORMATION_SCHEMA database. The course is available in-person or online for public and private groups and is open to Malaysia and international students.
Exam
Certification by
per person
Level
Duration
Training Delivery Format
Face-to-face / Virtual Class
Associated Certification
per person
Level
Duration
Training Delivery Format
Face-to-face (F2F) / Virtual Class
Associated Certification
Class types
Public Class
Private Class
In-House Training
Bespoke
About this course
This MySQL 5.7 for Database Administrators training is a foundation course. It teaches database administrators and developers how to use this powerful database. Learn how to secure users privileges, set resource limitations and access controls. Instructors will show you how to create and use Stored Procedures, Triggers and Views.
The learning objectives including Install and Upgrade MySQL for the most common operating systems, Utilize the MySQL Administrator Graphical User Interface (GUI) to manage a MySQL server, Use the INFORMATION_SCHEMA database to access metadata, Perform the MySQL start and shutdown operations and many more.
This MySQL Database Administrator course is available in our face to face classroom or through a live virtual class training. This training is available for a public and private group. It is open for Malaysia and international students.
Who should attend?
- DBAs and developers who want to administer MySQL.
- Anyone who needs to administer, monitor and support MySQL databases and servers.
Prerequisites
A working knowledge of MySQL is required or attended on the Introduction to MySQL course.
Course Content
Introduction
- Describing MySQL
- Listing MySQL Products and Professional Services
- Describing MySQL Enterprise Subscription
- Currently Supported Operating Systems
- Describing MySQL Certification Program
- Listing Available MySQL Courses
- Describing Installation of MySQL
- Describing Installation of world Database
MySQL Architecture
- Client/Server Architecture
- MySQL Architecture Overview
- How MySQL Uses Disk Space
- How MySQL Uses Memory
- The MySQL Plug-In Interface
The MySQL Server
- Types of MySQL Distributions
- Starting and Stopping MySQL on Windows
- Starting and Stopping MySQL on Linux
- Upgrading MySQL
- Managing Multiple Servers
Configuring the MySQL Server
- MySQL Configuration
- Dynamic Server Variables
- Server SQL Modes
- Log and Status Files
- Binary Logging
MySQL Clients
- Overview of Administrative Clients
- Invoking MySQL Client Programs
- Using the mysql Client
- The mysqladmin Client
- MySQL Connectors
- Third-Party APIs
Overview of Data Types
- Data Types
- Numeric Data Types
- Character String Data Types
- Binary String Data Types
- Temporal Data Types
- NULLs
- Column Attributes
Metadata
- Metadata Access Methods
- The INFORMATION_SCHEMA Database/Schema
- Using SHOW and DESCRIBE
- The mysqlshow Command
Storage Engines
- Storage Engine Overview
- MyISAM, InnoDB, and MEMORY Storage Engines
- Other Storage Engines
- Choosing Appropriate Storage Engines
- Using Multiple Storage Engines
- Storage Engine Comparison Chart
Partitioning
- Overview of Partitioning and reasons for using Partitioning
- Creating a Partitioned Table
- Obtaining Partition Information
- Modifying and Removing Partitions
- Partition Modification Performance Effects
- Partition Pruning
- Storage Engine Partition Information
- Partitioning and Locking and Limitations
Transactions and Locking
- Transactions
- Transaction Control statements
- Isolation Levels
- Locking
Security and User Management
- Security Risks
- Security Measures
- Privileges
- Access Levels, including: 1 – User Accounts, 2 – Databases, 3 – Tables, 4 – Columns, 5 – Stored Routines
- User Account Maintenance
- Client Access Control
- Using Secure Connections
Table Maintenance
- Table Maintenance
- SQL Statements for maintenance operations
- Client and Utility Programs for table maintenance
- Table Maintenance per Storage Engine
Exporting and Importing Data
- Exporting and Importing Data
- Exporting and Importing Data Using SQL
- Import Data with the SQL scripts
Programming with MySQL
- Defining, Executing and Examining Stored Routines
- Stored Routines and Execution Security
- Defining, Creating, and Deleting Triggers
- Trigger Restrictions and Privileges
- Defining Events
- Schedule Events
- DBA’s Use of MySQL Programming
- Backup Stored Routines
Views
- What is a view?
- Creating Views
- Updatable Views
- Managing Views
Backup and Recovery
- Planning for Recovery Backup
- Backup Tools Overview
- Making Raw Backups
- Making Logical (Text) Backups
- Backup Log and Status Files
- Replication as an Aid to Backup
- Backup Method Comparison
- Data Recovery
Introduction to Performance Tuning
- Using EXPLAIN to Analyze Queries
- General Table Optimizations
- Setting and Interpreting MySQL Server Variables
Introduction to High Availability
- MySQL Replication
Conclusion
- Course Overview
- Training and Certification Website
- Course Evaluation
Certification
Exam details
- Format: Multiple Choice
- Duration: 120 Minutes
- Number of Questions: 75
- Passing Score: 58%
At this time, this course is available for private class and in-house training only. Please contact us for any inquiries.