profile
Business & Software ๐Ÿ’—๐Ÿณ๏ธโ€๐ŸŒˆ๐ŸŒŽ
ํƒœ๊ทธ ๋ชฉ๋ก
์ „์ฒด๋ณด๊ธฐ (91)ํด๋ผ์šฐ๋“œ(44)GCP(32)aws(18)mysql(9)Database(8)kubernetes(7)๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค(7)network(6)์•„ํ‚คํ…์ณ(5)mysql ์ •๋ฆฌ(5)GKE(5)์„œ๋ฒ„๋ฆฌ์Šค(3)error(3)dataflow(3)data type(2)PL(2)lambda(2)cloud(2)์ฟ ๋ฒ„๋„คํ‹ฐ์Šค(2)re:Invent(2)์Šคํ„ฐ๋””์žผ(2)yaml(2)mysql ๊ณต๋ถ€(2)์›น์•ฑ(2)๋ž€(2)BigQuery(2)vpc(2)์ž๊ฒฉ์ฆ(2)Andy Jassy(2)nosql(2)dynamodb(2)Amplify(2)security(2)Restful(1)server(1)dataprep(1)์ฝ”์„ธ๋ผ(1)Amazon Connect(1)deployment(1)IAM(1)REST(1)L4 load balancer(1)Amazon Pinpoint(1)Structured data types(1)snapshot(1)์•ฑํ˜„๋Œ€ํ™”(1)IP address(1)Cassandra(1)Switched networks(1)sharding(1)Packet switching(1)nat(1)Index(1)Packet Mirroring(1)Path MTU Discovery(1)๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ •๋ฆฌ(1)Deployment manager(1)composer(1)status(1)chomsky hierarchy(1)Scoping rule(1)Google Cloud(1)Subnetting(1)virtual circuit(1)Mobile IP(1)helm(1)Calling procedure(1)SLI(1)Fragmentation(1)Coursera(1)๋„คํŠธ์›Œํฌ(1)scheduler(1)InvalidImageName(1)records(1)Audit log(1)durability(1)ํด๋ผ์šฐ๋“œ์ž๊ฒฉ์ฆ(1)์›จ๋น„๋‚˜(1)php(1)ICMP(1)IP Headers(1)MTU(1)Forwarding(1)PCA(1)CI/CD Pipeline(1)CI/CD(1)REST API(1)floating point(1)awsํƒ๊ตฌ์ƒํ™œ(1)Network load balancing(1)HTTP(S) load balancing(1)ARP(1)Parameter passing(1)Custom Role(1)Builders(1)Type Checking(1)programming language(1)cd(1)bastion host(1)apache(1)Longest prefix matching(1)SSL/TCP load balancing(1)programming(1)routing table(1)dataproc(1)API Gateway(1)Microsoft(1)Subprogram control(1)Home address(1)CDN(1)Next-hop(1)pde(1)Sequence control(1)bigtable(1)SLO(1)Daemonset(1)Managed Instance Group(1)SLA(1)Statefulset(1)Specification(1)RDBMS(1)care-of address(1)KPI(1)Datagram(1)NAT Gateway(1)selector(1)airflow(1)DHCP(1)์ƒค๋”ฉ(1)L7 load balancer(1)Stateful(1)etl(1)daily(1)Shared VPC(1)Intradomain Routing(1)Stateless(1)routing(1)Sandbox(1)ci(1)Fixed point(1)preemtible vm(1)Supernetting(1)Vectors(1)ACE ์ž๊ฒฉ์ฆ(1)High Availability(1)windowing(1)availability(1)Congito(1)API(1)PKI(1)Internal load balancing(1)Defender(1)Heap memory management(1)Cognito(1)VM instance(1)VPC Peering(1)jenkins(1)networking(1)
post-thumbnail

Microsoft Defender for Endpoint ๋ฐฐํฌ ๊ฐ€์ด๋“œ

