It's good to be thinking of this stuff though. I highly recommend Athlean-X(his free youtube videos, can't say anything about his programs) and Mark Rippetoe's Starting Strength program. Between these two, I've gotten into a little weightlifting and I'm loving it. My posture is better than it's been in 40 years.
Just do yourself a favor and go slow. Muscles adapt quickly but joints take time. Lay off the creatine until you have some experience. The 2 best supplements you can take are protein and sleep. Don't forget to hydrate and don't overtrain.
If you get a trainer, get a good one. I got a bro who encouraged me to go too far too fast and now I've got a messed up shoulder. Done properly, weightlifting is one of the safest sports.
If you're a keyboard jockey like me, chances are you have weak external rotator cuff muscles, weak serratus anterior muscles, and tight pec minors. Look into correcting all of that first, before you start shredding your shoulder joint with bench presses and bicep curls.