Are free online courses with certificates for SQL, and Python any good for real world use cases?

I would conclude this in some points:

  1. What matters is your knowledge of the skill and not the certificates.
  2. Certificates are Certificates, paid or free, doesn’t matter as no certificate mentions that the course was free or paid.

So, focus only on your skills as no one will see your certificates if you don’t know anything.