์ด ๊ฐ€์ด๋“œ๋Š” ์ดํ•ด ๊ด€๊ณ„์ž ๊ฐ„์— ์ž‘์—…ํ•˜์—ฌ ํ™˜๊ฒฝ์„ ์ค€๋น„ํ•œ ๋‹ค์Œ, ํ‰๊ฐ€ -> ์˜๋ฏธ ์žˆ๋Š” ํŒŒ์ผ๋Ÿฟ -> ์ „์ฒด ๋ฐฐํฌ ์ˆœ์„œ์˜ ์ฒด๊ณ„์ ์ธ ๋ฐฉ์‹์œผ๋กœ ๋””๋ฐ”์ด์Šค๋ฅผ ์˜จ๋ณด๋”ฉํ•˜๋Š” ๋ฐ ๋„์›€์ด ๋ฉ๋‹ˆ๋‹ค.1) Prepare: ๊ด€๋ จ์ž ์Šน์ธ, ํ™˜๊ฒฝ ๊ณ ๋ ค ์‚ฌํ•ญ, ์•ก์„ธ์Šค ๊ถŒํ•œ ๋ฐ ๊ธฐ๋Šฅ ์ฑ„ํƒ ์ˆœ์„œ์™€ ๊ฐ™์€ Def

2023๋…„ 2์›” 8์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
ยท

Microsoft 365 Defender ์‚ฌ์šฉ ์‹œ์ž‘ํ•˜๋Š” ๋ฒ•

Microsoft 365 Defender๋Š” ๊ธฐ๋ณธ์ ์œผ๋กœ ์—”๋“œํฌ์ธํŠธ, ID, ์ „์ž ๋ฉ”์ผ ๋ฐ ์‘์šฉํ”„๋กœ๊ทธ๋žจ ์ „๋ฐ˜์—์„œ ์œ„๋ฐ˜ ์ „ ๋ฐ ์œ„๋ฐ˜ ํ›„ ํƒ์ง€, ๋ฐฉ์ง€, ์กฐ์‚ฌ ๋ฐ ์‘๋‹ต์„ ์กฐ์ •ํ•˜์—ฌ ์ •๊ตํ•œ ๊ณต๊ฒฉ์— ๋Œ€ํ•œ ํ†ตํ•ฉ ๋ณดํ˜ธ๋ฅผ ์ œ๊ณตํ•˜๋Š” ํ†ตํ•ฉ๋œ ์—”ํ„ฐํ”„๋ผ์ด์ฆˆ ๋ณด์•ˆ ์ œํ’ˆ๊ตฐ์ž…๋‹ˆ๋‹ค.Microsoft 3

2023๋…„ 2์›” 7์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
ยท
post-thumbnail

[AWS] AWS Well-Architected framework๋ž€?

๋จผ์ €! ํ•ด๋‹น ๋ธ”๋กœ๊ทธ ํฌ์ŠคํŒ…์€ https://www.slideshare.net/awskorea/aws-cloud-track-2-advanced ์˜ ์ž๋ฃŒ๋ฅผ ๊ณต๋ถ€ํ•˜๋ฉฐ ์ •๋ฆฌํ•œ ๊ฒƒ์ž…๋‹ˆ๋‹ค๐ŸŒธWell-Architected ํ”„๋ ˆ์ž„ ์›Œํฌ๋Š” ํฌ๊ฒŒ 4๊ฐ€์ง€ ์š”์†Œ๋กœ ์ด๋ฃจ์–ด์ ธ ์žˆ์Šต๋‹ˆ๋‹ค

2021๋…„ 2์›” 15์ผ
ยท
1๊ฐœ์˜ ๋Œ“๊ธ€
ยท

[daily] a series of the SAME days,,

