From the course: Choosing a Database: PostgreSQL, MySQL, Mongo, and Cloud

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Dialect nuances

Dialect nuances - SQL Tutorial

From the course: Choosing a Database: PostgreSQL, MySQL, Mongo, and Cloud

Start my 1-month free trial

Dialect nuances

- [Instructor] As mentioned, MongoDB is a document oriented database. It does not use a SQL because there would be no actual data types tables to join on. Everything is stored in (indistinct) considered a semi-structured data type. This format is probably a pro to most developers who would prefer working in something that looks more like a programming language. MongoDB stores collections which in turn stores fields. We can see an example of this right now. So let's take a look at a collection. So we're not going to create a collection. Usually, I would want to go through credit statements which we will go through some of those in a bit. But if we were to create a collection, we would do DB for database, create collection and let's call it customers. We're going to look at our customer's table today. We're not going to run this because I actually created this earlier for the later examples. But if we want to see…

Contents