MySQL Tutorial Objective

Session 01: Installing and Upgrading MySQL

Session 02: MySQL Tutorial

Session 03: MySQL Server Administration

Session 04: The MySQL Data Directory

Session 05: The mysql System Schema

Session 06: MySQL Server Logs

Session 07: MySQL Server Components

Session 08: MySQL Server Plugins

Session 09: MySQL Server User-Defined Functions

Session 10: Running Multiple MySQL Instances on One Machine

Session 11: Security

Session 12: Backup and Recovery

Session 13: Optimization

Session 14: Replication

Session 15: Group Replication

Detailed Syllabus:

Session 01: Installing and Upgrading MySQL

Installing MySQL on UNIX/Linux using Binaries
Installing MySQL on Microsoft
Installing MySQL on Linux
Installing MySQL from Source
Post Installation Setup and Testing
Upgrading MySQL
Downgrading MySQL

Session 02: MySQL Tutorial

Connecting to and Disconnecting from the Server
Entering Queries
Creating and Using a Database
Getting Information About Databases and Tables
Using MySQL in Batch Mode
Examples of Common Queries
Using MySQL with Apache

Session 03: MySQL Server Administration

Configuring the Server
Server Configuration Defaults
Server Configuration Validation
Server Option, System Variable, and Status Variable Reference
Server System Variables Reference
Server Status Variable Reference
Server Command Options
Server System Variables
Using System Variables
Server Status Variables
Server SQL Modes
IPv6 Support
MySQL Server Time Zone Support
Server-Side Help Support
Server Tracking of Client Session State Changes
Server Response to Signals
The Server Shutdown Process

Session 04: The MySQL Data Directory

Session 05: The MySQL System Schema

Session 06: MySQL Server Logs

Selecting General Query Log and Slow Query Log Output Destinations
The Error Log
The General Query Log
The Binary Log
The Slow Query Log
The DDL Log
Server Log Maintenance

Session 07: MySQL Server Components

Installing and Uninstalling Components
Obtaining Server Component Information
Error Log Components

Session 08: MySQL Server Plugins

Installing and Uninstalling Plugins
Obtaining Server Plugin Information
MySQL Enterprise Thread Pool
The Rewriter Query Rewrite Plugin
The ddl_rewriter Plugin
Version Tokens

Session 09: MySQL Server User-Defined Functions

Installing and Uninstalling User-Defined Functions
Obtaining User-Defined Function Information

Session 10: Running Multiple MySQL Instances on One Machine

Setting Up Multiple Data Directories
Running Multiple MySQL Instances on Windows
Running Multiple MySQL Instances on UNIX
Using Client Programs in a Multiple-Server Environment

Session 11: Security

Keeping Passwords Secure
Making MySQL Secure Against Attackers
Security-Related mysqld Options and Variables
How to Run MySQL as a Normal User
Security Issues with LOAD DATA LOCAL
Client Programming Security Guidelines
Access Control and Account Management
Using Encrypted Connections
Security Components and Plugins

Session 12: Backup and Recovery

Backup and Recovery Types
Database Backup Methods
Example Backup and Recovery Strategy
Using mysqldump for Backup
Point-in-Time (Incremental) Recovery Using the Binary Log
MyISAM Table Maintenance and Crash Recovery

Session 13: Optimization

Optimization Overview
Optimizing SQL Statements
Optimization and Indexes
Optimizing Database Structure
Optimizing for InnoDB Tables
Optimizing for MyISAM Tables
Optimizing for Memory Tables
Understanding the Query Execution Plan
Controlling the Query Optimizer
Buffering and Caching
Optimizing Locking Operations
Optimizing the MySQL Server
Measuring Performance (Benchmarking)
Examining Thread Information

Session 14: Replication

Configuring Replication
Replication Implementation
Replication Solutions
Replication Notes and Tips

Session 15: Group Replication

Group Replication Background
Getting Started
Monitoring Group Replication
Group Replication Operations
Group Replication Security
Group Replication Performance
Upgrading Group Replication
Group Replication System Variables
Requirements and Limitations
Frequently Asked Questions
Group Replication Technical Details

If You Like What We Do Here On DatabaseConcept, You Should Consider:

Stay Connected to: Twitter | Facebook

Subscribe to our email updates: Sign Up Now

 

We are thankful for your support.