SQL Fundamentals

May 18, 2025

Database Types

  1. Relational Database
  2. Non-Relational Database

Structure

  1. Relational Database

    1. Primary key is the main identifier for rows and ensures uniqueness
    2. Foreign key allows us to develop relations
  2. Non-Relational Database

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

Categories: