Hi all,

Wanted to get some insight from anyone who does programming/coding as a career and focuses on database management. Was looking into codeacademy courses but wanted to get your insight if you’re in the database management field:

What helped you in your career?

What do you wish you did differently?

What advice would you give yourself starting out that you wish you knew then?

learn why indexes are useful

learn normal forms

think about why duplicating data might sometimes be the best idea (data duplication might reduce the amount of data you need to join and make your design simpler in the end)

often something that is hard to do purely with database design is trivial to enforce with business logic, thereby making your database design simpler.