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 - SQL Tutorial
From the course: Choosing a Database: PostgreSQL, MySQL, Mongo, and Cloud
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.