Suggestions for a newbie?

Hey I'm a yoga newbie and I am wanting to get into it as it would be beneficial to my health. I have fibromyalgia so my muscles and joints are totally out of whack and I am often in serious pain. My rheumatologist suggested yoga to build strength and muscle tone and said if I developed core strength it may also help with my back pain (scoliosis related). So basically I'm a mess and I need help getting started because it seems overwhelming!

I have a bit of space but no equipment so do I need anything fancy?

Should I watch any videos or read any books? Suggestions? In particular beginner stuff is of interest I am super jealous of the folks who can do handstands but that's not where I am yet so trying to navigate that is becoming frustrating...

Any other tips for beginners or stories of your own practice?

Thanks in advance!