MYSQL Database Training

Content

Introduction, Installation and Configuration, Basic Select Statements, Using Expressions in MySQL Statements, Inserting, Updating and Deleting Records in MySQL, Data Validation in MySQL, Advanced Queries, Aggregate Functions and Grouping, Programming with MySQL, Managing Transactions in MySQL, Database METADATA, Database Maintenance, SQL Modes and Log Files, CHARACTER SET SUPPORT, TRANSACTIONS AND LOCKING, Security and Access Management, Stored Routines and Triggers, Exporting and Importing Data in MySQL, Backup and Recovery, Partition and Replication, Optimization and Performance, Using Multiple Servers