sola.uc.ac.kr
tip_DropTable_DateFormat.txt
◎[DBM]===================================================
toc.pdf
ch6.pdf
ch7.pdf
ch8.pdf
ch9.pdf
◎[DataBase]===================================================
(a)HR-ERD.png ***
(b)HR-CreateTable.txt ***
(c)HR-InsertData.txt
1)_Oracle Database 11g SQL Fundamentals I(contents).txt
2)_Oracle_Database_11g_SQL_Fundamentals_I_(Vol1)_Oracle_SQL.pdf 2 m
3)_Oracle_Database_11g_SQL_Fundamentals_I_(Vol2)_Oracle_SQL.pdf 2.1m
ans-chap7.txt
ans-chap8.txt
4)SW-Devlopment-LifeCycle.pdf
5) 04_SELECT구조-20230911.hwp
6) A3 정보시스템구축절차-20230608.pptx
◎[SQL]===================================================
emp_dept.txt
emp_dept.sql
(a)ERD-emp_dept.png
(b)CreateTable.txt
(c)InsertData.txt
test_data_eng.sql
"오라클 데이터베이스 삭제하는 방법_181024.pdf"
오라클 SQL과 PLSQL 강의자용-서진수.zip
"=== SQL-ppt-modified-생능-서진수.zip"
10-2) JOIN(2).pptx
13-2) JOIN 요약(수정).pptx
10-3) 4장 join 연습문제.pptx
x) JOIN요약 20-11-19.pptx
_정보시스템.pptx
계층쿼리(Hierarchical Query)20240509.pptx
◎[DB Modeling]=============================================
Data Modeling and RDB Design Text
Oracle Data Modeler Users Guide.pdf ***
마당서점 ERD-p136.png ***
(b)CreateTable.txt ***
(c)InsertData-제약조건noTouch.txt
간단설치>>>
실습데이터 demo_madang.sql
책예제소스.zip
ERD-모음.hwp
_sw개발방법-(App-Web).zip
박우창워크북-실무실습org.zip
예제소스 -한빛미디어/박우창 240m: 압축 푼 후 사용
○연습문제-1장.pdf
○연습문제-2장.pdf
ppt연습문제-박우창-(정리).zip
g0 (03) keys_정규화-200327.pdf
_정보시스템vs정보처리기사.pptx
_정보시스템vs정보처리산업기사.pptx
*** ppt_4502.zip
*** ppt연습문제-박우창-(정리).zip
◎software ===============[C:]에 압축푸세요
1-1) (db)_SQLplus11.2.0.3.0(x64).zip 55m
1-3) (JDK)_1.8.0_60.zip 181m
1-4) (db)_sqldeveloper-4.1.5.21.78-no-jre.zip 343m
1-5) (db)_datamodeler-20.2.0.167.1538-no-jre.zip 310m
1-6) (앱)_Eclipse-java-2022-09-R-win32-x86_64.zip 317m
1-7) (웹)_tomcat-8.0.26.zip 12m
1-8) (웹)_eclipse(mars)-jsp.zip 300m
[[DB Server]]
6-1) OracleXE112_Win32.zip - , 310m
6-2) OracleXE112_Win64.zip - , 316m
6-3) OracleXE184_Win64.zip - , 2G
6-4) OracleXE21c_Win64.zip - , 2G server
6-11) win32_11gR2_database.zip - , 2G
[[DB Client]]
7-1) (cli)_SQLplus.bat - 21_3 (eng).zip - , 90m
7-2) (db)_SQLplus11.2.0.3.0(x64).zip - , 50m
7-3) InstantClient-win(x64)-Version 21.3.0.0.0.zip - , 50m (basic + sqlplus)조합필요
7-4) Instant Clients11_2 만들기.zip 50M (basic + sqlplus)
7-5) win32_11gR2_client.zip - , 650M
[[SQL Developer]]
8-1) _sqldeveloper-23.1.0.097.1607-x64(kor).zip 450M JDK11 included (korean)
8-2) _sqldeveloper-20.2.0.175.1842-x64(eng).zip 450M JDK11 included (english)
8-3) _sqldeveloper-23.1.0.097.1607-x64.zip 450M JDK11 included (english)
8-4) sqldeveloper-23.1.0.097.1607-x64.zip 450M JDK11 included
8-5) sqldeveloper-23.1.0.097.1607-no-jre.zip 500M JDK11 unincluded
8-6) sqldeveloper-20.2.0.175.1842-x64.zip -505M JDK8,
8-7) sqldeveloper-23.1.1.345.2114-macos-aarch64.app.zip -505M JDK8,
8-8) sqldeveloper-23.1.1.345.2114-macos-x64.app.zip -505M JDK8,
==at[ C:\_SQLdeveloper\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf ]==
# Languages (korea: insert # at front of following 2 lines) <-> (english: delete the # of following 2 lines)
# AddVMOption -Duser.language=en
# AddVMOption -Duser.country=US
[[Data Modeler]]
DM-1) _datamodeler-23.1.0.087.0806-x64.zip 284m
DM-2) erd작성하기 1K
DM-3) StarUML Setup 3.1.0.exe 개발툴 -110M
DM-4) ToadDataModeler_freeware_4.1.5.9.msi 70m
Installation Guide.pdf 0.5m
DM-5) ToadDataModeler_7.0.0.72_x64_En.msi 모델러 95m
DM-6) ToadForOracle_Trial_13.1.1.5_x86_En.msi 개발툴 -130M
DM-7) ToadForOracle_Trial_13.1.1.5_x64_En.msi 개발툴 -150M
DM-11) Oracle SQL Data Modeler 사용설명서 2장.hwp 샘플
DM-12) e13677-oracle data modeler Guide.pdf 사용자설명서
DM-13) Create Database design in Oracle SQL Developer Data Modeler (720p).mp4 동영상
DM-14) IE표기-Barker표기.hwp
DM-15) _IE-Barker 표기정리.hwp
9) https://aquerytool.com/ -, 웹ERD+SQL생성
9-1) Printer-삼성CLX-6250.zip -, 28M
9-2) table_exam-v2.txt -, 28M
9-3) 04_SELECT구조-20160323.hwp -, 28M
9-4) 관계 해석.hwp -, 2M
9-5) 05_Click_Screen_Timer.zip - 22k
12-2) VB6-155_0000806.zip - 300m
12-3) vs2008pro_cdKey.zip - 3.8GB
12-4) vs2017_community - 1MB
12-5) ODTforVS2017_183000.exe - 70MB
13) erwin64bit2020R2.exe - 500m
erWin-License 1 year.txt -to2022.11.11
14) DB.Browser.for.SQLite-3.12.2-win32.msi - 15m
20) ZoomIt.exe -0.5M , 화면확대 프로그램
20) Chrome.exe -0.5M , 웹브라우저 프로그램
◎[Web개발도구] ===================
httpd-2.2.25-win32-x86-no_ssl.msi 아파치웹서버 5m
_크롬에서-유투브다운로드방법.hwp 유투브다운로드방법
◎[책부록] ===================
8) JSP 부록 CD삼양.zip -, 521M
12-1) BooksVB6-삼양출판.zip - 193m
demobld.txt
◎[MacOs] ===================
91) datamodeler-23.1.0.087.0806-macosx.app.zip 290M
92) sqldeveloper-23.1.1.345.2114-macos-x64.app.zip 450M