I know you can apply Python to data analytics, but can you do everything with Python that you can do with SQL?

Question

Since the two can both be applied to data analysis, I'm wondering what advantages of SQL to concentrate on.

Answer 1

You can do so much more with Python than just SQL! Of course you can query your database with SQL statements, but you can also mangle, transform and bend your data outputs any way you want with Python.
Not to mention that you can orchestrate the whole data processing pipeline from data acqusition through data mining, data cleaning, data processing to automation of decision making :)

Answer 2

Every database has its own libraries. You can do sql with python using sglite module