|
[»ó] Oracle 11g ÇÁ·Î±×·¡¹Ö
-
- ±¸ÀÔ¿¬µµ
- È®ÀξȵÊ
- ÃâÆÇ¿¬µµ
- Ç¥±â¾øÀ½
-
- ÃâÆÇ»ç
- ºÏ½ºÈ¦¸¯
- ISBN
- 9788994914466
-
- ÀúÀÚ
- ¼ºÀ±Á¤
-
- µµ¼Á¤º¸
- 464 , 182x257(B5»ç·ú¹è) , 2011.11.22
-
- µµ¼µî±Þ
- »ó
-
- Á¤°¡
-
23,000¿ø (82.6%¡é)
-
- ÆǸŰ¡
-
4,000¿ø
(¼Òµæ°øÁ¦ÇýÅÃ: 180¿ø ÀÚ¼¼È÷)
-
- ¹è¼Ûºñ
-
¹«·á ¡ 3,000¿ø
±¸¸Å ÃѾ׿¡ µû¶ó ¹è¼Ûºñ°¡ ´Þ¶óÁý´Ï´Ù.
3000¿ø |
ÆǸÅÀÚ »óÇ° 35,000 ¹Ì¸¸ ±¸¸Å |
¹«·á |
ÆǸÅÀÚ »óÇ° 35,000 ÀÌ»ó ±¸¸Å |
|
ÀÌ ÆǸÅÀÚÀÇ »óÇ° ´õº¸±â +
toribook
°³Àλç¾÷ÀÚ
ÆǸŵµ¼ : 14,945 °Ç
¿¬¶ôó :
010-2561-8398 ÁÖ¼Ò : °æ³² ¾ç»ê½Ã ¿¬È£9±æ 15-5 (»ïÈ£µ¿)
¹è¼Û·á : Á¶°ÇºÎ ¹«·á (35,000¿ø ¹Ì¸¸ 3,000¿ø)
|
|
Chapter 01_¿À¶óŬ°ú µ¥ÀÌÅͺ£À̽º SECTION 01 µ¥ÀÌÅͺ£À̽º °ü¸® ½Ã½ºÅÛÀ̶õ? SECTION 02 ¿À¶óŬ ¼³Ä¡ SECTION 03 SQL°ú µ¥ÀÌÅÍ Á¶È¸Çϱâ SECTION 04 DUAL Å×À̺í
Chapter 02_µ¥ÀÌÅÍ Á¶È¸Çϱâ SECTION 01 WHERE ÀýÀ» ÀÌ¿ëÇÑ Á¶°Ç °Ë»ö SECTION 02 Á¤·ÄÀ» À§ÇÑ ORDER BY Àý
Chapter 03_SQL/PLUS SECTION 01 SQL*Plus ¸í·É¾îÀÇ °³³ä SECTION 02 SQL*Plus ÆíÁý ¹× ½ÇÇà ¸í·É SECTION 03 SQL*Plus ÆÄÀÏÁ¶ÀÛ ¸í·É¾î SECTION 04 SQL*Plus Çü½Ä ¸í·É¾î
Chapter 04_´Ù¾çÇÑ ÇÔ¼ö SECTION 01 ¹®ÀÚ ÇÔ¼ö SECTION 02 ¼ýÀÚ ÇÔ¼ö SECTION 03 ³¯Â¥ ÇÔ¼ö SECTION 04 Çü º¯È¯ ÇÔ¼ö SECTION 05 ÀÏ¹Ý ÇÔ¼ö
Chapter 05_±×·ìÇÔ¼ö »ç¿ëÇϱâ SECTION 01 ±×·ìÇÔ¼ö SECTION 02 µ¥ÀÌÅÍ ±×·ì : GROUP BY SECTION 03 ±×·ì °á°ú Á¦ÇÑ : HAVING Àý
Chapter 06_Å×À̺í Á¶ÀÎÇϱâ SECTION 01 Á¶ÀÎ SECTION 02 EQUI JOIN SECTION 03 NON-EQUI JOIN SECTION 04 SELF JOIN SECTION 05 OUTER JOIN
Chapter 07_¼ºê Äõ¸® SECTION 01 ¼ºê Äõ¸®ÀÇ ±âº» °³³ä SECTION 02 ´ÙÁß Çà ¼ºê Äõ¸®
Chapter 08_Å×ÀÌºí »ý¼º /¼öÁ¤/Á¦°ÅÇϱâ SECTION 01 Å×ÀÌºí ±¸Á¶¸¦ ¸¸µå´Â CREATE TABLE ¹® SECTION 02 Å×ÀÌºí ±¸Á¶¸¦ º¯°æÇÏ´Â ALTER TABLE ¹® SECTION 03 Å×À̺í¸íÀ» º¯°æÇÏ´Â RENAME ¹® SECTION 04 Å×ÀÌºí ±¸Á¶¸¦ Á¦°ÅÇÏ´Â DROP TABLE ¹® SECTION 05 Å×À̺íÀÇ ¸ðµç µ¥ÀÌÅ͸¦ Á¦°ÅÇÏ´Â TRUNCATE TABLE ¹® SECTION 06 µ¥ÀÌÅÍ »çÀü
Chapter 09_µ¥ÀÌÅÍ Á¶ÀÛ°ú Æ®·£Àè¼Ç SECTION 01 Å×ÀÌºí¿¡ ³»¿ëÀ» Ãß°¡ÇÏ´Â INSERT ¹® SECTION 02 Å×À̺íÀÇ ³»¿ëÀ» ¼öÁ¤ÇÏ´Â UPDATE ¹® SECTION 03 Å×À̺íÀÇ ³»¿ëÀ» »èÁ¦ÇÏ´Â DELETE ¹® SECTION 04 Æ®·£Àè¼Ç °ü¸®
Chapter 10_µ¥ÀÌÅÍ ¹«°á¼º°ú Á¦¾à Á¶°Ç SECTION 01 Á¦¾à Á¶°Ç SECTION 02 Á¦¾à Á¶°Ç º¯°æÇϱâ SECTION 03 Á¦¾à Á¶°Ç È°¼ºÈ ¹× ºñÈ°¼ºÈ
Chapter 11_ºä SECTION 01 ºäÀÇ °³³ä°ú ºä »ç¿ëÇϱâ SECTION 02 ´Ù¾çÇÑ ºä ¿É¼Ç
Chapter 12_½ÃÄö½º¿Í À妽º SECTION 01 ½ÃÄö½º »ý¼º SECTION 02 ½ÃÄö½º ¼öÁ¤ ¹× Á¦°Å SECTION 03 Á¶È¸½Ã ¼º´É Çâ»óÀ» À§ÇÑ À妽º SECTION 04 À妽ºÀÇ Á¾·ù
Chapter13_»ç¿ëÀÚ ±ÇÇÑ SECTION 01 »ç¿ë ±ÇÇÑ SECTION 02 ·ÑÀ» »ç¿ëÇÑ ±ÇÇÑ ºÎ¿© SECTION 03 µ¿ÀǾî
Chapter 14_PL/SQL SECTION 01 PL/SQL SECTION 02 º¯¼ö ¼±¾ð SECTION 03 Á¦¾î¹® SECTION 04 Ä¿¼
Chapter 15_ÇÁ·Î½ÃÀú¿Í ÇÔ¼ö¿Í Æ®¸®°Å SECTION 01 ÇÁ·Î½ÃÀú SECTION 02 ÇÔ¼ö SECTION 03 Æ®¸®°Å
Chapter 16_µ¥ÀÌÅͺ£À̽º ¼³°è SECTION 01 µ¥ÀÌÅͺ£À̽º ¼³°è SECTION 02 ERwinÀ¸·Î ³í¸®Àû ¸ðµ¨¸µ SECTION 03 ERwinÀ¸·Î ¹°¸®Àû ¸ðµ¨¸µ SECTION 04 µ¥ÀÌÅͺ£À̽º ±¸Ãà SECTION 05 SQL ¹® »ç¿ëÇϱâ
µ¥ÀÌÅͺ£À̽º¸¦ óÀ½ ÇнÀÇÏ´Â Ãʺ¸ÀÚ°¡ Á¦ÀÏ ¸ÕÀú °í¹ÎÇÏ°Ô µÇ´Â ºÎºÐÀº ¡°¾î¶² Ã¥À¸·Î ¾î¶»°Ô °øºÎÇÏ´À³Ä?¡±ÇÏ´Â °ÍÀÔ´Ï´Ù. ÀÌ Ã¥À» ¾²°Ô µÈ °è±â´Â ¿À¶óŬÀ» º¸´Ù ´Ü½Ã°£¿¡ È¿°úÀûÀ¸·Î ÇнÀÇÏ´Â ¹æ¹ýÀ» Á¦½ÃÇØ º¸ÀÚ´Â Àǹ̿¡¼ ¾²°Ô µÇ¾ú½À´Ï´Ù. µû¶ó¼ ÀÌ Ã¥Àº µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ Àü¹ÝÀûÀÎ °³³ä°ú ÇÔ²² SQLÀ» óÀ½ °øºÎÇÏ´Â Ãʺ¸ÀÚ¸¦ ´ë»óÀ¸·Î ±¸¼ºÇÏ¿´½À´Ï´Ù.
SQLÀ» Á¤È®ÇÏ°Ô ÀÌÇØÇÏ°Ô ÇÏ°í ÀÌÇØÇÑ ºÎºÐÀº È¥ÀÚÇغ¸±â¿¡ ³ª¿À´Â ´Ù¾çÇÑ ÇüÅÂÀÇ ¿¹Á¦¸¦ Çϳª µÑ Á÷Á¢ ÀÛ¼ºÇÏ°í °á°ú¸¦ È®ÀÎÇØ °¡¸é¼, SQLÀÇ ±âÃʺÎÅÍ PL/SQLÀÇ ±âÃʱîÁö¸¦ ÀÍÈ÷´Â °ÍÀ» ¸ñÇ¥·Î ÇÏ°í ÀÖ½À´Ï´Ù. µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ °³³äÀÌ ÀüÇô ¾ø´Â Ãʺ¸ÀÚ¶óµµ ¾î·ÆÁö ¾ÊÀº ¿ë¾î¿Í °ÀǽÄÀ¸·Î Ç®¾î¾´ ¼³¸íÀ» ÅëÇØ Á» ´õ ½±°Ô µ¥ÀÌÅͺ£À̽º¿¡ ÀÔ¹®ÇÒ ¼ö ÀÖµµ·Ï ¾È³»ÇÏ°í ÀÖ½À´Ï´Ù. ¶ÇÇÑ ½±°í Àç¹ÌÀÖ´Â ¿¹Á¦¸¦ ÅëÇØ ÇнÀÇØ ³ª°¡¸é¼ SQL°ú PL/SQL¿¡ ´ëÇÑ ±âÃʸ¦ Æ°Æ°È÷ ´ÙÁ® µ¥ÀÌÅͺ£À̽º ½Ç·ÂÀ» Çâ»óÇÒ ¼ö ÀÖµµ·Ï µµ¿òÀ» ÁÙ °ÍÀÔ´Ï´Ù.
|
µ¿ÀÏÇÑ µµ¼¸íÀÇ Á¦Ç°À» ÆǸÅÇÏ´Â ´Ù¸¥ ÆǸÅÀÚÀÇ ÁÖ¹®³»¿ªµµ Æ÷ÇԵǾî ÀÖ½À´Ï´Ù.
|
|
|
|
|