SQL to MongoDB terms



SQL                       MongoDB
--------                  --------
database                  database
table                     collection
row                       BSON document

index                     index
column                    not really
join                      Lookup
                          embedding
Foreign key               Reference
primary key               _id field
group by                  aggregation
Multi-table transaction   Single document transaction