1. know more about MySQL open source database
MySQL: Open Source Database
1
Salaria Software Services

2. Storage engines
Schema
Normalization
Data types
Indexes
Know more about your SQL queries - Using EXPLAIN
Character set and Collation
Resources
2
Salaria Software Services
Outline
3. Generics are inefficient
If you have chosen MySQL, take advantage of its strengths
Having an understanding of the database helps you develop better-performing applications

better to design a well-performing database-driven application from the start

4. than try to fix a slow one after the fact!3
Salaria Software Services
Why is it significant for a developerto know MySQL?
5. Salaria Software Services
4
MySQL Pluggable Storage EngineArchitecture
MySQL supports several storage engines that act as handlers for different table types

No other database vendor offers this capability