๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

728x90

web

6/3 ํ† _3 Tier, ํด๋ผ์šฐ๋“œ ์ƒํƒœ๊ณ„(CSP/MSP/ISV) 1. 3 Tier ์›น ์„œ๋ฒ„ ํ•œ๋Œ€์— ๋ชจ๋“  ๊ธฐ๋Šฅ์„ ๊ตฌ์ถ•ํ•˜๋Š” ๊ฒƒ์ด ์•„๋‹ˆ๋ผ, ๋ฐ์ดํ„ฐ๋ฅผ ์ €์žฅํ•˜๊ณ  ์ฝ๋Š” ๋ฐ์ดํ„ฐ(DBMS) ๊ณ„์ธต, ๋ฐ์ดํ„ฐ๋ฅผ ์ฒ˜๋ฆฌํ•˜๋Š” ์• ํ”Œ๋ฆฌ์ผ€์ด์…˜(Back-end) ๊ณ„์ธต, ๊ทธ๋ฆฌ๊ณ  ๋ฐ์ดํ„ฐ๋ฅผ ํ‘œํ˜„ํ•ด ์ฃผ๋Š” ํด๋ผ์ด์–ธํŠธ(ํ”„๋ ˆ์  ํ…Œ์ด์…˜, Front-end) ๊ณ„์ธต์œผ๋กœ ๋‚˜๋ˆ„์–ด ๊ธฐ๋Šฅ๋ณ„๋กœ ๋…ผ๋ฆฌ์ /๋ฌผ๋ฆฌ์ ์ธ ์žฅ์น˜์—์„œ ์šด์˜ํ•˜๋Š” ๋ฐฉ์‹์ด๋‹ค. WEB / WAS / DB!! ํด๋ผ์šฐ๋“œ์šฉ์œผ๋กœ ๊ฐœ์ธ ํ”„๋กœ์ ํŠธ๋ฅผ ๊ณ ๋„ํ™”ํ•ด์•ผ ํ•ด์„œ ์„ค๊ณ„ ๋ฐฉ๋ฒ•์„ ์ฐพ๋Š” ์ค‘์— ๋ฐœ๊ฒฌํ•œ ์ฑ…์ด ์žˆ๋‹คใ…Žใ…‹ใ…Žใ…‹ "๋ฐฐ์›Œ์„œ ๋ฐ”๋กœ ์“ฐ๋Š” 14๊ฐ€์ง€ AWS ๊ตฌ์ถ• ํŒจํ„ด"! ๋ฐ”๋กœ ๋นŒ๋ฆฌ๋Ÿฌ ๊ฐ‘๋‹ˆ๋‹ค~ 2. ํด๋ผ์šฐ๋“œ ์ƒํƒœ๊ณ„ 1) CSP(Cloud Service Provider): ํด๋ผ์šฐ๋“œ ์„œ๋น„์Šค๋ฅผ ์œ„ํ•œ ๋ฌผ๋ฆฌ ์ธํ”„๋ผ ์ œ๊ณต. Amazon AWS/MS Azure/Google GCP/KT/Naver/NHN.. ๋”๋ณด๊ธฐ
2/3 ๋ชฉ ๊ธด ์—ฐํœด๊ฐ€ ๋๋‚ฌ๋‹ค! ๐Ÿคฅ ์ •์ (static) Web : Web Server ์ชฝ์— ์ด๋ฏธ ์กด์žฌํ•˜๋Š” resource(HTML)๋ฅผ ์š”์ฒญํ•˜๋Š” ์ž‘์—… ๋™์ (dynamic) Web : Web Server ์ชฝ์— ์กด์žฌํ•˜๋Š” program์„ ํ˜ธ์ถœ, ๊ฒฐ๊ณผ resource๋ฅผ ์ƒ์„ฑํ•ด์„œ response HTML(HyperText Markup Language), CSS(Cascading Style Sheet), JavaScript HTML์ด ๋ฒ„์ „ ์—…(5) ๋˜๋ฉด์„œ HTML Element, CSS 3, JavaScript๋กœ ๊ตฌ์„ฑ๋˜์–ด ์žˆ์Œ Web Server์—๊ฒŒ ํ”„๋กœ์ ํŠธ์˜ ์กด์žฌ๋ฅผ ์•Œ๋ ค์คŒ(configure) → ์„œ๋ฒ„๊ฐ€ ํ”„๋กœ์ ํŠธ๋ฅผ ์ธ์‹ํ•œ ์ƒํƒœ์—์„œ ๊ธฐ๋™ → Web Client(Browser)๋ฅผ ์‹คํ–‰ → URL(protocol://IP:Port/ํŒŒ.. ๋”๋ณด๊ธฐ
1/28 ๊ธˆ ์„ค ์—ฐํœด๋ฅผ ์•ž๋‘” ๊ธˆ์š”์ผ!! JOIN : ๋‘ ๊ฐœ ์ด์ƒ์˜ ํ…Œ์ด๋ธ”์„ ์„œ๋กœ ๋ฌถ์–ด์„œ ํ•˜๋‚˜์˜ ๊ฒฐ๊ณผ ์ง‘ํ•ฉ์œผ๋กœ ๋งŒ๋“ค์–ด ๋‚ด๋Š” ๊ฒƒ INNER JOIN : ๊ฐ€์žฅ ๋งŽ์ด ์‚ฌ์šฉ๋˜๋Š” ์กฐ์ธ. ์–‘์ชฝ ํ…Œ์ด๋ธ”์— ๋ชจ๋‘ ๋‚ด์šฉ์ด ์žˆ๋Š” ๊ฒƒ๋งŒ ์กฐ์ธ๋จ USE sqldb; SELECT * FROM UserTBL; SELECT * FROM buyTBL; SELECT * -- INNER JOIN FROM buyTBL INNER JOIN userTBL ON buyTBL.userID = userTBL.userID WHERE buyTBL.userID = 'JYP'; SELECT * FROM buyTBL INNER JOIN userTBL ON buyTBL.userID = userTBL.userID WHERE productName = '์šด๋™ํ™”'; SELECT B.. ๋”๋ณด๊ธฐ

728x90