SQL and databases are something that not many engineers tend to play with. But a database can be a very powerful tool when used proplerly. Often it can get the job done much easier and faster than everyones favorite tool… Excel!
Using Excel as a hammer
For many Excel is the goto tool in thier toolbox and understandably so. It is easy to pick up and learn and is flexible enough to handle even some of the most complicated number crunching. However the time will inevitably come where it has gone too far!
(show what can be done with SQL)
Then what tools should I use?
(simple example) (IDE with Visual Studio - link)