mysql Database Training Course

Duration:
30 HRS

Subjects:
mysql open source database

  • 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