์‹ฑ์ˆญ์ƒ์ˆญํ•œ ๋งˆ์Œ์— ๋ช‡์ผ์งธ ๊ณต๋ถ€๋ฅผ ์•ˆํ•ด์„œ ์Šคํ„ฐ๋”” ๋‘๊ฐœ์— ๋“ค์–ด๊ฐ“๋‹ค๐Ÿ™ƒํ•˜๋‚˜๋Š” ์ „๊ณต๊ณต๋ถ€ ์Šคํ„ฐ๋””์ด๊ณ  ํ•˜๋‚˜๋Š” aws ์Šคํ„ฐ๋””์ด๋‹ค !!!!!!!!ํ‰์†Œ์—๋Š” ๊ณต๋ถ€ํ• ๋•Œ ํ˜ผ์žํ•˜๋Š”๊ฒŒ ํšจ์œจ์ด ์ข‹์•„์„œ ์Šคํ„ฐ๋””๋Š” ์ž˜์•ˆํ•ด๋ดค๋Š”๋ฐ (๋„ˆ๋ฌด ๊ณต๋ถ€๋ฅผ ์•ˆํ•˜๊ธธ๋ž˜ ๋“ค์–ด๊ฐ”๋‹ค,,,)์‚ฌ๋žŒ ๋งŒ๋‚˜๋Š” ๊ฒƒ์„ ์ข‹์•„ํ•˜๋‹ค๋ณด๋‹ˆ ์Šคํ„ฐ๋””

2021๋…„ 2์›” 11์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
ยท
post-thumbnail

[AWS] This is My Architecture - Nielsen / Alert Logic (feat. ์—„์ฒญ๋‚œ ์–‘์˜ ๋ฐ์ดํ„ฐ)

์˜ค๋Š˜์€ 'Huge amount of Data'๋ฅผ ํ‚ค์›Œ๋“œ๋กœ 'Nielsen'์˜ ์‚ฌ๋ก€์™€ 'Alert Logic'์˜ ์‚ฌ๋ก€๋ฅผ ์‚ดํŽด๋ณด๋„๋ก ํ•˜๊ฒ ์Šต๋‹ˆ๋‹ค! โœจ์†Œ๊ฐœNielsen์€ ๋ฐ์ดํ„ฐ ๊ด€๋ฆฌ ํ”Œ๋žซํผ์œผ๋กœ ์บ ํŽ˜์ธ์— ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๋Š” ๋งˆ์ผ€ํŒ… ์„ธ๋ถ„ํ™” ๋ฐ์ดํ„ฐ๋ฅผ ์ค€๋น„ํ•ฉ๋‹ˆ๋‹ค. ๊ธฐ๋ณธ์ ์œผ๋กœ ์‹œ์Šคํ…œ์˜ ๋‹ค

2021๋…„ 2์›” 2์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
ยท
post-thumbnail

[AWS] This is My Architecture - ์Šคํ‘ผ๋ผ๋””์˜ค / De Agostini (feat. ์ŠคํŠธ๋ฆฌ๋ฐ ์„œ๋น„์Šค)

์˜ค๋Š˜์€ 'Streaming Service' ๋ผ๋Š” ํ‚ค์›Œ๋“œ๋ฅผ ๊ฐ€์ง€๊ณ  ๊ตญ๋‚ด์˜ ์Šคํ‘ผ๋ผ๋””์˜ค์˜ ์‚ฌ๋ก€์™€ ์ดํƒˆ๋ฆฌ์•„์˜ De Agostini์˜ ์‚ฌ๋ก€๋ฅผ ์‚ดํŽด๋ณด๊ฒ ์Šต๋‹ˆ๋‹ค! โœจ์†Œ๊ฐœ์Šคํ‘ผ๋ผ๋””์˜ค๋Š” ์‹ค์‹œ๊ฐ„ ์˜ค๋””์˜ค ํ”Œ๋žซํผ์ž…๋‹ˆ๋‹ค. ์Šค๋งˆํŠธํฐ๋งŒ ์žˆ์œผ๋ฉด ๋ˆ„๊ตฌ๋‚˜ ์–ธ์ œ ์–ด๋””์„œ๋“  DJ๋‚˜ ์ฒญ์ทจ์ž๊ฐ€ ๋  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

2021๋…„ 2์›” 2์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
ยท
post-thumbnail

[AWS] This is My Architecture - NIKE / Homesite (feat. Amazon Netpune)

