My-SQL Training In Nepal

Advanced My-SQL : My-SQL Expert
This MySQL for Developers training teaches developers how to develop console and web applications using MySQL. You have a choice of the PHP, Java, or Python programming languages. In this course, you will be introduced to the MySQL Cloud Service.

Introduction to MySQL

  • MySQL overview
  • MySQL Enterprise Edition
  • MySQL on the Web
  • MySQL in the Cloud
  • The MySQL community

Installing MySQL

  • Installing MySQL
  • Installed Files and Directories
  • Initial Configuration
  • Starting and Stopping MySQL
  • Upgrading MySQL

MySQL Architecture

  • Architectural Overview
  • How MySQL Transmits Data
  • How MySQL Processes Requests
  • How MySQL Stores Data
  • Tablespaces
  • Redo and Undo Logs
  • How MySQL Uses Memory
  • Plug-in Interface

Configuring MySQL

  • Server Options, Variables, and the Command Line
  • Option Files
  • System Variables
  • Launching Multiple Servers on the Same Host

Monitoring MySQL

  • Monitoring MySQL with Log Files
  • Monitoring MySQL with Status Variables
  • Monitoring MySQL with Performance Schema
  • MySQL Enterprise Audit
  • MySQL Enterprise Monitor
  • Monitoring User Activity

User Management

  • MySQL Privilege System
  • Creating and Modifying User Accounts
  • Configuring Passwords and Account Expiration
  • Authentication Plug-Ins
  • Granting Permissions
  • Grant Tables
  • Resetting a Forgotten Root Password

MySQL Security

  • Security Risks
  • Network Security
  • Secure Connections
  • Password Security
  • Operating System Security
  • Protecting Against SQL Injections
  • MySQL Enterprise Firewall

Maintaining a Stable System

  • Stability
  • Why Databases Fail
  • Capacity Planning
  • Troubleshooting
  • Identifying the Causes of Server Slowdowns
  • InnoDB Recovery

Optimizing Query Performance

  • Identifying Slow Queries
  • The EXPLAIN statement
  • Working with Indexes
  • Index Statistics

Backup Strategies

  • Understanding Backups
  • Backup Techniques
  • Creating a Backup Strategy

Performing Backups

  • MySQL Backup Tools
  • Raw Backup Methods
  • Techniques that Use the Binary Log

Configuring a Replication Topology

  • Overview of Replication
  • Replication Conflicts
  • When to Use Replication
  • Configuring Replication

Administering a Replication Topology

  • Failover
  • MySQL Utilities
  • Replication Threads
  • Monitoring Replication
  • Troubleshooting Replication

Group Replication

  • Overview
  • Single-Primary and Multi-Primary Modes
  • Configuring Group Replication
  • Monitoring Group Replication

Conclusion

  • Course Overview
  • MySQL Curriculum
  • Course Evaluation
  • Thank You!
  • Q&A Session