About Me

์ž‘์„ฑ์ž:

Hi there ๐Ÿ‘‹

I am Jiyeon studying coding ๐Ÿ˜Š๐Ÿ˜Š๐Ÿ˜Š

To be honest, I majored in international trade that had nothing to do with coding,

but now I enjoy studying coding.

I'm not good at it yet, but I'll study hard and

become a full-stack engineer๐Ÿ˜Ž๐Ÿ˜Ž๐Ÿ˜Ž


๐ŸŒผ About Me ๐ŸŒผ

  

๐ŸŒผ๐ŸŒผ Tech Stacks ๐ŸŒผ๐ŸŒผ

  
     

๐ŸŒท Tool ๐ŸŒท

  

๋Œ“๊ธ€

๋Œ“๊ธ€ ์“ฐ๊ธฐ

์ด ๋ธ”๋กœ๊ทธ์˜ ์ธ๊ธฐ ๊ฒŒ์‹œ๋ฌผ

๊ธฐ์ดˆ html_1. ํ‹€ ๋งŒ๋“ค๊ธฐ

์ž‘์„ฑ์ž:
์ด๋ฏธ์ง€
 ๐Ÿ’œ HTML์„ ์‹œ์ž‘ํ•˜๋Š” ๋ฒ• ๐Ÿ’œ   1.  ๋จผ์ € Visual Studio Code(VS์ฝ”๋“œ)๋ฅผ ์‹คํ–‰ํ•ฉ๋‹ˆ๋‹ค.(ํ”„๋กœ๊ทธ๋žจ์ด ์—†์œผ๋ฉด ์„ค์น˜ ํ•„์ˆ˜!) Visual Studio Code  2. ์›ํ•˜๋Š” ํด๋”์— ์ƒˆ ํŒŒ์ผ์„ ์ƒ์„ฑํ•ฉ๋‹ˆ๋‹ค. ํŒŒ์ผ ๋งŒ๋“œ๋Š” ๋ฒ• 1. ์›ํ•˜๋Š” ํด๋”์— ์ปค์„œ๋ฅผ ๋†“๊ณ  ๋งˆ์šฐ์Šค ์˜ค๋ฅธ์ชฝ์„ ํด๋ฆญํ•ด์„œ new file ํด๋ฆญ ํŒŒ์ผ ๋งŒ๋“œ๋Š” ๋ฒ•2. ์›ํ•˜๋Š” ํด๋”๋ฅผ ํด๋ฆญํ•˜๊ณ  ์œ„์— ์žˆ๋Š” ๋ฒ„ํŠผ์„ ํด๋ฆญํ•ด์„œ ์ƒ์„ฑ  3. "!"๋ฅผ ์ž…๋ ฅํ•˜๊ณ  Enter๋‚˜ Tabํ‚ค๋ฅผ ๋ˆ„๋ฅธ๋‹ค.                ์œ„์™€ ๊ฐ™์€ ํƒœ๊ทธ๋“ค์ด ์ƒ์„ฑ๋˜์—ˆ๋‹ค๋ฉด, ๊ธฐ๋ณธ์ ์ธ ํ‹€์€ ์™„์„ฑ!  4. ๊ธฐ๋ณธ์ ์ธ ํ‹€์ด ์™„์„ฑ๋˜์—ˆ์œผ๋‹ˆ, html, css, js๋ฅผ ํ™œ์šฉํ•ด์„œ ๊พธ๋ฉฐ์ฃผ๋ฉด ๋ฉ๋‹ˆ๋‹น!
Read more »

1012 ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ๋ฌธ์ œํ’€๊ธฐ

์ž‘์„ฑ์ž:
์ด๋ฏธ์ง€
  1. ์‚ฌ์›์ด๋ฆ„, ์‚ฌ์›์ง์ฑ…, ์‚ฌ์›๊ธ‰์—ฌ ์กฐํšŒ. select ename, job, sal from emp 2. ์‚ฌ์ˆ˜๋ฒˆํ˜ธ๊ฐ€ 7839์ธ ์‚ฌ์› ๋ฒˆํ˜ธ, ์ด๋ฆ„, ์ž…์‚ฌ๋‚ ์งœ ์กฐํšŒ. select empno, ename, hiredate from emp where mgr=7839 3. ๊ธ‰์—ฌ๊ฐ€ 3000 ์ดํ•˜์ธ ์‚ฌ์›์˜ ๋ชจ๋“  ์ •๋ณด ์กฐํšŒ. select * from emp where sal<=3000 4. ์‚ฌ์›์ด๋ฆ„, ๋ถ€์„œ๋ฒˆํ˜ธ, ๋ถ€์„œ์ด๋ฆ„, ๋ถ€์„œ ๊ทผ๋ฌด์ง€ ์กฐํšŒ. select e.ename as "์‚ฌ์›์ด๋ฆ„", e.deptno as "๋ถ€์„œ๋ฒˆํ˜ธ", d.dname as "๋ถ€์„œ์ด๋ฆ„", d.loc as "๋ถ€์„œ๊ทผ๋ฌด์ง€"            from emp as e inner join dept as d on e.deptno=d.deptno 5. ๋ถ€์„œ๋ณ„ ๊ธ‰์—ฌํ•ฉ๊ณ„, ๋ถ€์„œ์ด๋ฆ„ ์กฐํšŒ. select d.dname as "๋ถ€์„œ์ด๋ฆ„", sum(e.sal) as "๊ธ‰์—ฌํ•ฉ๊ณ„"            from emp as e inner join dept as d on e.deptno=d.deptno group by e.deptno 6. ๋ถ€์„œ ๊ทผ๋ฌด์ง€๊ฐ€ NEW YORK์ด๊ณ , ์ง์ฑ…์ด MANAGER์ธ ์‚ฌ์›์˜ ์ด๋ฆ„, ๊ธ‰์—ฌ ์กฐํšŒ.  select e.ename as "์‚ฌ์›์ด๋ฆ„", e.sal as "๊ธ‰์—ฌ"  from emp as e            inner join dept as d on e.deptno=d.deptno where d.loc="new york" and e.job = "manager" 7. 1983๋…„ ์ดํ›„ ์ž…์‚ฌํ•œ ์‚ฌ์›์˜ ๋ณด๋„ˆ์Šค๊ฐ€ null์ด๋ฉด 100 ์ฃผ๊ณ , ์‚ฌ์›์˜ ์ด๋ฆ„, ๋ถ€์„œ์ด๋ฆ„, ์ง์—… ์กฐํšŒ. select ifnull(e.comm,100), e.ename as "์‚ฌ์›์ด๋ฆ„", d....
Read more »