MySQL Database Training Course

MySQL Database training is offered by AEIT for all skill level. Our courses integrate Practical, Hands-on Training & Exposure with Industry Use Case Studies and Real Projects using datasets from companies like Uber, Amazon, Sandisk, Nike, Swiggy, Yelp, and Walmart, etc.

Content:

• History of mysql
• Basic mysql
• Why and Scope of mysql
• mysql as Open source Technology
• mysql for Web Based Application
• mysql Database Engines (INNODB , MyISAM etc.. )
• mysql Data Types (INT , Varchar , Date , timestamp etc..)
• mysql Create Database Query
• mysql List Database Query
• mysql Create Table
• mysql List Tables in database Query
• mysql Show Table Fields
• mysql er query
• mysql Primary Key Constraint
• mysql Unique Key Constraint
• mysql Full Text Key Constraint
• mysql Foreign Key Constraint
• mysql Where clause
• mysql Alias
• mysql Where clause with AND Logic
• mysql Where clause with OR Logic
• mysql Where clause with AND & OR Logic
• mysql Like Query with wild card character
• mysql Between Query with Example
• mysql Order By Query with Example
• mysql Group By Query with Example
• mysql Having Clause
• mysql Sub Query Example
• Import and Export through Command line
• Import and Export through PHPMYADMIN Tool
• mysql Functions - AVG()
• mysql Functions - MIN()
• mysql Functions - MAX()
• mysql Functions - COUNT()
• mysql Functions - SUM()
• mysql Functions - ROUND()
• mysql Functions - CONCAT()
• mysql Functions - LCASE()
• mysql Functions - UCASE()
• mysql Functions - repeat()
• mysql Functions - substr()
• mysql Functions - strpos()
• mysql Functions - sqrt()
• mysql Functions - power()
• mysql Functions - abs()
• mysql Functions - concat_ws()
• mysql Functions - concat()
• mysql Functions - curdate()
• mysql Functions - curtime()
• mysql Functions - datediff()
• mysql Functions - hour()
• mysql Functions - second()
• mysql Functions - day()
• mysql Functions - month()
• mysql Functions - now()
• mysql inner Join
• mysql Left Join
• mysql Right Join
• mysql Natural Join
• mysql Roll back and Commit
• mysql Union
• mysql Query Optimization Concept
• mysql Views
• mysql Stored Procedures
• mysql Triggers
• mysql Functions
• mysql Clustering
• mysql Indexing
• mysql Database Normalisation concept