There are many books that will help teach you to be a successful gardiner. It appears you are beyond most when it comes to long term planning but your brown thumb needs to turn green. Practice in pots, raised beds and small yard areas. Just keep trying and you will become an expert at gardening as you are in so many other things. I have a friend coop and his mom has been very helpful to me. It’s because of all that she has taught me that I have become a better prepper/man