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

ํƒœ๊ทธ

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 ์‹ ์ƒ์•„ํŠน๋ก€๋Œ€์ถœ ์ฒญ๋…„๋‚ด์ผ์ €์ถ•๊ณ„์ขŒ ๋žœ์ฒ˜ ๋น„์ „๊ณต์ž ๊ฐœ๋ฐœ์ž 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 ์ฒญ๋…„ maven instr concat order by ์ ˆ ๋ฆฌ๋ˆ…์Šค ๋กฌ๋ณต ์ •๋ถ€์ •์ฑ… ๋ฉด์ ‘ ๋Œ€์ถœ ์‹ ์ž…๊ณต์ฑ„ Index join dfs abs rancher length search Eclipse find