์˜ค๋Š˜์€ 'Amazon Neptune'์„ ํ‚ค์›Œ๋“œ๋กœ '๋‚˜์ดํ‚ค'์˜ ์‚ฌ๋ก€์™€ 'Homesite'์˜ ์‚ฌ๋ก€๋ฅผ ์‚ดํŽด๋ณด๊ฒ ์Šต๋‹ˆ๋‹คโœจ์†Œ๊ฐœNike ecosystem์—์„œ social graph๋ฅผ ๋‹ด๋‹นํ•˜๊ณ  ์žˆ์Šต๋‹ˆ๋‹ค. NRC, NTC์™€ ๊ฐ™์€ ํ”„๋ก ํŠธ์—”๋“œ๋ถ€ํ„ฐ Data Lake์—์„œ ์ผ์–ด๋‚˜๋Š” ๋ถ„์„๊นŒ์ง€ ๋„“

2021๋…„ 2์›” 1์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
ยท
post-thumbnail

[AWS] This is My Architecture - ์‚ผ์„ฑ์ „์ž / Voodoo (feat. ์ถ”์ฒœ์„œ๋น„์Šค)

์ตœ๊ทผ์— ํ•œ ์‹œ๋‹ˆ์–ด ๋ถ„์ด ์ถ”์ฒœํ•ด์ฃผ์…”์„œ ์˜ค๋Š˜๋ถ€ํ„ฐ ์ƒˆ๋กญ๊ฒŒ ๋ณด๊ธฐ ์‹œ์ž‘ํ•œ ์œ ํŠœ๋ธŒ ์‹œ๋ฆฌ์ฆˆ์ž…๋‹ˆ๋‹ค. aws ์ฑ„๋„์—์„œ ํ•˜๋Š” This is My Architecture๋ผ๋Š” ์‹œ๋ฆฌ์ฆˆ์ธ๋ฐ aws์˜ ํŒŒํŠธ๋„ˆ๋‚˜ ๊ณ ๊ฐ๋“ค์˜ ํด๋ผ์šฐ๋“œ ์•„ํ‚คํ…์ณ๋ฅผ ์†Œ๊ฐœํ•˜๋Š” ์œ ์ตํ•œ ์ปจํ…์ธ ์ž…๋‹ˆ๋‹ค. 500๊ฐœ ์ •๋„์˜ ์˜์ƒ์ด ์žˆ๋Š”

2021๋…„ 2์›” 1์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
ยท
post-thumbnail

[GCP] GCP ํ›„๋“œ์ง‘์—…๊ณผ ํ›„๋ฆฌ์Šค ์ˆ˜๋ น ํ›„๊ธฐ

GCP ํ›„๋“œ์ง‘์—…์ด ๋„์ฐฉํ–ˆ์Šต๋‹ˆ๋‹ค!๐Ÿ˜Š fedex๋ฅผ ํ†ตํ•ด์„œ ์˜ค๋Š”๋ฐ ๋ฐฐ์†ก์€ ์•ฝ ํ•œ๋‹ฌ์ด ๊ฑธ๋ ธ๊ณ , ์‚ฌ์ด์ฆˆ๋Š” ๋‚จ์ž S ์‚ฌ์ด์ฆˆ๋ฅผ ์ฃผ๋ฌธํ–ˆ์Šต๋‹ˆ๋‹ค! ์—ฌ์ž 90(S) ์ •๋„ ์‚ฌ์ด์ฆˆ์ธ ๊ฒƒ ๊ฐ™์•„์„œ ๋‚จ์„ฑ๋ถ„๋“ค์€ ์ตœ์†Œ XL์ด์ƒ์€ ์ฃผ๋ฌธํ•ด์•ผํ•  ๋“ฏ ํ•ฉ๋‹ˆ๋‹ค :) ๋งˆ์Šคํฌ์™€ ์Šคํ‹ฐ์ปค๋„ ํ•จ๊ป˜ ์™”์Šต๋‹ˆ๋‹คํ›„๋ฆฌ์Šค๋Š” ์•„์ง

2021๋…„ 1์›” 29์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
ยท
post-thumbnail

