Currently, I use Perplexity or ChatGPT via the web prompt for small coding tasks, but sometimes I'll use Ollama. Stuff like writing a shell script perform some task, or maybe a small Python function. I'd like to get to the next level, but I don't know where to start.

What are some good places to get started? What are the tools you use to get work done?

Some background: I mainly do data engineering using Python and Snowflake + MySQL. I use Pycharm as my dev environment, but I'd be open to changing that if there's a better option.