°³¶ËÀ̳׿¡¼ ÆÇ¸ÅµÈ "Oracle 11g ÇÁ·Î±×·¡¹Ö" Á¤°¡ 23,000¿ø Æò±ÕÇÒÀΰ¡
|
|
|
ÃÑ 6°³ÀÇ µµ¼°¡ ÀÖ½À´Ï´Ù.
µµ¼À̹ÌÁö |
µµ¼¸í |
»óÅÂ |
°¡°Ý |
ÆǸÅÀÚ |
|
|
Oracle 11g ÇÁ·Î±×·¡¹Ö
|
»ó
|
3,000¿ø
40,000 ¹Ì¸¸ ¹è¼Ûºñ3,500
|
|
|
|
|
Oracle 11g ÇÁ·Î±×·¡¹Ö
|
»ó
|
4,000¿ø
35,000 ¹Ì¸¸ ¹è¼Ûºñ3,000
|
|
|
|
|
Oracle 11g ÇÁ·Î±×·¡¹Ö
|
Áß
|
4,150¿ø
50,000 ¹Ì¸¸ ¹è¼Ûºñ3,000
|
|
|
|
|
Oracle 11g ÇÁ·Î±×·¡¹Ö
|
ÃÖ»ó
|
6,000¿ø
30,000 ¹Ì¸¸ ¹è¼Ûºñ4,000
|
|
|
|
|
Oracle 11g ÇÁ·Î±×·¡¹Ö
|
»õÃ¥
|
|
|
|
|
|
Oracle 11g ÇÁ·Î±×·¡¹Ö
|
»õÃ¥
|
|
|
|
|
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¿¡ ´ëÇÑ ±âÃʸ¦ Æ°Æ°È÷ ´ÙÁ® µ¥ÀÌÅͺ£À̽º ½Ç·ÂÀ» Çâ»óÇÒ ¼ö ÀÖµµ·Ï µµ¿òÀ» ÁÙ °ÍÀÔ´Ï´Ù.
|
|
|
|
|