[daily] ๋ธ”๋กœ๊ทธ ํ•˜๋ฉด์„œ ์ฆ๊ฑฐ์šด ์ผ

๋ธ”๋กœ๊ทธ๋ฅผ ์“ด์ง€๋„ ๋ฒŒ์จ 7๊ฐœ์›”์ด ๋˜์—ˆ๋‹ค๐Ÿ˜Š ๊ณต๋ถ€ํ•˜๋ฉด์„œ ๋‚ด๊ฐ€ ์ •๋ฆฌํ•ด์„œ ๋ณด๋Š” ์ฐจ์›์—์„œ ์“ฐ๊ธฐ ์‹œ์ž‘ํ–ˆ๋Š”๋ฐ ์–ผ๋งˆ์ „์— ๊ฒ€์ƒ‰์„ ํ•˜๋‹ค๊ฐ€ ๋‚ด ๋ธ”๋กœ๊ทธ๊ฐ€ ์ฒซ๋ฒˆ์งธ ํŽ˜์ด์ง€์— ๋‚˜์˜ค๋Š” ๊ฒƒ์„ ๋ณด๊ณ  ๋„ˆ๋ฌด ๊ธฐ๋ถ„์ด ์ข‹์•˜๋‹ค ๋ธ”๋กœ๊ทธ๋ฅผ ๋ง‰ ์‹œ์ž‘ํ–ˆ์„ ๋•Œ์—๋Š” ๊ฒ€์ƒ‰ํ•˜๋ฉด ๊ฑฐ์˜ ์•ˆ๋‚˜์˜ค๊ฑฐ๋‚˜ 5,6ํŽ˜์ด์ง€์— ๋‚˜์™”์—ˆ๋Š”๋ฐ ํ•œ๋™

2021๋…„ 1์›” 29์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
ยท
post-thumbnail

[AWS] AWS Builders online - Networking ์ •๋ฆฌํ•˜๊ธฐ 2

์•ž์„œ ํฌ์ŠคํŒ…์—์„œ VPC์— ๋Œ€ํ•ด ์•„์ฃผ ์ƒ์„ธํžˆ ์•Œ์•„๋ดค๋Š”๋ฐ์š” ์˜ค๋Š˜์€ ์ด์–ด์„œ Direct Connect ๋ถ€ํ„ฐ ์•Œ์•„๋ณด๋„๋ก ํ•˜๊ฒ ์Šต๋‹ˆ๋‹ค!Direct Connect๋ฅผ ์ด์šฉํ•˜๊ฒŒ ๋˜๋ฉด ์˜จํ”„๋ ˜๋ฐ์ดํ„ฐ์„ผํ„ฐ์™€ aws ์ž์›๋“ค์ด ์—ฐ๊ฒฐ๋˜์–ด์ง‘๋‹ˆ๋‹ค. Direct Connect๋Š” 3๊ฐ€์ง€์˜ virtual

2021๋…„ 1์›” 25์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
ยท
post-thumbnail

[AWS] AWS Builders online - Networking ์ •๋ฆฌํ•˜๊ธฐ 1

AWS ๋„คํŠธ์›Œํ‚น ์„œ๋น„์Šค๋Š” ํฌ๊ฒŒ 5๊ฐ€์ง€๋กœ ์ด๋ฃจ์–ด์ ธ ์žˆ์Šต๋‹ˆ๋‹ค. | ๋ช…์นญ | ์„ค๋ช… | |:----------:|:----------:| | VPC | AWS ํด๋ผ์šฐ๋“œ์— ๋งŒ๋“œ๋Š” ๊ฐ€์ƒ์˜ ๋ฐ์ดํ„ฐ์„ผํ„ฐ | | VPN | On-prem ๋ฐ์ดํ„ฐ์„ผํ„ฐ์™€ VPC์˜ IPsec VPN ์—ฐ๊ฒฐ |

2021๋…„ 1์›” 25์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
ยท

[MySQL] 9ํŽธ view ์ดํ•ดํ•˜๊ธฐ

