What programming language should I learn for a career in data science?

I've been interested in data science for a while now, and I've decided to take the plunge and start learning. I have a background in mathematics and statistics, but I don't have any prior programming experience. I've been doing some research, and I'm having a hard time deciding which programming language to learn. I've heard that Python and R are popular choices, but I've also seen some people recommend Julia and SQL.

I'm looking for a language that will give me a good foundation in data science and also have good job prospects. I'd like to be able to work with large datasets and perform machine learning tasks. I've also heard that it's important to learn a language that has a large community and plenty of libraries and resources available.

Can anyone recommend a programming language for me to learn, and are there any specific resources or courses that you would recommend for a beginner like me? Should I start with the basics of programming and then move on to data science specific topics, or can I dive right in and learn as I go?