Admin Video

Welcome! Please log in.

Latest videos

channel title pub@ cre@ del
์‰ฌ์šด์ฝ”๋“œ Ep.1 ์‰ฌ์šด์ฝ”๋“œ ์ƒ๊ฐํ•˜๋Š” ํ˜น์€ ์ถ”๊ตฌํ•˜๋Š” ์‹œ๋‹ˆ์–ด ๊ฐœ๋ฐœ์ž (feat. ์ฃผ๋‹ˆ์–ด vs ์‹œ๋‹ˆ์–ด) 2025-02-06 10:45:59 2025-02-06 11:05:25 x
์‰ฌ์šด์ฝ”๋“œ ์ฑ„๋„ ์šด์˜ ๋ฐฉํ–ฅ์— ๋ณ€๊ฒฝ์ด ์žˆ์–ด์„œ ๊ณต์œ  ๋“œ๋ฆฌ๊ณ ์ž ํ•ฉ๋‹ˆ๋‹ค (feat. Road to Senior ์‹œ๋ฆฌ์ฆˆ!) 2025-02-03 21:30:04 2025-02-03 22:05:27 x
์‰ฌ์šด์ฝ”๋“œ byte-stream protocol vs message-oriented protocol 2024-12-23 21:30:49 2024-12-23 22:05:15 x
์‰ฌ์šด์ฝ”๋“œ TCP/IP stack ๋ฐ์ดํ„ฐ ์ „์†ก ๋ฐฉ์‹ (์š”์•ฝ ํ†ตํ•ฉ๋ณธ) 2024-12-09 15:15:00 2024-12-09 16:05:25 x
์‰ฌ์šด์ฝ”๋“œ TCP/IP stack ๋ฐ์ดํ„ฐ ์ „์†ก (Part 1) 2024-12-02 15:00:09 2024-12-02 15:05:26 x
์‰ฌ์šด์ฝ”๋“œ ๊ฐœ๋ฐœ์ž ์•„๋น ๊ฐ€ ๋ ˆ๊ณ ์— ์ง„์‹ฌ์ผ ๋•Œ #์œก์•„layer์•„ํ‚คํ…์ฒ˜ 2024-11-29 10:15:00 2024-11-29 11:05:25 x
์‰ฌ์šด์ฝ”๋“œ ๋‹ค๋ฅธ ์˜ˆ์ œ๋กœ ์†Œ์ผ“ ์‹๋ณ„ ๋ฐฉ์‹์„ ์„ค๋ช…ํ•ฉ๋‹ˆ๋‹ค. segment datagram packet frame payload multiplexing demultiplexing ๊ฐœ๋…๋„ ์„ค๋ช…ํ•ฉ๋‹ˆ๋‹ค. 2024-11-27 21:00:53 2024-11-27 21:05:25 x
์‰ฌ์šด์ฝ”๋“œ ๊ธฐ๋‹ค๋ ค์ฃผ์…”์„œ ๊ฐ์‚ฌํ•ฉ๋‹ˆ๋‹ค! 2024-11-20 21:01:14 2024-11-20 21:05:26 x
์‰ฌ์šด์ฝ”๋“œ ์‰ฌ์šด์ฝ”๋“œ๋‹˜์˜ ์‹ค์‹œ๊ฐ„ ์ŠคํŠธ๋ฆผ 2023-10-08 23:41:49 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ ๐Ÿ”ธ์ค‘์š” ๊ณต์ง€!! ๋งŽ์€ ๊ณ ๋ฏผ ๋์— ๋‹ค์‹œ ํ˜„์—…์œผ๋กœ ๋ณต๊ท€ํ•˜๊ฒŒ ๋์Šต๋‹ˆ๋‹ค 2023-06-02 17:30:11 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ [2๋ถ€] ํ”„๋กœํ† ์ฝœ ํ‘œ์ค€๊ณผ๋Š” ๋‹ค๋ฅด๊ฒŒ ์‹ค์ œ๋กœ๋Š” ์†Œ์ผ“(Socket)์ด ์–ด๋–ป๊ฒŒ ์‹๋ณ„๋˜๋Š”๊ฐ€? 2023-05-09 00:00:18 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ [1๋ถ€] ํ”„๋กœํ† ์ฝœ ํ‘œ์ค€ ์ŠคํŽ™์—์„œ ์ •์˜ํ•œ Socket(์†Œ์ผ“), Port(ํฌํŠธ), TCP connection(์—ฐ๊ฒฐ) ๊ฐœ๋… 2023-04-26 23:00:17 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ ์›น์ด๋ผ ๋ถˆ๋ฆฌ๋Š” World Wide Web์˜ ๊ฐœ๋…๊ณผ ๋ฐœ๋ช… ๊ณผ์ •์„ ์†Œ๊ฐœํ•ฉ๋‹ˆ๋‹ค๐Ÿ‘ ์ด๊ฑธ ์•Œ๋ฉด ์›น๊ณผ ์ธํ„ฐ๋„ท, ์›น๊ณผ http๋Š” ๊ฐ๊ฐ์ด ์–ด๋–ค ๊ด€๊ณ„์ธ์ง€๋„ ์ดํ•ดํ•˜๊ฒŒ ๋ฉ๋‹ˆ๋‹ค~! 2023-04-12 23:45:00 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ [์ž…๋ฌธ์šฉ] ํ”„๋กœํ† ์ฝœ๊ณผ OSI 7 layer ์„ค๋ช…! ๋„คํŠธ์›Œํฌ์˜ ๊ธฐ๋Šฅ๋“ค์ด ์–ด๋–ป๊ฒŒ ๊ตฌ์กฐํ™” ๋ผ์„œ ๋™์ž‘ํ•˜๋Š”์ง€๋ฅผ ์„ค๋ช…ํ•ฉ๋‹ˆ๋‹ค! ๐Ÿ‘ 2023-03-27 22:00:08 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ [์ž…๋ฌธ์šฉ] ๋„คํŠธ์›Œํฌ์™€ ์ธํ„ฐ๋„ท ๊ฐœ๋… ์„ค๋ช…! ์ธํ„ฐ๋„ท ๋™์ž‘ ๋ฐฉ์‹๋„ ์„ค๋ช…! ISP๋„ ์„ค๋ช…! ์ „์ฒด ํฐ ๊ทธ๋ฆผ์„ ๊ทธ๋ฆฌ๊ธฐ์— ๋”ฑ ์ข‹์€ ์˜์ƒ์ด์ฃ  ๐Ÿ‘ 2023-03-18 23:45:02 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ (3๋ถ€) B tree๊ฐ€ ์™œ DB ์ธ๋ฑ์Šค(index)๋กœ ์‚ฌ์šฉ๋˜๋Š”์ง€๋ฅผ ์„ค๋ช…ํ•ฉ๋‹ˆ๋‹ค 2023-02-17 18:30:17 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ (2๋ถ€) B tree ๋ฐ์ดํ„ฐ ์‚ญ์ œ ๋™์ž‘ ๋ฐฉ์‹์„ ์„ค๋ช…ํ•ฉ๋‹ˆ๋‹ค (DB ์ธ๋ฑ์Šค๊ณผ ๊ด€๋ จ์žˆ๋Š” ์ž๋ฃŒ ๊ตฌ์กฐ) 2023-02-05 22:30:06 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ (1๋ถ€) B tree์˜ ๊ฐœ๋…๊ณผ ํŠน์ง•, ๋ฐ์ดํ„ฐ ์‚ฝ์ž…์ด ์–ด๋–ป๊ฒŒ ๋™์ž‘ํ•˜๋Š”์ง€๋ฅผ ์„ค๋ช…ํ•ฉ๋‹ˆ๋‹ค! (DB ์ธ๋ฑ์Šค๊ณผ ๊ด€๋ จ์žˆ๋Š” ์ž๋ฃŒ ๊ตฌ์กฐ) 2023-01-31 00:30:13 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ ๋ฉค๋ฒ„์‹ญ์„ ์‹œ์ž‘ํ•ฉ๋‹ˆ๋‹ค (์œ ๋ฃŒ ๊ฐ•์˜๋ฅผ ํ•˜์ง€ ์•Š์€ ์ด์œ ) 2023-01-17 20:30:02 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ NoSQL ์„ค๋ช…!! RDB์™€๋Š” ์–ด๋–ค ์ฐจ์ด๊ฐ€ ์žˆ๋Š”์ง€๋„ ์„ค๋ช…!! MongoDB, Redis ๋งค์šฐ ๊ฐ„๋‹จํ•œ ์˜ˆ์ œ ํฌํ•จ!! 2023-01-14 22:45:03 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ ๋ฐฑ์—”๋“œ ์ „๋ฌธ ์ฑ„๋„ ์‰ฌ์šด์ฝ”๋“œ 2022๋…„ ํšŒ๊ณ  2023-01-10 21:00:38 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ [3๋ถ€] 23๋…„ ์ƒˆํ•ด Q&A!! // ์‰ฌ์šด์ฝ”๋“œ ์ธํ”„๋Ÿฐ ๊ฐ•์˜ ๋‹ค ์ƒ€์–ด์š” / ์‰ฌ์šด์ฝ”๋“œ ๊ฐœ๋ฐœ์žฅ๋น„ ์†Œ๊ฐœ / ๋ฐฑ์—”๋“œ๊ฐ€ ์‹ ๊ฒฝ ์จ์•ผ ํ•˜๋Š” ๋ณด์•ˆ ๊ฐ•์˜ / ๊ฐœ๋ฐœ์ž๋Š” ์™œ 40๋Œ€ ์ดํ›„๋กœ ์น˜ํ‚จ์ง‘? 2023-01-04 21:30:13 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ [2๋ถ€] 23๋…„ ์ƒˆํ•ด Q&A!! // ๋„คํŠธ์›Œํฌ ๊ฐ•์˜ / ๊ณต๋ถ€ ์ž๋ฃŒ ์–ด๋–ป๊ฒŒ ์ฐพ๊ณ  ํ•™์Šตํ•˜๋Š”์ง€ / ์ทจ์ค€์ƒ ๋…ํ•™ ๊ธฐ๊ฐ„ ๊ธธ์–ด์ง€๋ฉด ๊ดœ์ฐฎ์„์ง€ / ๊ฐ•์˜ ์ž˜ ๋ณด๊ณ  ์žˆ์–ด์š” / ํŒŒ์ด์ฌ ์ค‘๊ธ‰ ์ฑ… ์ถ”์ฒœ 2023-01-03 22:00:11 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ [1๋ถ€] 23๋…„ ์ƒˆํ•ด Q&A!! // ๊ฐ•์˜ ๊ฒฝํ—˜ / ์ฑ—GPT / ์ตœ๊ณ ๋ฅผ ํ–ฅํ•œ ๋…ธ๋ ฅ / ๋‹นํ™ฉ์Šค๋Ÿฌ์› ๋˜ ๋ฐฑ์—”๋“œ ์‹ ์ž… ๊ฐœ๋ฐœ์ž ๊ธฐ์ˆ  ๋ฉด์ ‘ / ๋Œ€๊ทœ๋ชจ ํŠธ๋ž˜ํ”ฝ ๊ด€๋ จ ๊ฐ•์˜ 2023-01-02 22:30:08 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ ์–ด๋–ป๊ฒŒ ์ „๊ณต์„ ์ปด๊ณต์œผ๋กœ ๋ฐ”๊พธ๊ฒŒ ๋๋‚˜ 2022-12-27 23:15:02 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ DBCP (DB connection pool)์˜ ๊ฐœ๋…๋ถ€ํ„ฐ ์„ค์ • ๋ฐฉ๋ฒ•๊นŒ์ง€! hikariCP์™€ MySQL์„ ์˜ˆ์ œ๋กœ ์„ค๋ช…ํ•ฉ๋‹ˆ๋‹ค! ์ด๊ฑฐ ์ž˜ ๋ชจ๋ฅด๋ฉด ํž˜๋“ค.. 2022-12-25 23:30:12 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ [DB] แ„‘แ…กแ„แ…ตแ„‰แ…งแ„‚แ…ตแ†ผ? แ„‰แ…ฃแ„ƒแ…ตแ†ผ? แ„…แ…ฆแ„‘แ…ณแ†ฏแ„…แ…ตแ„แ…ฆแ„‹แ…ตแ„‰แ…งแ†ซ? (partitioning? sharding? replication?) 2022-12-12 22:30:12 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ IT ํšŒ์‚ฌ ๋ฉด์ ‘ ๋งˆ์ง€๋ง‰์— ๊ถ๊ธˆํ•œ ๊ฒƒ ์žˆ์œผ๋ฉด ๋ฌผ์–ด๋ณด๋ผ๋Š” ์งˆ๋ฌธ์„ ์ €๋Š” ์–ด๋–ป๊ฒŒ ํ™œ์šฉํ–ˆ๋ƒ๋ฉด์š” 2022-11-29 00:00:19 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ ์ฑ„๋„ ์šด์˜๊ณผ ๊ด€๋ จํ•ด์„œ ๋‘ ๊ฐ€์ง€ ์‚ฌ๊ณผ๋“œ๋ฆฌ๊ณ  ์‹ถ์€ ๋ถ€๋ถ„์ด ์žˆ์Šต๋‹ˆ๋‹ค 2022-11-18 23:00:02 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ DB ์ธ๋ฑ์Šค(DB index) !! ํ•ต์‹ฌ๋งŒ ๋ชจ์•„์„œ ์„ค๋ช…ํ•ฉ๋‹ˆ๋‹ค !! (31๋ถ„์ด ์•„๊น์ง€ ์•Š์„ ๊ฒ๋‹ˆ๋‹ค) 2022-11-14 19:00:10 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ TwoSum ๋ฌธ์ œ๋ฅผ ํ’€๋ฉด์„œ ๋ฐฐ์šฐ๋Š” ๋‚ด๊ฐ€ ์ง  ์ฝ”๋“œ์˜ ์„ฑ๋Šฅ์„ ๊ฐœ์„ ํ•˜๋Š” ๊ณผ์ •!! (feat. ์ฝ”๋”ฉ ํ…Œ์ŠคํŠธ) 2022-11-07 19:00:21 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ ๊ธฐ์ˆ  ๋ฉด์ ‘์—์„œ ์‹œ๊ฐ„ ๋ณต์žก๋„๋ฅผ ๋ฌผ์–ด๋ณด๋Š” ์ด์œ  & ๋งค์šฐ ๊ฐ„๋‹จํ•œ ์‹œ๊ฐ„๋ณต์žก๋„ ๋ฌธ์ œ ์†Œ๊ฐœ 2022-11-02 18:00:02 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ DB ํŠธ๋žœ์žญ์…˜ Lost update ํ˜„์ƒ #Shorts 2022-11-01 09:00:03 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ DB trigger ์‚ฌ์šฉ ์‹œ ์ฃผ์˜ ์‚ฌํ•ญ #Shorts 2022-10-31 20:00:29 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ 3-tier architecture #Shorts 2022-10-29 11:00:28 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ DB ์ •๊ทœํ™” #Shorts 2022-10-27 15:00:09 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ (2๋ถ€) DB ์ •๊ทœํ™”(normalization) 2๋ถ€์ž…๋‹ˆ๋‹ค!! 3NF, BCNF์™€ 2NF ์ฐธ๊ณ  ์‚ฌํ•ญ, ์—ญ์ •๊ทœํ™”(denormalization)๊นŒ์ง€ ์„ค๋ช…ํ•ฉ๋‹ˆ๋‹ค!! 2022-10-25 20:00:03 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ (1๋ถ€) DB ์ •๊ทœํ™”(normalization)๋Š” DB๋ฅผ ์„ค๊ณ„ํ•˜๋Š” ๊ณต์‹์ ์ธ ๋ฐฉ๋ฒ•์ด์ฃ ~ 1๋ถ€์—์„œ๋Š” ์ •๊ทœํ™” ๊ฐœ๋…๊ณผ ์ •๊ทœํ™” ๊ณผ์ •์˜ ์•ž ๋ถ€๋ถ„์ธ 1NF, 2NF๋ฅผ ์„ค๋ช…ํ•ฉ๋‹ˆ๋‹ค :) 2022-10-24 20:00:12 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ DB์—์„œ functional dependency(FD : ํ•จ์ˆ˜ ์ข…์†)์„ ์„ค๋ช…ํ•ฉ๋‹ˆ๋‹ค! ๊ณ ๊ณ ์”ฝ!! 2022-10-21 00:45:01 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ DB ํ…Œ์ด๋ธ” ์„ค๊ณ„ ์ž˜๋ชปํ•˜๋ฉด ์–ด๋–ค ๋ฌธ์ œ๊ฐ€ ์ƒ๊ธธ ์ˆ˜ ์žˆ์„๊นŒ์š”? 2022-10-12 21:00:12 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ ์ด๊ฑฐ ์•ˆ ํ•ด๋ณด๊ณ  IT ํšŒ์‚ฌ ๋ฉด์ ‘ ๊ฐ€๋ฉด ์†ํ•ด ๋ณผ ์ˆ˜๋„ ์žˆ์Šต๋‹ˆ๋‹ค 2022-10-05 10:30:11 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ (2๋ถ€) DB MVCC ์ด์–ด์„œ ์„ค๋ช…ํ•ฉ๋‹ˆ๋‹ค ! MySQL & postgreSQL ์˜ˆ์ œ์™€ ํ•จ๊ป˜ ํ™•์ธํ•ด ๋ณด์„ธ์š” ! (feat. select ... for update) 2022-10-01 13:30:00 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ (1๋ถ€) DB MVCC ๊ฐœ๋… ์„ค๋ช…ํ•ฉ๋‹ˆ๋‹ค ! MVCC๊ฐ€ ๊ฐ๊ฐ์˜ isolation level์—์„œ ์–ด๋–ป๊ฒŒ ๋™์ž‘ํ•˜๋Š”์ง€๋„ MySQL & postgreSQL ์˜ˆ์ œ์™€ ํ•จ๊ป˜ ์„ค๋ช…ํ•ฉ๋‹ˆ๋‹ค 2022-09-30 17:30:15 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ "์Šค๋ ˆ๋“œ๋ฅผ ๋งŽ์ด ์“ธ์ˆ˜๋ก ํ•ญ์ƒ ์„ฑ๋Šฅ์ด ์ข‹์•„์งˆ๊นŒ์š”?" ๊ธฐ์ˆ  ๋ฉด์ ‘์—์„œ ๋ฌผ์–ด๋ณธ๋‹ค๋ฉด? 2022-09-25 23:00:24 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ ๊ธฐ์ˆ  ๋ฉด์ ‘์—์„œ list์™€ set์˜ ์ฐจ์ด๋ฅผ ๋ฌผ์–ด๋ณด๋Š” ์ด์œ  2022-09-19 00:00:05 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ LOCK์„ ํ™œ์šฉํ•œ concurrency control ๊ธฐ๋ฒ•์„ ๋ฐฐ์›Œ๋ด…๋‹ˆ๋‹ค. 2PL(two-phase locking)๋„ ๊ฐ™์ด ์„ค๋ช…๋“œ๋ ค์š”~ 2022-09-16 14:30:00 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ IT ๊ธฐ์ˆ  ๋ฉด์ ‘์—์„œ ๋ชจ๋ฅด๋Š” ์งˆ๋ฌธ์„ ๋งŒ๋‚ฌ์„ ๋•Œ ์–ด๋–ป๊ฒŒ ๋Œ€๋‹ตํ•˜๋Š” ๊ฒƒ์ด ์ข‹์„๊นŒ์š”? 2022-09-12 16:30:05 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ transaction isolation level ์„ค๋ช…ํ•ฉ๋‹ˆ๋‹ค! isolation์ด ์•ˆ๋  ๋•Œ ๋‚˜ํƒ€๋‚  ์ˆ˜ ์žˆ๋Š” ์—ฌ๋Ÿฌ ํ˜„์ƒ๋“ค๊ณผ snapshot isolation๋„ ๊ฐ™์ด ์„ค๋ช…ํ•ฉ๋‹ˆ๋‹ค!! 2022-09-05 22:00:16 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ (2๋ถ€) concurrency control ๊ธฐ์ดˆ : recoverability. ํŠธ๋žœ์žญ์…˜๋“ค์ด ๋™์‹œ์— ์‹คํ–‰๋  ๋•Œ rollback์ด ๋ฐœ์ƒํ•˜๋ฉด ์–ด๋–ค ์ผ์ด ๋ฒŒ์–ด์งˆ๊นŒ์š”? 2022-08-26 00:30:03 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ (1๋ถ€) concurrency control ๊ธฐ์ดˆ : schedule๊ณผ serializability. ํŠธ๋žœ์žญ์…˜๋“ค์ด ๋™์‹œ์— ์‹คํ–‰๋  ๋•Œ isolation์„ ๋ณด์žฅํ•˜๋Š” ๊ธฐ์ดˆ ์ด๋ก  2022-08-19 00:30:03 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ํŠธ๋žœ์žญ์…˜(transaction)์„ ์•„์‹ญ๋‹ˆ๊นŒ? ๊ทธ๋ฆฌ๊ณ  ํŠธ๋žœ์žญ์…˜์˜ ๋งค์šฐ ์ค‘์š”ํ•œ ์†์„ฑ๋“ค์ธ ACID๋ฅผ ์•„์‹ญ๋‹ˆ๊นŒ? ๋ชจ๋ฅด์‹ ๋‹ค๋ฉด ๋“ค๋ €๋‹ค ๊ฐ€์‹œ์ง€์š” 2022-08-13 02:00:39 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ SQL trigger!! ํŠธ๋ฆฌ๊ฑฐ์˜ ์˜๋ฏธ์™€ ๊ฐ„๋‹จํ•œ ์˜ˆ์ œ๋“ค, ๊ทธ๋ฆฌ๊ณ  ์‚ฌ์šฉํ•  ๋•Œ ์ฃผ์˜ ์‚ฌํ•ญ์„ ์‚ดํŽด๋ด…์‹œ๋‹ค!! "๋ฐฉ์•„์‡  .. ํ•จ๋ถ€๋กœ ๋‹น๊ธฐ๋Š” ๊ฑฐ ์•„๋‹™๋„ค๋‹ค.." 2022-07-23 12:00:19 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ (2๋ถ€) ์žฌ๋ฐŒ์„ ๊ฒ๋‹ˆ๋‹ค! stored procedure๋ฅผ ๋ฐฑ์—”๋“œ ์‹ค๋ฌด์—์„œ ์“ฐ๊ธฐ์— ์กฐ์‹ฌ์Šค๋Ÿฌ์šด ์ด์œ !! ๋ฐฑ์—”๋“œ ๊ฒฝํ—˜์น˜๋ฅผ ์••์ถ•ํ•ด์„œ ์˜์ƒ์— ๋…น์˜€์Šต๋‹ˆ๋‹ค!! ๋งŒ์กฑํ•˜์‹ค๊ฑฐ์—์š”!! 2022-07-19 11:15:01 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ (1๋ถ€) SQL์—์„œ stored procedure๋ฅผ ์•„์‹œ๋‚˜์š”? ์˜ˆ์ œ๋ฅผ ํ†ตํ•ด ํ”„๋กœ์‹œ์ €์˜ ๋™์ž‘ ๋ฐฉ์‹๊ณผ ํŠน์ง•, stored function๊ณผ์˜ ์ฐจ์ด๋ฅผ ์‚ดํŽด๋ด…๋‹ˆ๋‹ค 2022-07-14 13:15:02 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ SQL์—์„œ stored function์„ ์•„์‹œ๋‚˜์š”? ์ด ์นœ๊ตฌ์˜ ํŠน์ง•, ์–ด๋–ป๊ฒŒ ์‚ฌ์šฉํ•˜๋Š”์ง€, ์–ธ์ œ ์‚ฌ์šฉํ•˜๋ฉด ์ข‹์„์ง€๋ฅผ ์„ค๋ช…ํ•ฉ๋‹ˆ๋‹ค~~ (stored procedure์™€๋Š” ๋‹ค๋ฅธ ๊ฑฐ์˜ˆ์š”) 2022-07-09 01:15:00 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ (5๋ถ€) SQL๋กœ ๋ฐ์ดํ„ฐ ์กฐํšŒํ•˜๊ธฐ! group by, aggregate function, order by๋ฅผ ์„ค๋ช…ํ•ฉ๋‹ˆ๋‹ค~! ๊ทธ๋ฃน๋ณ„๋กœ ์›ํ•˜๋Š” ํ†ต๊ณ„๋ฅผ ์ˆœ์„œ๋Œ€๋กœ ์กฐํšŒํ•ด ๋ณด์„ธ์š” :) 2022-07-05 19:00:24 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ (4๋ถ€) SQL๋กœ ๋ฐ์ดํ„ฐ ์กฐํšŒํ•˜๊ธฐ! join์˜ ์˜๋ฏธ์™€ ์—ฌ๋Ÿฌ ์ข…๋ฅ˜์˜ join๋“ค์„ ์‰ฝ๊ฒŒ ์ •๋ฆฌํ•ด์„œ ์„ค๋ช…ํ•ฉ๋‹ˆ๋‹ค! join์„ ์‚ฌ์šฉํ•œ ์˜ˆ์ œ๋„ ์žˆ์œผ๋‹ˆ๊นŒ์š”, ์‰ฌ์šด ์„ค๋ช… ๋“ค์–ด๋ณด์„ธ์šฉ~ :) 2022-06-30 22:30:03 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ (3๋ถ€) SQL๋กœ ๋ฐ์ดํ„ฐ ์กฐํšŒํ•˜๊ธฐ! NULL์˜ ์˜๋ฏธ์™€ three-valued logic์ด ๋ฌด์—‡์ธ์ง€ ๋ฐฐ์›Œ๋ด…๋‹ˆ๋‹ค! SQL์—์„œ NULL์„ ์ž˜ ๋ชจ๋ฅด๋ฉด ๋ฉ˜๋ถ• ์˜ฌ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค!! ๊ผญ ๋ณด์„ธ์š” 2022-06-25 10:00:12 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ (2๋ถ€) SQL๋กœ ๋ฐ์ดํ„ฐ ์กฐํšŒํ•˜๊ธฐ! subquery๋ฅผ ๋‹ค์–‘ํ•œ ์˜ˆ์ œ์™€ ํ•จ๊ป˜ ๋ฐฐ์›Œ๋ด…์‹œ๋‹ค! IN, EXISTS, ANY, ALL ์—ฐ์‚ฐ์ž๋„ ๊ฐ™์ด ์•Œ๋ ค๋“œ๋ ค์š”~~ ๋†€๋Ÿฌ์˜ค์„ธ์š”~! 2022-06-23 22:15:03 2024-05-16 23:31:06 x
์‰ฌ์šด์ฝ”๋“œ (1๋ถ€) SQL๋กœ ๋ฐ์ดํ„ฐ ์กฐํšŒํ•˜๊ธฐ! select๋ฅผ ํ™œ์šฉํ•ด์„œ ๋ฐ์ดํ„ฐ๋ฅผ ์ฝ์–ด์˜ค๋Š” ๊ธฐ๋ณธ์ ์ธ ๋ฌธ๋ฒ•๊ณผ ๊ด€๋ จ ํ‚ค์›Œ๋“œ๋“ค์„ ๋ฐฐ์›Œ๋ด…์‹œ๋‹ค~! ์‰ฌ์šด ์˜ˆ์ œ, ์‰ฌ์šด ์„ค๋ช…! ๋†“์น˜์ง€ ๋งˆ์„ธ์š”~ ;) 2022-06-18 13:00:12 2024-05-16 23:31:06 x