view๋Š” ๊ฐ€์ƒ์˜ ํ…Œ์ด๋ธ”์ด๋ผ๊ณ  ์ƒ๊ฐํ•˜๋ฉด ๋ฉ๋‹ˆ๋‹ค. ๋ง๊ทธ๋Œ€๋กœ ๋ฐ์ดํ„ฐ๋Š” ์—†๊ณ , SQL์—๋งŒ ์ €์žฅ๋˜์–ด์žˆ๋Š” object๋ฅผ ๋งํ•ฉ๋‹ˆ๋‹ค. view๋ฅผ select ํ•˜๊ฒŒ ๋˜๋ฉด view๊ฐ€ ๊ฐ€์ง€๊ณ  ์žˆ๋Š” SQL๋ฌธ์ด ์‹คํ–‰์ด ๋˜๋Š”๊ฒƒ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค.์—ฌ๋Ÿฌํ…Œ์ด๋ธ”์„ ์กฐ์ธ ํ•  ์‹œ์— view ๋ทฐ๋ฅผ ํ†ตํ•˜๋ฉด SQL

2021๋…„ 1์›” 17์ผ
ยท
1๊ฐœ์˜ ๋Œ“๊ธ€
ยท

[MySQL] 8ํŽธ index ์ดํ•ดํ•˜๊ธฐ

์ธ๋ฑ์Šค๋ฅผ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์—์„œ ์‚ฌ์šฉํ•˜๋Š” ๊ฐ€์žฅ ํฐ ์ด์œ ๋Š” ๊ฒ€์ƒ‰ ์†๋„๋ฅผ ๋†’์ด๊ธฐ ์œ„ํ•ด์„œ ์ž…๋‹ˆ๋‹ค. ์ธ๋ฑ์Šค๋Š” ํ…Œ์ด๋ธ” ๋‚ด ๋ฐ์ดํ„ฐ๋ฅผ ์ •๋ ฌํ•œ ๋’ค ํ•„์š”๋กœ ํ•˜๋Š” ๋ฐ์ดํ„ฐ๋งŒ ๋นจ๋ฆฌ ๊ฐ€์ง€๊ณ  ์˜ค๊ธฐ ์œ„ํ•ด์„œ ์‚ฌ์šฉ์„ ํ•˜๊ฒŒ ๋ฉ๋‹ˆ๋‹ค.์ธ๋ฑ์Šค๊ฐ€ ์—†๋‹ค๋ฉด ํ…Œ์ด๋ธ” ๋ฐ์ดํ„ฐ๋ฅผ ์ฒ˜์Œ๋ถ€ํ„ฐ ๋๊นŒ์ง€ ํ•ด๋‹น ๋ฐ์ดํ„ฐ๊ฐ€ ์žˆ๋Š”์ง€ ํ•˜๋‚˜ํ•˜๋‚˜

2021๋…„ 1์›” 17์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
ยท

[MySQL] 7ํŽธ UPDATE ์‚ฌ์šฉํ•˜๊ธฐ, DELETE ์‚ฌ์šฉํ•˜๊ธฐ

update๋ž€ ๊ธฐ์กด ๋ฐ์ดํ„ฐ์˜ row ์ˆ˜๋Š” ๋ณ€ํ•˜์ง€ ์•Š์ง€๋งŒ row ๋‚ด ํŠน์ • ์นผ๋Ÿผ์˜ ๊ฐ’์ด ๋ฐ”๋€Œ๋Š” ์ž‘์—…์„ ๋งํ•ฉ๋‹ˆ๋‹ค. update ๋‹ค์Œ์— ํ…Œ์ด๋ธ”๋ช…์„ ๋ช…์‹œํ•˜๊ธฐ ๋•Œ๋ฌธ์— from์„ ์“ฐ์ง€ ์•Š์Šต๋‹ˆ๋‹ค.employee์‚ฌ๋ฒˆ์ด 1014๋ฒˆ์ธ ์‚ฌ์›์˜ ์ด๋ฆ„์„ '๊น€๋ฏผ๊ทœ'๋กœ ๋ฐ”๊พธ๊ณ ์ž ํ•ฉ๋‹ˆ๋‹ค.๋งŒ์•ฝ์— wh

