In this tutorial, you will learn below topics.
- Introduction
- Installation of MySQL
- Getting MySQL server information
- RDBMS Concepts
- Data Definition Language (DDL) – Data types, Managing Databases, Managing Tables, Managing Views
- Data Manipulation Language (DML) – Inserting records in a table, Updating records in a table, Deleting records from a table, Retrieving Records
- Data Control Language (DCL)
- Variables in MySQL
- Procedures in MySQL
- Functions in MySQL – Built-In functions in MySQL, User Defined functions in MySQL
- Triggers in MySQL
- Cursors in MySQL
- Transaction control
- Event scheduler
- Tuning MySQL Server Performance
- MySQL Administration – Managing users, Importing and Exporting data
- Database Testing
- MySQL Clients – Workbench, PHPMyAdmin
- MySQL libraries – Java, .Net, PHP, Python
Recent Comments