DEV Community

Discussion on: SQL tips for beginners; what I learned after 10+ years of occasionally writing queries and schemas as a web dev

View post
Collapse
 
sanampakuwal profile image
Sanam • • Edited

Let me correct some of these,

  1. Use uppercase for the sql syntax (this is standard practice in dba world)
  2. Use 25 tables instead of 120 is conflicting, Database should be normalizes and its always good to split the SOC table wise and play with id. This point basically disagree the database architecture pattern.
Collapse
 
rap2hpoutre profile image
Raphaël Huchet • • Edited

Thank you for your feedback! (for first point, I guess case is also a matter of opinions: dev.to/redhap/comment/203hn)

Collapse
 
sanampakuwal profile image
Sanam •

Yes it is. Everyone have own style of formatting and preferences :)