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

์ „์ฒด ๊ธ€24

[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค] ์กฐ๊ฑด์— ๋งž๋Š” ์‚ฌ์šฉ์ž ์ •๋ณด ์กฐํšŒํ•˜๊ธฐ/MySQL - Lv.3 โ“๋ฌธ์ œ ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์ฝ”๋“œ ์ค‘์‹ฌ์˜ ๊ฐœ๋ฐœ์ž ์ฑ„์šฉ. ์Šคํƒ ๊ธฐ๋ฐ˜์˜ ํฌ์ง€์…˜ ๋งค์นญ. ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์˜ ๊ฐœ๋ฐœ์ž ๋งž์ถคํ˜• ํ”„๋กœํ•„์„ ๋“ฑ๋กํ•˜๊ณ , ๋‚˜์™€ ๊ธฐ์ˆ  ๊ถํ•ฉ์ด ์ž˜ ๋งž๋Š” ๊ธฐ์—…๋“ค์„ ๋งค์นญ ๋ฐ›์œผ์„ธ์š”.programmers.co.kr๐Ÿ“Œ์œ ํ˜•์ง‘๊ณ„, ๋ฌธ์ž์—ดโœ๐Ÿปํ’€์ด CITY, STREET_ADDRESS1, STREET_ADDRESS2๋ฅผ ๋ชจ๋‘ ์—ฐ๊ฒฐํ•˜์—ฌ ์ „์ฒด์ฃผ์†Œ๋กœ ์ถœ๋ ฅ๋˜๋„๋ก ํ•˜๋ผ๊ณ  ํ•˜์˜€์œผ๋ฏ€๋กœ concat ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•ด์„œ ์—ฐ๊ฒฐ. SUBSTRING์„ ์ด์šฉํ•˜์—ฌ TLNO ๋ฌธ์ž์—ด์„ 3, 4, 4๊ฐœ๋กœ ๋‚˜๋ˆ„์–ด ์ค‘๊ฐ„์— '-'๋ฅผ ๋„ฃ์–ด xxx-xxxx-xxxxํ˜•ํƒœ๋กœ ์ถœ๋ ฅ๋˜๋„๋ก ํ•จ.๐Ÿ’ป์ฝ”๋“œSELECT USER_ID, NICKNAME, CONCAT(CITY, ' ', STREET_ADDRESS1, ' ', STREET_ADDRESS2) AS '์ „์ œ์ฃผ์†Œ', CONC.. 2024. 9. 28.
[Baekjoon] 28278. ์Šคํƒ 2/Java - Silver4 โ“๋ฌธ์ œhttps://www.acmicpc.net/problem/28278๐Ÿ“Œ์œ ํ˜•์Šคํƒโœ๐Ÿปํ’€์ด1๋ฒˆ ๋ช…๋ น์–ด์˜ ๊ณต๋ฐฑ ๋’ค ์˜ค๋Š” ์ˆซ์ž๋Š” ์Šคํƒ์— push.2๋ฒˆ ๋ช…๋ น์–ด ์ž…๋ ฅ ์‹œ stack.empty()๋ผ๋ฉด -1 ์•„๋‹ˆ๋ผ๋ฉด stack.pop()์œผ๋กœ ์Šคํƒ์—์„œ ๋นผ๋Š” ๋™์‹œ์— ์ถœ๋ ฅ.3๋ฒˆ ๋ช…๋ น์–ด ์ž…๋ ฅ ์‹œ stack.size()๋กœ ํฌ๊ธฐ ์ถœ๋ ฅ.4๋ฒˆ ๋ช…๋ น์–ด ์ž…๋ ฅ ์‹œ stack.empty()๋ผ๋ฉด 1 ์•„๋‹ˆ๋ฉด 0 ์ถœ๋ ฅ.5๋ฒˆ ๋ช…๋ น์–ด ์ž…๋ ฅ ์‹œ stack.empty()๋ผ๋ฉด -1 ์•„๋‹ˆ๋ฉด stack.peek()์œผ๋กœ stack์˜ top ๊ฐ’ ์ถœ๋ ฅ.๐Ÿ’ป์ฝ”๋“œimport java.util.*;import java.io.*;public class Main { static int n; static BufferedReader r = new Buffer.. 2024. 9. 28.
[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค] ๋Œ€์žฅ๊ท ์˜ ํฌ๊ธฐ์— ๋”ฐ๋ผ ๋ถ„๋ฅ˜ํ•˜๊ธฐ1/MySQL - Lv.3 โ“๋ฌธ์ œ ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์ฝ”๋“œ ์ค‘์‹ฌ์˜ ๊ฐœ๋ฐœ์ž ์ฑ„์šฉ. ์Šคํƒ ๊ธฐ๋ฐ˜์˜ ํฌ์ง€์…˜ ๋งค์นญ. ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์˜ ๊ฐœ๋ฐœ์ž ๋งž์ถคํ˜• ํ”„๋กœํ•„์„ ๋“ฑ๋กํ•˜๊ณ , ๋‚˜์™€ ๊ธฐ์ˆ  ๊ถํ•ฉ์ด ์ž˜ ๋งž๋Š” ๊ธฐ์—…๋“ค์„ ๋งค์นญ ๋ฐ›์œผ์„ธ์š”.programmers.co.kr๐Ÿ“Œ์œ ํ˜•SELECTโœ๐Ÿปํ’€์ดcase ๋ฌธ์„ ํ™œ์šฉํ•˜์—ฌ ๋ฒ”์œ„๋ณ„๋กœ ์ถœ๋ ฅ๊ฐ’ ์ง€์ •.๐Ÿ’ป์ฝ”๋“œSELECT ID, (CASE WHEN SIZE_OF_COLONY 2024. 9. 28.
[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค] ์ˆœ์œ„/Python - Lv.3 โ“๋ฌธ์ œ ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์ฝ”๋“œ ์ค‘์‹ฌ์˜ ๊ฐœ๋ฐœ์ž ์ฑ„์šฉ. ์Šคํƒ ๊ธฐ๋ฐ˜์˜ ํฌ์ง€์…˜ ๋งค์นญ. ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์˜ ๊ฐœ๋ฐœ์ž ๋งž์ถคํ˜• ํ”„๋กœํ•„์„ ๋“ฑ๋กํ•˜๊ณ , ๋‚˜์™€ ๊ธฐ์ˆ  ๊ถํ•ฉ์ด ์ž˜ ๋งž๋Š” ๊ธฐ์—…๋“ค์„ ๋งค์นญ ๋ฐ›์œผ์„ธ์š”.programmers.co.kr ๐Ÿ“Œ์œ ํ˜•๊ทธ๋ž˜ํ”„, Floyd-Warshallโœ๐Ÿปํ’€์ด1) ๊ทธ๋ž˜ํ”„ ์ž๋ฃŒ๊ตฌ์กฐ ์‚ฌ์šฉ- ์ด๊ธด ๊ทธ๋ž˜ํ”„์™€ ์ง„ ๊ทธ๋ž˜ํ”„๋ฅผ ์ธ์ ‘ ๋ฆฌ์ŠคํŠธ ํ˜•ํƒœ๋กœ ๋งŒ๋“ฆ.- 1์€ 2๋ฒˆ์„ ์ด๊น€. 1๋ฒˆ์˜ ์ด๊ธด ๊ทธ๋ž˜ํ”„์— 2๋ฒˆ์—๊ฒŒ ์ง„ 5๋ฒˆ ๋…ธ๋“œ๋ฅผ ์—…๋ฐ์ดํŠธ.- 1์€ ๋ˆ„๊ตฌ์—๊ฒŒ๋„ ์ง€์ง€ ์•Š์Œ.- 2๋ฒˆ์€ 5๋ฒˆ์„ ์ด๊ธฐ๊ณ , 1, 3, 4๋ฒˆ์—๊ฒŒ ์ง. 1, 3, 4๋ฒˆ ์ด๊ธด ๊ทธ๋ž˜ํ”„์— 5๋ฒˆ์„ ์—…๋ฐ์ดํŠธ. 5๋ฒˆ ์ง„ ๊ทธ๋ž˜ํ”„์—๋Š” 1, 3, 4๋ฒˆ์„ ์—…๋ฐ์ดํŠธ.- ๊ฐ ๋…ธ๋“œ์˜ ์ด๊ธด ๊ทธ๋ž˜ํ”„์™€ ์ง„ ๊ทธ๋ž˜ํ”„์˜ ๊ธธ์ด์˜ ํ•ฉ์ด n - 1๊ณผ ๊ฐ™๋‹ค๋ฉด answer๋ฅผ 1 ์ฆ๊ฐ€.2) Floyd-Warsh.. 2024. 9. 28.
03 Docker ์ด๋ฏธ์ง€ ๊ด€๋ฆฌ โ€ป '์‹œ์ž‘ํ•˜์„ธ์š”! ๋„์ปค/์ฟ ๋ฒ„๋„คํ‹ฐ์Šค' ์ฑ…๊ณผ ๊ต์œก์„ ํ†ตํ•ด ๋“ค์€ ๋‚ด์šฉ, ๊ณต์‹ ๋ฌธ์„œ๋ฅผ ํ† ๋Œ€๋กœ ์ •๋ฆฌํ–ˆ์Šต๋‹ˆ๋‹ค.  01 Docker ์„ค์น˜ํ•˜๊ธฐโ€ป์ด ๊ธ€์€ ์œˆ๋„์šฐ ํ™˜๊ฒฝ์— ๋งž์ถฐ ์ž‘์„ฑํ–ˆ์Šต๋‹ˆ๋‹ค.Docker ์„ค์น˜Windows Docker Desktop: The #1 Containerization Tool for Developers | DockerDocker Desktop is collaborative containerization software for developers. Get started and download Dockerlucy-devblog.tistory.com์ด์ „ ๊ฒŒ์‹œ๋ฌผ์„ ์ฐธ๊ณ ํ•˜์—ฌ ๋จผ์ € Docker๋ฅผ ์„ค์น˜ํ•˜์‹œ๋ฉด ๋ฉ๋‹ˆ๋‹ค.Docker ์„ค์น˜๊ฐ€ ๋๋‚ฌ์œผ๋ฉด ์ด์ œ๋ถ€ํ„ฐ ๋„์ปค์—์„œ ์‚ฌ์šฉํ•˜๋Š” ๋ช…๋ น์–ด๋“ค์— ๋Œ€ํ•ด ์•Œ์•„๋ณด๊ฒ ์Šต๋‹ˆ๋‹ค.์˜ค๋Š˜์€ ์ด๋ฏธ์ง€.. 2024. 9. 28.
02 Docker๋ž€? โ€ป '์‹œ์ž‘ํ•˜์„ธ์š”! ๋„์ปค/์ฟ ๋ฒ„๋„คํ‹ฐ์Šค' ์ฑ…๊ณผ ๊ต์œก์„ ํ†ตํ•ด ๋“ค์€ ๋‚ด์šฉ, ๊ณต์‹ ๋ฌธ์„œ๋ฅผ ํ† ๋Œ€๋กœ ์ •๋ฆฌํ–ˆ์Šต๋‹ˆ๋‹ค.  What is Docker?Get an in-depth overview of the Docker platform including what it can be used for, the architecture it employs, and its underlying technology.docs.docker.com๋„์ปค ๋ช…๋ น์–ด๋ฅผ ๊ณต๋ถ€ํ•˜๊ธฐ ์ „ ์šฐ์„  ์ปจํ…Œ์ด๋„ˆ์™€ ๋„์ปค์— ๋Œ€ํ•ด ๋จผ์ € ์•Œ์•„๋ณด๊ฒ ์Šต๋‹ˆ๋‹ค.์ปจํ…Œ์ด๋„ˆ๋ž€ ๋ฌด์—‡์ผ๊นŒ์š”?์ปจํ…Œ์ด๋„ˆ๋Š” ๋‹จ์ผ OS ์ปค๋„์—์„œ ๋‹ค๋ฅธ ํ”„๋กœ์„ธ์Šค์— ์˜ํ–ฅ์„ ๋ฐ›์ง€ ์•Š๊ณ  ๋…๋ฆฝ์ ์œผ๋กœ ์‹คํ–‰๋˜๋Š” ํ”„๋กœ์„ธ์Šค ์ƒํƒœ๋ฅผ ์˜๋ฏธํ•ฉ๋‹ˆ๋‹ค. ์ด๋ ‡๊ฒŒ ๊ตฌํ˜„๋œ ์ปจํ…Œ์ด๋„ˆ๋Š” ๊ฐ€์ƒํ™” ์ƒํƒœ์—์„œ ๋™์ž‘ํ•˜๋Š” ํ”„๋กœ์„ธ์Šค๋ณด๋‹ค ๊ฐ€๋ณ๊ณ  ๋น ๋ฅด๊ฒŒ ๋™์ž‘ํ•ฉ๋‹ˆ๋‹ค. ๊ทธ๋ ‡.. 2024. 9. 28.