Here's a Friday discussion. As an application developer, I can write SQL pretty well, but I wouldn't say that I'm an expert. My last project I did run into some design and architecture issues that needed a little bit of reworking and refactoring. To help avoid this, I want to get better and have more confidence moving forward in a project that my schema design has been optimized, or at least perform some excercise to let me know that I gave it a good effort.
Any insights on how as application developers, we can perform some exercise with some tool at the early design phases that will help us give us confidence that our initial schema, indexes and queries are optimized?
