MySQL: Performance Monitoring, Database Health and Integrity, and Security
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level
Overview/Description
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
Prerequisites
None
Expected Duration (hours)
2.7
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: df_mysq_a08_it_enus
Expertise Level
Beginner