1 of 16

Databases

Week 7

2 of 16

Persistence

3 of 16

Last Missing Piece of the Stack

4 of 16

Which means...

5 of 16

We are officially

Full Stack™

6 of 16

Definition

A program that can store and retrieve data efficiently.

7 of 16

Type: SQL

  • Relational - tables have relationships to each other
  • Normalized - data is not duplicated

8 of 16

Famous SQL Databases

9 of 16

We’ll be learning Postgres

10 of 16

Type: NoSQL

  • Specialized - can be extremely high performance
  • Scale to massive data sets
  • Best learned after SQL

11 of 16

Type NoSQL - Key-Value

​

Only retrieve by key

key=1c8efcb

key=ab56df24

12 of 16

Type NoSQL - Document

Find documents where age = 5

​

{

“name”: “Rayo”,

“age” : 5

}

{

“name”: “Maní”,

“age” : 5

}

13 of 16

FAQ

14 of 16

Why learn SQL first vs NoSQL?

  • SQL used most in interviews
  • SQL is fast until data becomes huge
  • SQL is flexible

15 of 16

How much DB for “full-stack”?

  • Equally important as HTML & HTTP
  • Writing and fixing SQL queries

16 of 16

Your questions...