I made some early mistakes myself – I let unemployment grow in my homeworld when I could easily have created new jobs. Didn’t take long to fix, though.
I found Quill18’s tutorial video moderately helpful here. He suggested constructing one or two districts first, rather than buildings, as district “slots” are usually less scarce than building slots. He pointed out that City districts create fewer jobs (1 clerk here, vs 2 jobs in other districts) but add a lot of housing, if you need that. He also walked through the trade system and piracy nicely. Much of what he said I’d already figured out on my own, but I’m still glad I watched it.