what all things we should keep in mind to optimize database?

Answer 1

Normalization

Answer 2

sql (this is the basic),mysql (if you are using windows), and oracle (dba), and if you want to go further you can take (plsql.

Answer 3

mysql on windows? guess you mean mssql