Summer Training : MySQL Training Content

  1. Basic database concepts
  2. Database Creation
  3. MySql engine (InnoDB vs MyISAM) which one is best for my application
  4. Data Types, Data size & range of values (how to select data type for my data)
  5. Table Creation, Insert Data, Update Data, Delete Data
  6. Concept of Primary Key, Foreign Key, Index, Auto Increment
  7. Unique Key
  8. Query optimization
  9. Use of group by queries
  10. Data encryption (MD5)
  11. MySql Date functions
  12. Database backup & recovery