Àå
|
Ã¥ ¸ñÂ÷
|
ÁÖ ³»¿ë
|
¼³Ä¡ ¹× ÇÁ·Î±×·¥
|
1Àå
|
µ¥ÀÌÅͺ£À̽º ½Ã½ºÅÛÀÇ °³¿ä
|
- µ¥ÀÌÅͺ£À̽º °³³ä- DBMS
* °ÀǼҿä½Ã°£(1ÁÖ)
|
- ¸¶´ç¼Á¡ C ÇÁ·Î±×·¥(ÆÄÀÏ µ¥ÀÌÅÍ)-¸¶´ç¼Á¡.zip
|
2Àå
|
°ü°è µ¥ÀÌÅÍ ¸ðµ¨
|
- ¸±·¹À̼Ç
- °ü°è´ë¼ö
* °ÀǼҿä½Ã°£(1-2ÁÖ)
|
- (¾øÀ½)
|
3Àå
|
SQL ±âÃÊ
|
- Oracle ¼³Ä¡
- SQL °³¿ä
- SQL ½Ç½À
* °ÀǼҿä½Ã°£(2-3ÁÖ)
|
- [Oracle 11gr2] - À©µµ¿ì 64bit ¹öÀü
1¹ø ÆÄÀÏ : win64_11gR2_database_1of2.zip
2¹ø ÆÄÀÏ : win64_11gR2_database_2of2.zip
- [Oracle 11gr2] - À©µµ¿ì 32bit ¹öÀü
1¹ø ÆÄÀÏ : win32_11gR2_database_1of2.zip
2¹ø ÆÄÀÏ : win32_11gR2_database_2of2.zip
- [Oracle 11g Express] - OracleXE112_Win64.zip(64bit)
- [Oracle 18c Express] - OracleXE184_Win64(64bit)
- [SQL Developer with Java] - sqldeveloper-4.1.5.21.78-x64
- [Oracle 11g Express 32bit] - OracleXE112_Win32.zip(32bit)
- [madang °èÁ¤ ¹× ¸¶´ç µ¥ÀÌÅͺ£À̽º »ý¼º] - demo_madang.sql
[scott °èÁ¤ ¹× emp/dept µ¥ÀÌÅͺ£À̽º »ý¼º] - demo_scott.sql
- [3Àý DML-SELECT] –chap03-3Àý.sql
- [4Àý DDL] –chap03-4Àý.sql
- [5Àý DML] –chap03-5Àý.sql
- ¿¬½À¹®Á¦ –
|
4Àå
|
4Àå SQL °í±Þ
|
- ÇÔ¼ö
- View
- Index
* °ÀǼҿä½Ã°£(1ÁÖ)
|
- [4Àå ½Ç½À] – chap04.sql
- [Mybook Å×À̺í] - mybook.sql
- [¸¶´ç µ¥ÀÌÅͺ£À̽º Å×ÀÌºí ¹× µ¥ÀÌÅÍ ÃʱâÈ] - demo_madang_init.sql
|
5Àå
|
µ¥ÀÌÅͺ£À̽º ÇÁ·Î±×·¡¹Ö
|
- PL/SQL
- Java
- JSP
* °ÀǼҿä½Ã°£(»ý·« ȤÀº 1ÁÖ Á¤µµ)
|
- [¿¹Á¦5-1] - InsertBook.sql
- [¿¹Á¦5-2] - BookInsertOrUpdate.sql
- [¿¹Á¦5-3] - AveragePrice.sql
- [¿¹Á¦5-4] - Interest.sql
- [¿¹Á¦5-5] - AfterInsertBook.sql
- [¿¹Á¦5-6] - fnc_Interest.sql
|
- [3Àý] ÀÚ¹Ù - booklist.java (oracle 11c)
- ÀÚ¹Ù ÄÄÆÄÀÏ·¯(ºÎ·Ï ÂüÁ¶)
- JDBC µå¶óÀ̹ö ojdbc6.jar (ºÎ·ÏÂüÁ¶)
- ÀÌŬ¸³½º - Eclipse(ºÎ·Ï ÂüÁ¶)
- [3Àý] ÀÚ¹Ù - Oracle 12c, 18c ¹öÀü
- booklist.java
- ÀÚ¹Ù ÄÄÆÄÀÏ·¯
- JDBC µå¶óÀ̹ö ojdbc8.jar
- ÀÌŬ¸³½º - Eclipse(ºÎ·Ï ÂüÁ¶)
|
- [4Àý] JSP - booklist.jsp, bookview.jsp
- ÅèĹ - Tomcat(ºÎ·ÏÂüÁ¶)
- [4Àý] JSP - booklist.jsp, bookview.jsp (Oracle 12c, 18c ¹öÀü)
(jsp ÆÄÀϳ»¿¡ user À̸§¿¡ c##madang À¸·Î º¯°æÇÑ ÆÄÀÏ)
- ÅèĹ - Tomcat(ºÎ·ÏÂüÁ¶)
(ÁÖ) ojdbc8.jar ÆÄÀÏÀ» Tomcat ÇÁ·ÎÁ§Æ®ÀÇ Webcontents/web-inf/lib ¿¡ º¹»ç
|
6Àå
|
µ¥ÀÌÅÍ ¸ðµ¨¸µ
|
- ER ¸ðµ¨
- IE ¸ðµ¨
- ERwin ½Ç½À
* °ÀǼҿä½Ã°£(2ÁÖ)
|
- ERwin ¼ÒÇÁÆ®¿þ¾î - ERwin Academic ¹öÀü
(academic ¹öÀüÀÇ license code¸¦ À» ¸ÞÀÏ·Î ¿äûÇÏ¿© ¹Þ¾Æ¾ßÇÔ)
- ¸¶´ç¼Á¡ ERwin - madangbookstore.erwin
- ¸¶´ç´ëÇÐ ERwin - madanguniv.erwin
|
7Àå
|
Á¤±ÔÈ
|
- ÀÌ»óÇö»ó
- ÇÔ¼öÁ¾¼Ó¼º
- Á¤±ÔÇü
* °ÀǼҿä½Ã°£(2ÁÖ)
|
- 7Àå Àüü SQL ½ºÅ©¸³Æ® - ch07.sql
|
8Àå
|
Æ®·£Àè¼Ç
|
- Æ®·£Àè¼Ç °³³ä
- µ¿½Ã¼ºÁ¦¾î
- ȸº¹¾Ë°í¸®Áò
* °ÀǼҿä½Ã°£(2ÁÖ)
|
- 8Àå Àüü SQL ½ºÅ©¸³Æ® - ZIP ÆÄÀÏ(8Àå Àüü)
- [¸¶´ç µ¥ÀÌÅͺ£À̽º Å×ÀÌºí ¹× µ¥ÀÌÅÍ ÃʱâÈ] - demo_madang_init.sql
|
9Àå
|
º¸¾È°ú±ÇÇÑ, ¹é¾÷°úº¹¿ø
|
- º¸¾È°ú±ÇÇÑ
- ¹é¾÷°úº¹¿ø
* °ÀǼҿä½Ã°£(1ÁÖ)
|
- 9Àå Àüü SQL ½ºÅ©¸³Æ® - ch09.sql
|