Administering & Developing MySQL Databases

Course Description:

The Administering and Developing MySQL Databases Course is a one-day class that examines the core skills in database administartion. The course uses the new version 8.0 of MySQL, and covers a number of the new administrative features added to MySQL including improved error logging, password policies, privileges, accounts, and backup and recovery. Students will learn these administration functions in a hands-on format, using the MySQL workbench and command line utilities during the course. The course may be taken by itself as a one day course of training or as a four day course which includes the topics from this course and the topics from the three day Querying MySQL course.

Topics covered in the course include:

• How to design a database
• How to create triggers and events
• An introduction to database administration
• How to secure a database
• How to back up and restore a database

Target Student:

Prerequisites:

Students should have some experience with MySQL Querying.

Section 1: How to design a database
Using MySQL Workbench for database design
How to open an existing EER model
Creating a new EER model
Working with with an EER model
Working with with an EER diagram

Section 2: Creating triggers and events
Working with with triggers
Creating a BEFORE trigger
Using a trigger to enforce data consistency
Creating an AFTER trigger
How to view or drop triggers
Working with with events
How to turn the event scheduler on or off
Creating an event
How to view, alter, or drop events

Section 3: An introduction to database administration
Database administration concepts
Database administrator responsibilities
Types of database files
Types of log files
How to monitor the server
How to view the server status
How to view and kill processes
How to view the status variables
How to view the system variables
How to configure the server
Setting system variables using MySQL Workbench
Setting system variables using a text editor
Setting system variables using the SET statement

Section 4: How to secure a database
An introduction to user accounts
An introduction to SQL statements for user accounts
A summary of privileges
The four privilege levels
The grant tables in the mysql database
Working with with users and privileges
Creating, rename, and drop users
How to specify user account names
How to grant privileges
How to view privileges
How to revoke privileges
How to change passwords
A script that creates users
Working with with roles
Creating, manage, and drop roles
A script that creates users and roles
Using MySQL Workbench
Working with with users and privileges
How to connect as a user for testing

Section 5: How to back up and restore a database
Strategies for backing up and restoring a database
A backup strategy
A restore strategy
How to back up a database
How use mysqldump to back up a database
A SQL script file for a database backup
Setting advanced options for a database backup
How to restore a database
Using a SQL script file to restore a full backup
How to execute statements in the binary log
How to import and export data
How to export data to a file
How to import data from a file
How to check and repair tables
Using the CHECK TABLE statement
How to repair a MyISAM table
How to repair an InnoDB table
Using the mysqlcheck program
Using the myisamchk program

We offer live-instructor group training classes for your team.

Upskill your team from the comfort of your office or online.

Benefits of Group Training Include:

• Experienced Professional Instructor Trains Your Team
• Content Focused On Your Team's Needs
• Convenient Scheduling and Class Setup
• Significant Per/Student Cost Savings
• Online, On-Site and Blended Options Available

Get A Free Consultation