2021๋…„ 1์›” 17์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
ยท

[MySQL] 6ํŽธ JOIN, EQUI JOIN, NON-EUQI JOIN, OUTER JOIN, SELF JOIN ์•Œ์•„๋ณด๊ธฐ

๊ด€๊ณ„ํ˜• ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๋ž€ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๋‚ด์— ์žˆ๋Š” ํ…Œ์ด๋ธ”์ด๋‚˜ ์Šคํ‚ค๋งˆ๋“ค์ด ์„œ๋กœ ๊ด€๊ณ„๋ฅผ ๊ฐ€์ง€๊ณ  ์žˆ๋‹ค๋Š” ๋œป์ž…๋‹ˆ๋‹ค. ๊ทธ๋ ‡๋‹ค๋ฉด ์ด๋Ÿฌํ•œ ๊ด€๊ณ„๋ฅผ ์ด์šฉํ•ด์„œ SQL์„ ์ž‘์„ฑํ•˜๊ธฐ๋„ ํ•ด์•ผ ํ•  ํ…๋ฐ, ์ด๋Ÿด ๋•Œ ์‚ฌ์šฉํ•˜๋Š” ๊ฒŒ ๋ฐ”๋กœ join ์ž…๋‹ˆ๋‹ค.join์„ ์‚ฌ์šฉํ•ด์„œ ์—ฌ๋Ÿฌ ํ…Œ์ด๋ธ”์ด๋‚˜ ์Šคํ‚ค๋งˆ์— ๋ถ„์‚ฐ๋˜์–ด

2021๋…„ 1์›” 17์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
ยท

[MySQL] 5ํŽธ ๋ณต์ˆ˜ ํ–‰(window)ํ•จ์ˆ˜ (count, sum, avg, max, min, stddev) GROUP BY

5ํŽธ์—์„œ๋Š” ๋ณต์ˆ˜ ํ–‰ ํ•จ์ˆ˜, ํ”ํžˆ ๋งํ•˜๋Š” window ํ•จ์ˆ˜์— ๊ด€ํ•ด์„œ ๋ช‡๊ฐ€์ง€ ์š”์•ฝํ•ด๋ณด๋ ค ํ•ฉ๋‹ˆ๋‹ค. SQL์—์„œ ์‚ฌ์šฉ๋˜๋Š” ๋ณต์ˆ˜ ํ–‰ ํ•จ์ˆ˜๋Š” ๋‹จ์ผ ํ–‰ ํ•จ์ˆ˜์™€๋Š” ๋‹ค๋ฅด๊ฒŒ ํ•œ ๋ฒˆ์— ์—ฌ๋Ÿฌ ๋ฐ์ดํ„ฐ์— ๋Œ€ํ•œ ๊ฒฐ๊ณผ๋ฅผ ์ถœ๋ ฅํ•˜๋Š” ํ•จ์ˆ˜๋ฅผ ๋งํ•ฉ๋‹ˆ๋‹ค.count() ํ•จ์ˆ˜ ์•ˆ์— ํŠน์ • ์นผ๋Ÿผ๋ช…์„ ๋„ฃ๋Š”๋‹ค๋ฉด ํ•ด๋‹น

2021๋…„ 1์›” 17์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
ยท
post-thumbnail

[MySQL] 4ํŽธ ๋‹จ์ผํ–‰ํ•จ์ˆ˜ (ifnull, if, lower/upper, trim, round, mod, now)

