데이터베이스 인트로 📝

2019-04-29


What is Database?

What is DBMS?

CRUD


Two Types of DB

Relational Databases (SQL)

Non-Relational (noSQL / not just SQL)

Relational Databases (SQL)

Non-Relational Databases (noSQL / not just SQL)


Database Queries


Tables and Keys

(Red - Primary Key, Green - Foreign Key)

Primary Key : unique key


SQL


Queries

example
SELECT employee.name, employee.age
FROM employee
WHERE employee.salary > 3000

자료