SQL

[DB] 데이터의 무결성이란?

2025.02.25

[DB] 정규화(Normalization)란?

2025.02.22

[DB] Primary Key, Foreign Key, ER 모델

2025.02.22

[SQL] 피벗 테이블

2024.10.25

[SQL] 윈도우 함수 (RANK OVER, SUM OVER)

2024.10.25

[SQL] 날짜 함수 (DATE, DATE_FORMAT, DATEDIFF, ADDDATE, SUBDATE, NOW, CURDATE)

2024.10.24

[SQL] REPLACE, SUBSTRING, CONCAT

2024.10.24

[SQL] INNER JOIN, LEFT JOIN, 서브쿼리(SUBQUERY)

2024.10.23

[SQL] IF, CASE, NULL, COALESCE

2024.10.22

[SQL] GROUP BY, ORDER BY

2024.10.22

[SQL] AS, 숫자 연산(+, -, *, /), SUM, AVG, COUNT, MIN, MAX

2024.10.22

[SQL] BETWEEN, IN, LIKE

2024.10.22

[SQL] SELECT, FROM, WHERE

2024.10.21