🗃️Database

• Backend Engineering
• Spring Data Access Technologies

Fundamentals & Overview

• SQL (Relational) vs NoSQL (Non Relational)
• Database & DBMS & RDB
• db notes

Database Design & Modeling

How to structure data before writing code

• Database Design
• Data Modeling
  • Data Modeling - 4 main steps
  • 개념적 모델링
• Entity Design
  • ⭐Entity Design - single entity
  • ⭐Entity Relationship Mapping - relationship between entities
  • ERD
• Normalization
  • Database Normalization
  • External: 설계 검증, 최적화, 역정규화

SQL & Relational Databases

• The Language (SQL)
  • SQL
  • DDL (Data Definition Language)
  • DML (Data Manipulation Language)
  • SQL - JOIN
  • Aggregation & Grouping
• The Systems (RDBMS)
  • PostgreSQL

NoSQL & Caching

Non-relational stores and speed layers.

• Document Stores
  • 🍃MongoDB
• Key-Value & Caching
  • Redis

Transactions & Safety

Ensuring data integrity.

• Database Transaction
• ACID
• Isolation levels and concurrency control

Performance & Scaling

Making it fast and keeping it online.

• Database Performance Optimization
• Indexing
  • Database Indexing
• Scaling Strategies
  • Database Partitioning
  • Database Sharding
  • Database Replication