SQL Fundamentals

Database Types

1. Relational Database
2. Non-Relational Database

Structure

1. Relational Database

   1. 

   2. Primary key is the main identifier for rows and ensures uniqueness
   3. Foreign key allows us to develop relations

2. Non-Relational Database

{
   _id: ObjectId("4556712cd2b2397ce1b47661"),
   name: { first: "Thomas", last: "Anderson" },
   date_of_birth: new Date('Sep 2, 1964'),
   occupation: [ "The One"],
   steps_taken : NumberLong(4738947387743977493)
}