DAY 1. basic RDBMS & SQL
Introduce Database
Basic of RDBMS
ERD Modeling
Basic SQL
Database : A system that stores data safely in a clear structure
- divide a lot of tables and save -safely store
- search faster -many people can use this at the same time
- Basic word : Database, Table, DBMS, Column, RDBMS, Row, Domain, Schema
- Database Type - RDBMS, NoSQL
- important: onecell only has one value
- key type : super key, candidate key, Primary Key, alternate key, Foreign Key, surrogate key
- Data Integrity: Ensuring that data remains accurate, complete, and protected from unauthorized modification, corruption, or deletion.
- Normalization: 1NF(first normal form), 2NF(second normal form), 3NF(third normal form)
- A(atomicity / 부분성공금지)
- B(consistency / 항상 규칙 충족)
- I(Isolation / 동시에 실행돼도 정확)
- D(durability / 기록 영구 보존)
- Entity Relationship Diagram
- SQL (Structured Query Language) is the standard language designed for managing data in relational database management systems (RDBMS).