ํ•จ์ˆ˜์˜ ์ข…๋ฅ˜๋Š” ๋งค์šฐ๋งค์šฐ ๋งŽ๊ธฐ ๋•Œ๋ฌธ์— ์™ธ์šฐ๊ธฐ๋ณด๋‹ค๋Š” ํ•„์š”ํ•  ๋•Œ ๊ฒ€์ƒ‰ํ•ด์„œ ์‚ฌ์šฉํ•˜๋Š” ๊ฒƒ์ด ์ข‹์Šต๋‹ˆ๋‹ค.4ํŽธ์—์„œ๋Š” ์ž์ฃผ ์‚ฌ์šฉํ•˜๋Š” ๋ช‡ ๊ฐ€์ง€์˜ ๋‹จ์ผํ–‰ํ•จ์ˆ˜๋ฅผ ์•Œ์•„๋ณด๋ ค๊ณ ํ•ฉ๋‹ˆ๋‹ค! ํ•จ์ˆ˜๋งŒ ์ž˜ ์‚ฌ์šฉํ•˜๋”๋ผ๋„ SQL ํ™œ์šฉ๋Šฅ๋ ฅ์„ ๋งŽ์ด ๋Œ์–ด์˜ฌ๋ฆด ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. null์ธ ๋ฐ์ดํ„ฐ ๊ฐ’์ด ์žˆ์„ ๋•Œ nu

2021๋…„ 1์›” 17์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
ยท

[MySQL] 3ํŽธ SELECT ์‹ฌํ™” (AS, ORDER BY, DISTINCT, concat, ์‚ฐ์ˆ ์—ฐ์‚ฐ์ž)

์˜ค๋Š˜ SELECT ์‹ฌํ™”ํŽธ๊ณผ ํ•จ๊ป˜ํ•  ํ…Œ์ด๋ธ”์ž…๋‹ˆ๋‹ค. ๊ต์–‘ ๊ณผ๋ชฉ์„ ๋“ฃ๋Š” ํ•™์ƒ๋“ค์˜ ์ „๊ณต๊ณผ ์ค‘๊ฐ„๊ณ ์‚ฌ ์ ์ˆ˜์ž…๋‹ˆ๋‹ค.student_grade์ถœ๋ ฅํ• ๋•Œ ๊ธฐ์กด ํ…Œ์ด๋ธ”์˜ ์ปฌ๋Ÿผ๋ช… ๋Œ€์‹  ์›ํ•˜๋Š” ์ด๋ฆ„์ด ์žˆ์„ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ๊ทธ ๋•Œ ์‚ฌ์šฉํ•˜๋Š” ๋ฐฉ์‹์ž…๋‹ˆ๋‹ค. ์œ„์˜ ๋ช…๋ น์–ด๋ฅผ ํ†ตํ•ด ์ถœ๋ ฅํ• ๋•Œ ์ปฌ๋Ÿผ๋ช…์„ ์›ํ•˜๋Š”

2021๋…„ 1์›” 17์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
ยท
post-thumbnail

[MySQL] 2ํŽธ ํ…Œ์ด๋ธ” ์ƒ์„ฑ, CREATE TABLE, INSERT ์‚ฌ์šฉํ•˜๊ธฐ, SELECT ๊ธฐ์ดˆ

์ด์ œ ์Šคํ‚ค๋งˆ๋ฅผ ์ƒ์„ฑํ–ˆ๋‹ค๋ฉด, ํ‘œ๋ฅผ ์ƒ์„ฑํ•  ์ค€๋น„๊ฐ€ ๋๋‚ฌ์Šต๋‹ˆ๋‹ค.๋งŒ์•ฝ ์ด๋Ÿฌํ•œ 'topic'์ด๋ผ๋Š” ์ด๋ฆ„์˜ ํ…Œ์ด๋ธ”์„ ์ƒ์„ฑํ•˜๊ณ  ์‹ถ๋‹ค๋ฉด CREATE TABLE๊ณผ INSERT ๋‘๊ฐœ์˜ ๋ช…๋ น์–ด์™€ ์นœํ•ด์ ธ์•ผ ํ•ฉ๋‹ˆ๋‹ค.์ผ๋‹จ ํ…Œ์ด๋ธ” ๋‚ด์˜ ๋ฐ์ดํ„ฐ๋“ค์„ ๋„ฃ๊ธฐ ์œ„ํ•ด์„œ, CREATE TABLE์„ ์ด์šฉํ•˜์—ฌ

2021๋…„ 1์›” 17์ผ
ยท
0๊ฐœ์˜ ๋Œ“๊ธ€
ยท