MySQL Tutorial

In this tutorial, you will learn below topics.

  1. Introduction
  2. Installation of MySQL
  3. Getting MySQL server information
  4. RDBMS Concepts
  5. Data Definition Language (DDL) – Data types, Managing Databases, Managing Tables, Managing Views
  6. Data Manipulation Language (DML) – Inserting records in a table, Updating records in a table, Deleting records from a table,  Retrieving Records
  7. Data Control Language (DCL)
  8. Variables in MySQL
  9. Procedures in MySQL
  10. Functions in MySQL – Built-In functions in MySQL, User Defined functions in MySQL
  11. Triggers in MySQL
  12. Cursors in MySQL
  13. Transaction control
  14. Event scheduler
  15. Tuning MySQL Server Performance
  16. MySQL Administration – Managing users, Importing and Exporting data
  17. Database Testing
  18. MySQL Clients – Workbench, PHPMyAdmin
  19. MySQL libraries – Java, .Net, PHP, Python