In this tutorial you will learn MySql database, how to create database then creating table, view, trigger, inserting data into table, updating database object etc.
If you don’t have MySQL database in your local environment, then download and install MySql right version for your operating system
Creating new mysql database using script, renaming database, dropping database, taking database backup with data.
Creating database user and grating permission, revoking permission etc.
Creating table, inserting, updating, deleting records, setting child parent relationship , altering table name etc.
Creating view, altering and dropping view, renaming view, setting permission to view etc.
Understanding concept of different type of triggers, writing new trigger, dropping trigger
Creating new stored procedure in mysql, calling stored procedure from another procedure, altering procedure, renaming stored procedure.
Setting transaction block in mysql queries , commit and rollback transaction
Implementing error handling in mysql queries , reading error details