SQL Fundamentals

May 18, 2025

Database Types

  1. Relational Database
  2. Non-Relational Database

Structure

  1. Relational Database

    2. Primary key is the main identifier for rows and ensures uniqueness
    3. 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)
}

Tags:

Categories: