Alright, before I begin this answer I need to state that I'm not a professional, just an enthusiast, and I would hate to see someone interested in strength training not try it out.
Additionally, while writing this, I sometimes just thought about how I would work out with no hands. That's not meant to offend but it just helped in brainstorming.
What workouts are unsafe for me
I'm going to assume that anything requiring a solid grip, or, both hands gripping is
going to be unsafe. Unfortunately, this knocks out conventional barbell training and
dumbbells. Barbell training could also be rather difficult due to the different arm
lengths.
This is what I wrote when I first started typing this question and I'm going to leave it here. However, after thinking about this more, the truth is that the same workouts that are unsafe for you are the ones that are unsafe for me: where the weight is not under my/your control.
That's the only rule.
Tips on adapting exercises
My first thoughts were that I would mainly stick to machines.
For the lower body, things like the leg press, extension, and curl machines should all be possible. If you go to a fancier gym there could be hyperextension machines for your back. Delt flye and pec flye are still possible. All ab workouts.
For the upper body, I would turn to bands and cable machines. Upper body weight machines could also be viable given they're set correctly. Single-arm workouts should be easier. Some of the grips might be challenging. I had a thought that an ankle strap worn around your wrist might open up some more workouts for you.
There are also some other accessories that might help you out as well. I am not implying that you need these products but I think it is more useful to point out the options available to you.
- Ankle Straps: As mentioned, wrapped around the wrist this could give you an attachment point for bands or cable machines (safety first, though). Cool enough, after thinking of this I found this video of bicep and tricep workouts using this product.
- The Isolator: that last video took me on a ride. This looks like a neat option for cable attachments. The page also has three videos on how to do chest, shoulder, and back exercisees using their product.
- Lifting Hooks: Some arm workouts might benefit from the addition of hooks attached at the wrist.
- Harness: If you're interested in sled work, it could be done using a harness instead of the standard pushing method.
- Barbell Strap: I remembered seeing Larry Wheels use this to deadlift an insane amount after tearing his bicep. Your mileage will vary but it looks promising if you're set on doing barbell deadlifts.
- Safety Squat Bar: part of the difficulty you'd have with barbell squats is supporting the weight. A safety squat bar brings the handgrips closer and moves the centre of mass. I've seen people use this with no hands.
- Wrist straps: not sure on this one depending on your left hand. I use these daily to help out my grip on barbell workouts but you can also wrap it around a dumbbell handle. There's also a cool figure-8 version of these straps. Looks easier to get on but I've never used it.
- Prosthetics: I don't have a specific link for this (I also realize you don't have an amputation) but I have definitely seen power-lifters that are amputees or with missing body parts. This is an article on Chris Ruden born with two fingers on his short left arm. Looks like he uses some sort of hook extension attachment to deadlift. Article states he beat KC Mitchell's deadlift record at 660 lb (KC Mitchel has a great Instagram that I follow. He powerlifts with a prosthetic leg).
How do I go about strength training? (My current best guess is sandbag training)
I think the above helps on what you could do. Any machine can be used to strength train. Sandbag training could definitely be cool. I've seen a guy with one arm do atlas stones, so don't count yourself out. Your question is really broad but I think if you asked "How can I adapt XYZ workout so that I can do it with my situation" you'd get some people with some ideas.
General advice for my situation that you think is useful
Don't get discouraged. Being strong is bad-ass and you have every right to want to be strong.
Start slow. Ask questions. Any personal trainer worth their weight should be able to help you out, however, don't be surprised if someone says they don't know.
When you go to the gym focus on yourself. Don't focus on what others are doing. The gym is for everyone and you have as much of a right to the equipment as anyone else paying for it.
Try to go to the gym with family or friends. It helps to have a buddy for motivation as well as for figuring stuff out.
Remember that diet is the larger half of getting strong and looking strong.
Sites/forums and other resources that might be useful for me
I'll edit here if I come across any other ideas.
- Chris Ruden's YouTube Channel -- previously mentioned, I think he might be a guy to check out. Two fingers on the left hand and the dude's jacked. He lifts more than me, cool.