When to feel confident about listing sql or power bi or tableau as a skill?

An online course in the past wasn't enough. I didn't absorb it. (I worked with a database and sas for years) now feeling outdated. If I watch videos again, then try and make something without peeking ? For now I shouldn't go for a job that lists something I'm not good in. I wouldn't feel confident. Of course all job ads look hard and feeling down being out of work with a family to feed

bi datascience power power bi sql tableau