DB

1.트랜잭션 (Transaction)

post-thumbnail

2.DB 관리

post-thumbnail

3.ORM (Object Relational Mapping, 객체-관계 매핑)

post-thumbnail

4.SQL 쿼리문 - DDL, DML, DCL

post-thumbnail

5.더미 데이터 (Dummy data)

post-thumbnail

6.식별자

post-thumbnail

7.mongoDB Atlas

post-thumbnail

8.DB (데이터베이스)

post-thumbnail

9.기본적인 SQL 이해, 설치 및 준비

post-thumbnail

10.SQL - show, select

post-thumbnail

11.SQL - 에러

post-thumbnail

12.SQL - 통계, Group by, Order by (+ Where)

post-thumbnail

13.SQL - 별칭

post-thumbnail

14.SQL - Join, Union

post-thumbnail

15.SQL - Subquery (서브쿼리)

post-thumbnail

16.SQL - 문자열, Case

post-thumbnail

17.MySQL

post-thumbnail

18.SQL, DBMS, RDBMS

post-thumbnail

19.SQL, NoSQL

post-thumbnail

20.SQL - TOP, LIMIT, ROWNUM, DISTINCT, COUNT

post-thumbnail

21.SQL - Where 절

post-thumbnail

22.SQL - DDL (CREATE, ALTER, DROP, TRUNCATE, COMMENT, RENAME)

post-thumbnail

23.SQL - DML (SELECT, INSERT, UPDATE, DELETE, MERGE, CALL, EXPLAIN PLAN, LOCK TABLE)

post-thumbnail

24.SQL - TCL (COMMIT, ROLLBACK, SAVEPOINT, SET TRANSACTION)

post-thumbnail

25.SQL - DCL (GRANT, REVOKE, DENY)

post-thumbnail

26.SQL - MIN, MAX, AVG, SUM, HAVING

post-thumbnail

27.SQL - INSERT, UPDATE, DELETE

post-thumbnail

28.DB 와 연동하기

post-thumbnail

29.SQL - CREATE + 제약 조건

post-thumbnail

30.기본 키 PK vs 외래 키 FK

post-thumbnail

31.ERD (Entity Relationship Diagram)

post-thumbnail

32.연관관계

post-thumbnail

33.데이터 무결성

post-thumbnail

34.H2 Database 사용법

post-thumbnail

35.RDBMS(관계형 DB) 와 NoSQL(비관계형 DB)

post-thumbnail

36.RDBMS 의 정규화 (Normalization)

post-thumbnail

37.쿼리 최적화

post-thumbnail

38.DB 로직 최소화

post-thumbnail

39.Redis vs RabbitMQ

post-thumbnail

40.정규화 vs 비정규화

post-thumbnail

41.인덱스, 복합 인덱스

post-thumbnail