Course Details

Previous Page

MySQL: Performance Monitoring, Database Health and Integrity, and Security

Target Audience
Expected Duration
Lesson Objectives
Course Number

The performance, integrity, and security of your MySQL servers is key to maintaining stable, consistent, and secure databases. In this course, you'll learn about monitoring and maintaining your servers while planning for growth, and about security measures to keep your data safe. The course also covers monitoring systems, measuring performance, securing databases, reviewing database metadata, and ensuring data integrity.

Target Audience
Personnel at all levels of an enterprise seeking to attain competency in MySQL


Expected Duration (hours)

Lesson Objectives

MySQL: Performance Monitoring, Database Health and Integrity, and Security

  • start the course
  • determine how well your systems are performing and where improvements can be made
  • use the BENCHMARK function in MySQL to see the execution time of an expression
  • gather information that can be compared to determine if query behavior has changed
  • use third party and open source tools to gather performance data
  • display various values of system counters and their current values
  • determine the infrastructure requirements to meet the changing demands of your servers
  • describe the different monitoring tools and measure performance using different methods
  • recognize various features used to protect and secure your databases
  • create views to protect sensitive data in underlying tables
  • recognize considerations for implementing triggers to increase database security
  • recognize host server security measures
  • protect and control access to database logs and backups
  • identify methods by which data can be compromised
  • implement certificates to increase data security
  • implement policies to create a controlled and consistent environment for database security
  • determine the structure and properties of your databases and their associated objects
  • navigate and query the INFORMATION_SCHEMA database to obtain object properties
  • determine in-place permissions to users and their objects
  • determine what MySQL permissions can be granted
  • recognize how constraints help to ensure the integrity and consistency of your tables
  • implement a UNIQUE index to prevent duplicate data from entering a column
  • recognize how PRIMARY/FOREIGN key relationships help to ensure accurate records
  • implement security and data integrity, as well as view database metadata
  • Course Number: