Writing code that works is the minimum requirement. Writing code that is maintainable is the hallmark of a senior developer.
1The Semicolon Rule
While some database systems allow you to omit the semicolon for single queries, always including it is a best practice that prevents errors when executing multiple statements in a batch.
2Readable Logic
A query like SELECT name, age FROM users WHERE status = 'active' ORDER BY age DESC; is much easier to debug when spread across four lines with proper indentation.
3Naming Conventions
Stick to a naming convention. Whether you use snake_case (e.g., user_accounts) or camelCase, consistency across your database schema is key to avoiding confusion.
