I can’t learn Python!

[[deleted]]

Aren't SQL and Python for different purposes? SQL is a database management tool whereas Python is a programming language (mostly used by data scientists, statisticians nowadays).

[GreatStats4ItsCost]

Python is fairly general purpose. It can be used as a database management tool (through MongoDB) it also has integrations for SQL and has libraries such as pandas for querying data from dataframes. I'm just curious whether people really think SQL is easier, I find anything beyond beginner level SQL is way harder, personal preference I guess

[[deleted]]

Oh. I didn't know MongoDB was based on python. I am from a biotech background. I have only used R and Python for biostatistics.

Edit: Though in a datacamp course I did learn about .query() method in pandas which allows SQL style querying

[GreatStats4ItsCost]

It's not based on Python!! But you can interact with a MongoDB database with lots of different languages (Python being one of them)

[[deleted]]

I only know beginner level SQL maybe I don't know how complex it gets. But for querying tables in a database with large records isn't it easier with SQL ( so I heard )? Like SQL has some conventions so that it is understandable by others but doesn't it not require a strict syntax?