12/4/2017 - 3:36 PM

Operation Compare - Mongo vs Sql

SQL Terms/Concepts	MongoDB Terms/Concepts
database	          database
table	              collection
row	                document or BSON document
column	            field
index	              index
table           joins	$lookup, embedded documents
primary key

Specify any unique column or column combination as primary key.

primary key

In MongoDB, the primary key is automatically set to the _id field.

aggregation (e.g. group by)	
aggregation pipeline

See the SQL to Aggregation Mapping Chart.