SQL(MySQL) MUST KNOW
1.데이터베이스(DB) 그리고 RDBMS
DB와 RDBMS가 뭔지 알아봅시다!
2.SQL과 MySQL
SQL은 뭐고 MySQL은 뭔데?
3.SQL의 4가지 문법 종류
SQL의 종류!
4.MySQL DDL (Data Definition Language) 실습!
MySQL DDL 문법! (Thumbnail by ChatGPT)
5.MySQL DML (Data Manipulation Language) 실습!
MySQL에서 DML 문법들! (Thumbnail by ChatGPT)
6.MySQL DCL (Data Control Language) 훑어보기!
MySQL DCL 찍먹! (Thumbnail by ChatGPT)
7.SELECT 문법 (1): LIMIT, COUNT, DISTINCT
본격적으로 시작! LIMIT, COUNT, DISTINCT (Thumbnail by ChatGPT)
8.SELECT 문법 (2): Aggregate 함수, AS, GROUP BY, ORDER BY
SELECT 문법 (2): Aggregate 함수, AS, GROUP BY, ORDER BY. (Thumbnail by ChatGPT)
9.MySQL 중급 문법: HAVING, INNER/OUTER JOIN, 서브쿼리
HAVING, INNER/OUTER JOIN, 서브쿼리에 대해서 알아봅시다! (Thumbnail by ChatGPT)
10.[참고] MySQL INDEX
MySQL INDEX는 또 뭐지?!? (Thumbnail by ChatGPT)
11.SQL Advanced: 문자열 함수
SQL String Functions! (Thumbnail by ChatGPT)
12.SQL Advanced: 날짜/시간 함수
SQL Data/Time Functions! (Thumbnail by ChatGPT)
13.SQL Advanced: 숫자 함수
SQL Numerical Functions! (Thumbnail by ChatGPT)
14.SQL Advanced: 중급 서브쿼리
SQL Advanced Sub-Query (Thumbnail by ChatGPT)
15.SQL Advanced: 집합 연산자
SQL Set Operators! (Thumbnail by ChatGPT)
16.MySQL TCL (Transaction Control Language) 실습!
SQL Transactions! (Thumbnail by ChatGPT)
17.SQL Advanced: VIEW
SQL ViEW! (Thumbnail by ChatGPT)
18.SQL Advanced: WITH
SQL WITH! (Thumbnail by ChatGPT)
19.SQL Advanced: CASE-WHEN
SQL CASE-WHEN! (Thumbnail by ChatGPT)
20.SQL Advanced: GROUP_CONCAT(...)
SQL GROUP_CONCAT! (Thumbnail by ChatGPT)
21.SQL Window Functions: 윈도우 함수란?
What is SQL Window Functions? (Thumbnail by ChatGPT)
22.SQL Window Functions: RANK(), DENSE_RANK(), ROW_NUMBER()
SQL RANK() , DENSE_RANK() , ROW_NUMBER() (Thumbnail by ChatGPT)
23.SQL Window Functions: PARTITION BY, ORDER BY, ROWS/RANGE
SQL PARTITION BY, ORDER BY, ROWS/RANGE! (Thumbnail by ChatGTP)