What to read to test well?

Question

Software testing

Good afternoon!
At work, you often have to test your developments and, as a result, some jambs constantly remain, sometimes even very critical and, at the same time, lying on the surface. I realized that I just don't know how to do it right in a short time and with high quality...
The problem is that tools are developed using different languages ​​and technologies, i.e. literature is needed "universal", ie. which reveals the very essence of how to do it better. In particular, we mainly make molds in Excel, Access, i.e. we use VBA, we have MS SQL as a database. We have to test both SQL procedures/functions and Excel forms/code.
Another problem is that the mode of operation is the hair back, often there is no time to sketch out the scheme of the tool, i.e. do it in code.
Please advise literature so that I can finally do normal things. Thanks

Answer 1

I'm on a mobile phone now, here's a cool article on your mobile phone habrahabr.ru/post/244345