๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
๋ฐ˜์‘ํ˜•

ํƒœ๊ทธ

oracle ์•Œ๊ณ ๋ฆฌ์ฆ˜ ๋™์  ๊ณ„ํš๋ฒ• CentOS Python ๊ฐœ๋ฐœ๋กœ๊ทธ ์—‘์…€ SGA Docker ๋„์ปค ansible shared pool ๋ฐฑ์ค€ Tunning ์ „์ž์„œ๋ช… ์•”ํ˜ธํ™” ๋ณด์•ˆ Linux kubernetes BFS ํ–‰๋ ฌ Django ubuntu Recovery Lis FlashBack vagrant Oracle Network Oracle Process ์ž๋ฐ” ๋น„ํŠธ์—ฐ์‚ฐ ์˜ค๋ผํด ๊ธฐ๋ณธ Spring ์—‘์…€ ์Šคํ”„๋ง ์—‘์…€ Pycharm ์„ค์น˜ ์ฟ ๋ฒ„๋„คํ‹ฐ์Šค django mysql Oracle Listener poi datapump nginx MongoDB ์šฐ์šธ์ฆ ์ฆ์ƒ VLOOKUP listener.ora ๋น„ํŠธ์—ฐ์‚ฐ ํŒŒ์ด์ฌ SSH Tomcat SVN ์˜ค๋ผํด ์—‘์…€ํ•จ์ˆ˜ ์ •์‹ ๊ฑด๊ฐ• Puppet MySQL ๋งˆ์ธ๋“œํ’€๋‹ˆ์Šค ์ง์—… ์‹ฌ๋ฆฌ์ƒ๋‹ด ์ง„๋กœ ์ •์‹ ๊ฑด๊ฐ• ์ž๊ฒฉ์ฆ ์ •์‹ ๊ฑด๊ฐ• ๊ด€๋ จ ์ง์—… ๋ถ€๋ชจ ๋Œ€์ฒ˜๋ฒ• ์ž๋…€ ์‹ฌ๋ฆฌ์ƒ๋‹ด ์•„์ด ๊ฐ์ •๋ณ€ํ™” ์‚ฌ์ถ˜๊ธฐ ์šฐ์šธ์ฆ ๊ฑฑ์ • ์ผ๊ธฐ ์ฒญ๋…„ ์ง„๋กœ ํ˜ธํก ํ›ˆ๋ จ ์ฒญ์†Œ๋…„ ์šฐ์šธ์ฆ ์ง•ํ›„ ์žฅ๋‡Œ์ถ• PHQ-9 ๋ถˆ์•ˆ ์™„ํ™” ์ฒญ์†Œ๋…„ ์ •์‹ ๊ฑด๊ฐ• ์ผ์ƒํšŒ๋ณต ๋žœ์ฒ˜ ๋น„์ „๊ณต์ž ๊ฐœ๋ฐœ์ž Partition Table Transportable tablespace Data ์ด๋™ Data Migration ์ƒ˜ํ”Œ์Šคํ‚ค๋งˆ Dedicated Server Shared Server Oracle ๋„คํŠธ์›Œํฌ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ƒ์„ฑ ํ›„์†์ž‘์—… Reserved Pool Result Cache Data Dictionary Cache ๋ฐ์ดํ„ฐ ์ด๋™ CREATE DATABASE GKE DB๋ž€ ํŒŒ์ด์ฌํŠœํ„ฐ ํŒŒ์ด์ฌํŒ๋‹ค์Šค PythonPandas ์—‘์…€์ฃผ๋ฏผ๋ฒˆํ˜ธ ์—‘์…€ SUBSTITUTE ์ดํด๋ฆฝ์ŠคํŒŒ์ด์ฌ ์ธํ„ฐํŽ˜์ด์Šค ์‚ฌ์šฉ ์˜ˆ์ œ ์ถ”์ƒํด๋ž˜์Šค ์‚ฌ์šฉ ์˜ˆ์ œ ์ธํ„ฐํŽ˜์ด์Šค ์‚ฌ์šฉ ์ถ”์ƒํด๋ž˜์Šค ์‚ฌ์šฉ ์ธํ„ฐํŽ˜์ด์Šค ์šฉ๋„ ์ถ”์ƒํด๋ž˜์Šค ์šฉ๋„ ์ถ”์ƒํด๋ž˜์Šค ์ธํ„ฐํŽ˜์ด์Šค ์ฐจ์ด์  ํ˜ผ์ž ๊ณต๋ถ€ํ•˜๋Š” ํŒŒ์ด์ฌ ํŒŒ์ด์ฌ ์ฑ… ์ถ”์ฒœ ๋ธ”๋ก ์ตœ๋Œ€ํ•ฉ ์•Œ๊ณ ๋ฆฌ์ฆ˜ ํ…ŒํŠธ๋กœ๋ฏธ๋…ธ ์ผ๊ณฑ ๋‚œ์Ÿ์ด Java ๋ฐฑ์ค€ 2309 ๋ฐฑ์ค€2609 ์ž๋ฐ”< ์ž๋ฐ” >> DB ์ƒ์„ฑ ์˜ค๋ผํด INITCAP ์˜ค๋ผํด UPPER ์˜ค๋ผํด LOWER ์˜ค๋ผํด ๋Œ€์†Œ๋ฌธ์ž ์˜ค๋ผํด INSTR ์˜ค๋ผํด CONCAT ์˜ค๋ผํด ๊ธธ์ด ํ•จ์ˆ˜ ์˜ค๋ผํด ์œ„์น˜ ํ•จ์ˆ˜ ์˜ค๋ผํด ๋ฌธ์ž์—ด ํ•จ์ˆ˜ TRUNC ํ•จ์ˆ˜ CEIL ํ•จ์ˆ˜ SQRT ํ•จ์ˆ˜ POWER ํ•จ์ˆ˜ SIGN ํ•จ์ˆ˜ ์˜ค๋ผํด ์ˆซ์žํ•จ์ˆ˜ ์˜ค๋ผํด ์ง‘๊ณ„ ๊ทธ๋ฃนํ•ฉ์ˆ˜ ORDER BY ๊ธฐ๋ณธ ์˜ค๋ผํด ORDER BY NOT ๋ช…๋ น IN ๋ช…๋ น BETWEEN ๋ช…๋ น LIKE ๋ช…๋ น ORACLE WHERE DB WHERE WHERE ๊ธฐ๋ณธ WHERE ๋ช…๋ น์–ด DB ๊ธฐ๋ณธ DB SELECT ์‚ฌ์šฉ๋ฒ• SELECT ๋ช…๋ น ๋ฉ”์ด๋ธ ๋กœ์ปฌ maven local repository VSCode Maven VSCode ๋ฉ”์ด๋ธ VSCode ๋นŒ๋“œ ์Šคํ”„๋ง ํ”„๋กœ์ ํŠธ ๋นŒ๋“œ VSCode Tomcat ๋น„์ฃผ์–ผ์ฝ”๋“œ ์Šคํ”„๋ง ๋น„์ฃผ์–ผ์ฝ”๋“œ ํ†ฐ์บฃ ์Šคํ”„๋ง ์—๋””ํ„ฐ VSCode ์Šคํ”„๋ง VSCode ํ†ฐ์บฃ ๊นƒ ์—ฐ๋™ git ์—ฐ๋™ ์ดํด๋ฆฝ์Šค git ์—ฐ๋™ eclipse git clone ide git clone ์ดํด๋ฆฝ์Šค git clone ์ดํด๋ฆฝ์Šค git jenkins svn ํ˜•์ƒ๊ด€๋ฆฌ ๋ฐฐํฌ ์  ํ‚จ์Šค ๋ฐฐํฌ ์  ํ‚จ์Šค svn POI ํฐํŠธ POI ์Šคํƒ€์ผ ์ž๋ฐ” ์—‘์…€ ๋‹ค์šด๋กœ๋“œ ์ž๋ฐ” ์—‘์…€ ์—…๋กœ๋“œ ์Šคํ”„๋ง ์—‘์…€ ์—…๋กœ๋“œ ์Šคํ”„๋ง ์—‘์…€ ๋‹ค์šด๋กœ๋“œ ์ž๋ฐ” ์—‘์…€ ์Šคํ”„๋ง POI ๋งฅOS ์˜ค๋ผํด ์„ค์น˜ ๋งฅOS Oracle ๋งฅ Oracle ๋งฅOS ์˜ค๋ผํดDB ๋งฅ ์˜ค๋ผํดDB ๋งฅOS ์˜ค๋ผํด ๋งฅ ์˜ค๋ผํด ๋„์ปค ์˜ค๋ผํดDB Docker Oracle ๋„์ปค ์˜ค๋ผํด ๋„์ปค ํ‚ค๋„ค๋งˆํ‹ฑ ํ‚ค๋„ค๋งˆํ‹ฑ ๋งฅOS ๋„์ปค ์„ค์น˜ ๋งฅ ๋„์ปค ์„ค์น˜ ์Šคํ”„๋ง ๋™์‹œ ์‹คํ–‰ ์Šคํ”„๋ง ์“ฐ๋ ˆ๋“œ ๋’ค์—์„œ ์‹คํ–‰ ์“ฐ๋ ˆ๋“œ ๋™์‹œ ์“ฐ๋ ˆ๋“œ ์‹คํ–‰ background Thread ๋ฐฐ๊ฒฝ์‹คํ–‰ Spring ๋™์  ์‹คํ–‰ ์žฅ๊ณ  MySQL ์„ค์ • ์žฅ๊ณ  MySQL ์žฅ๊ณ  ํ”„๋กœ์ ํŠธ ์„ค์ • setting.py ์žฅ๊ณ  MySQL ์—ฐ๋™ ์žฅ๊ณ  DB ์—ฐ๋™ Django DB ์—ฐ๋™ ์žฅ๊ณ  ์‹œ์ž‘ ์žฅ๊ณ  ์‹คํ–‰ Django Setting ์žฅ๊ณ  ์„ธํŒ… Django Atom ์žฅ๊ณ  ์•„ํ†ฐ ๊ณต๋ฐฑ ์…€ ์ œ๊ฑฐ ๋นˆ ์…€ ๊ณต๋ฐฑ ์…€ ์Šค์ปฌํ”„ ์›น์„œ๋ฒ„ ๋กœ๊ทธ ๊ณต๊ฒฉ์„ ๋กœ๊ทธ ์ž๋™ํ™” ๊ณต๊ฒฉ์„ฑ ๋กœ๊ทธ ๊ณต๊ฒฉ์„ฑ ๋กœ๊ทธ ๋‚จ๊ธฐ๊ธฐ ๊ณต๊ฒฉ์„ฑ ๋กœ๊ทธ ๋ถ„์„ Jupyter Notebook ์„ค์น˜ Jupyter Notebook ์‹คํ–‰ ์›น ์ฝ”๋”ฉ ํŒŒ์ด์ฌ ์›น Vscode Spring eclipse git ๊ฐ์ •๋ถ„์„ ์˜์–ด ๋ฐ์ดํ„ฐ ์ „์ฒ˜๋ฆฌ ํŒŒ์ด์ฌ ๊ฐ์ •๋ถ„์„ Python ๊ฐ์ •๋ถ„์„ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ํ•ฉ๊ณ„ ํ…Œ์ด๋ธ” ํ•ฉ๊ณ„ localhost ์™ธ๋ถ€ ์ ‘๊ทผ localhost ํ„ฐ๋„ ์—‘์…€ search ์—‘์…€ ~ ์—‘์…€ ? ์—‘์…€ * VLOOKUP TRUE VLOOKUP ์œ ์‚ฌ๊ฐ’ DB ๋กœ๊ทธํ™•์ธ MySQL ๋กœ๊ทธ ํŒŒ์ด์ฌ MySQL MySQL ์—‘์…€ DB ์—‘์…€ ํŒŒ์ด์ฌ ์—‘์…€ opempyxl ํŒŒ์ด์ฌ C++ ์—๋Ÿฌ ํŒŒ์ด์ฌ C++ ํŒŒ์ด์ฌ ์›Œ๋“œํด๋ผ์šฐ๋“œ Python ์›Œ๋“œํด๋ผ์šฐ๋“œ ์•„๋‚˜์ฝ˜๋‹ค ์„ค์น˜ PyCharm Interpreter PyCharm ๋ชจ๋“ˆ ์ถ”๊ฐ€ Beautifulsoup ์†๋„ multiprocessiong BeautifulSoup ์†๋„๊ฐœ์„  VSCode ์‹คํ–‰ ํ™˜๊ฒฝ์„ค์ • VSCode Python Run Task Run Task VSCode Run Task ๋ถ€๋ถ„์ง‘ํ•ฉ ์•Œ๊ณ ๋ฆฌ์ฆ˜ ์ •์‹ ๊ฑด๊ฐ•์‚ฌํšŒ๋ณต์ง€์‚ฌ ThreadPoolTaskExecutor ์ด๋ฏธ์ง€ url ํ˜ธ์ถœ nginx ์ด๋ฏธ์ง€ AJAX ์˜ˆ์ œ AJAX ์‹ค์Šต MySQL ์ปดํŒŒ์ผ ์„ค์น˜ Tomcat 8.5.24 CentOS 7.4 kitematic sudoers ๋ฐฑ์ค€ 1978 ๋„์ปค ์„ค์น˜ docker ์„ค์น˜ pymysql jupyter notebook Ngrok ํŒŒ์ด์ฌ ์›น ํ”„๋กœ๊ทธ๋ž˜๋ฐ ํŒŒ์ด์ฌ ๋ฐ์ดํ„ฐ ๋ถ„์„ ๊ฐœ๋ฐœ์ž์ทจ์—… ๋ฐฑ์ค€ 14500 ์ผ๊ณฑ ๋‚œ์Ÿ์ด Django ์„ค์น˜ ์žฅ๊ณ  ์„ค์น˜ ์ง‘๊ณ„ํ•จ์ˆ˜ ์†Œ์ˆ˜๊ตฌํ•˜๊ธฐ ํŒŒ์ด์ฌ ๊ฐ€์ƒํ™˜๊ฒฝ ์œ ํด๋ฆฌ๋“œ ํ˜ธ์ œ๋ฒ• ํŒŒ์ด์ฐธ ์ ํ”„ ํˆฌ ํŒŒ์ด์ฌ ํŒŒ์ด์ฌ ์ฑ… virtualenvwrapper vscode Git clone ๋ถˆ์•ˆ ํ•ด์†Œ๋ฒ• Round ํ•จ์ˆ˜ ๋ฐ์ดํ„ฐ ์ „์ฒ˜๋ฆฌ virtualenv ๋””์ง€ํ„ธ ๋””ํ†ก์Šค ์˜ค๋ผํด ๊ทธ๋ฃน ์†Œ์ˆ˜์ฐพ๊ธฐ ์—‘์…€ ์—…๋กœ๋“œ ๋™์ ๊ณ„ํš๋ฒ• PyCharm centos7 Database System ์—‘์…€ ์™€์ผ๋“œ์นด๋“œ ์—‘์…€ find LCS SQL Loader ์ฒญ์†Œ๋…„ ์ƒ๋‹ด prime number ์ŠคํŠธ๋ ˆ์Šคํ•ด์†Œ์Œ์‹ ์ •์‹ ๊ณผ ์ƒ๋‹ด Scalp ์˜ค๋ผํด length ์‹ฌ๋ฆฌํ•™ ์ „๊ณต ๋งˆ์Œ์ฑ™๊น€ ์ธ์ง€ํ–‰๋™์น˜๋ฃŒ ์  ํ‚จ์Šค ๋‡Œ๊ฑด๊ฐ•์Œ์‹ ๊ฑด๊ฐ•ํ•œ์‹๋‹จ Anaconda ์ตœ๋Œ€๊ณต์•ฝ์ˆ˜ ์ตœ์†Œ๊ณต๋ฐฐ์ˆ˜ Jenkins ssh ์ ‘์† ์ถ”์ƒํด๋ž˜์Šค euclidean sentiment library cache ๋งˆ์Œ๊ฑด๊ฐ• ์—‘์…€ ๋‹ค์šด๋กœ๋“œ ์Šค์นผํ”„ file system ์ž๋ฐ” ์„ค์น˜ ๊ฐ์ •๊ด€๋ฆฌ SELECT ์ฟผ๋ฆฌ ์šฐ์šธ์ฆ ์ž๊ฐ€์ง„๋‹จ lombok tnsnames.ora ์ •์‹ ๊ณผ ์ „๋ฌธ์˜ brute-Force ๋ธŒ๋ฃจํŠธํฌ์Šค gcp ์‹คํ–‰๊ณ„ํš ๋ถˆ์•ˆ์žฅ์•  ํ•ญ์šฐ์šธ์ œ ์ฃผํ”ผํ„ฐ MATERIALIZED VIEW DSUM DMIN DMAX DCOUNT HLOOKUP LCM GCD OCP ์Šˆํผํ‘ธ๋“œ ์ž„์ƒ์‹ฌ๋ฆฌ์‚ฌ ๋ฉ”์ด๋ธ ์ƒ๋‹ด์‹ฌ๋ฆฌ์‚ฌ ์˜ค๋ผํด ์•„ํ‚คํ…์ฒ˜ ์ •๋ถ€์ง€์› BP ์žฅ๊ณ  ์„ผํŠธ์˜ค์—์Šค ํ•™์—… ์ŠคํŠธ๋ ˆ์Šค ์ž๊ฐ€์ง„๋‹จ ์šฐ์šธ์ฆ์˜ˆ๋ฐฉ index scan tablespace ์žฌ๊ท€ํ•จ์ˆ˜ ์•„์ž‘์Šค ์™€์ผ๋“œ์นด๋“œ ์†Œ์ˆ˜ ๋ฒ„์ถ”์–ผ๋ฐ•์Šค ์•„๋‚˜์ฝ˜๋‹ค ๋ธ”๋ฃจ๋ฒ ๋ฆฌํšจ๋Šฅ VirtualBox pki ์‹ฌ๋ฆฌ์น˜๋ฃŒ vi ๋ฐœํšจ์‹ํ’ˆ ์šฐ๋ถ„ํˆฌ subversion ์ธํ„ฐํŽ˜์ด์Šค AJAX ์˜ค๋ฉ”๊ฐ€3 ์ฒญ๋…„ maven instr concat order by ์ ˆ ๋ฆฌ๋ˆ…์Šค ๋ช…์ƒ ๋กฌ๋ณต ์šฐ์šธ์ฆ ๋ฉด์ ‘ ์‹ ์ž…๊ณต์ฑ„ Index join dfs abs rancher length search Eclipse find
๋ฐ˜์‘ํ˜•