±¹³»µµ¼
Àü°øµµ¼/´ëÇб³Àç
°øÇаè¿
ÄÄÇ»ÅÍ°øÇÐ
Á¤°¡ |
32,000¿ø |
---|
28,800¿ø (10%ÇÒÀÎ)
1,600P (5%Àû¸³)
ÇÒÀÎÇýÅÃ | |
---|---|
Àû¸³ÇýÅà |
|
|
|
Ãß°¡ÇýÅÃ |
|
À̺¥Æ®/±âȹÀü
¿¬°üµµ¼
»óÇ°±Ç
ÀÌ»óÇ°ÀÇ ºÐ·ù
Ã¥¼Ò°³
½Ç½ÀÀ¸·Î Å͵æÇÏ´Â ¡ºOracle SQL ½ÇÀüÆ©´× ±âº»Çعý¡». SQL Æ©´×À» ¸öÀ¸·Î °æÇèÇÏ°Ô ±¸¼ºµÇ¾î ÀÖ´Ù. Æ©´× µµ±¸, ½ÇÇà °èȹ ºÐ¼®, ¼ºê Äõ¸®, ½ÇÇà °èȹ ºÐ¸®, ±âŸ ÀÀ¿ë Æ©´×, Æ©´× ½Ç¹« »ç·Ê µîÀ¸·Î ±¸¼ºÇß´Ù.
ÃâÆÇ»ç ¼Æò
ÀÌ·Ð VS °æÇè
ÀϹÝÀûÀ¸·Î Ã¥À̶õ ´«À¸·Î Àаí, ¸Ó¸®·Î ÀÌÇØÇÏ¸é ³¡À̶ó°í »ý°¢ÇÑ´Ù. ÇÏÁö¸¸ ÀÌ·± »ý°¢ ¶§¹®¿¡ ¸¹Àº ¹®Á¦°¡ ¹ß»ýÇÑ´Ù. ¿Ö³ÄÇÏ¸é ¸·»ó Æ©´× ÇÁ·ÎÁ§Æ®¿¡ »ç¶÷À» ÅõÀÔÇÏ·Á°í Çϸé, Àû´çÇÑ »ç¶÷ÀÌ ¾ø±â ¶§¹®ÀÌ´Ù. Æ©´× Ã¥À» ÀÐÀº »ç¶÷Àº ¸¹Àºµ¥, Æ©´× °æÇèÀÌ ¾ø°Å³ª ªÀº »ç¶÷ÀÌ ¸¹´Ù´Â ¶æÀÌ´Ù. Æ©´× ÄÁ¼³ÅÏÆ®´Â Àü¹®°¡ÀÌ´Ù. Æ©´× °æÇèÀÌ ¾ø´Â »ç¶÷À» ¸íÇÔ¸¸ Æļ Àü¹®°¡¶ó°í ÇÒ ¼ö´Â ¾ø´Â ³ë¸©ÀÌ´Ù. ÀÌ Ã¥ÀÇ ¸ñÀûÀº ´ç½ÅÀ» Æ©´× °æÇèÀÚ·Î ¸¸µå´Â °ÍÀÌ´Ù. µû¶ó¼ ¸Ó¸®·Î¸¸ ÀÌÇØÇÏ´Â ´Ù¸¥ Ã¥µé°ú´Â ´Þ¸®, SQL Æ©´×À» ¸öÀ¸·Î °æÇèÇÏ°Ô ±¸¼ºµÇ¾î µÇ¾îÀÖ´Ù.¸¸ÀÏ Æ©´× ÇÁ·ÎÁ§Æ® °æÇèÀÌ ¾ø´Â ´ç½ÅÀÌ ÇÑ´Þ µÚ¿¡ Æ©´× ÇÁ·ÎÁ§Æ®¿¡ ÅõÀÔµÈ´Ù¸é °¡´ÉÇÑ »¡¸® ÀÌ Ã¥À¸·Î °æÇèÀ» ½ÃÀÛÇØ¾ß ÇÑ´Ù. ¿Ö³ÄÇϸé ÀåÀο¡°Ô ½Ç·ÂÀ̶õ °æÇè ȤÀº °æ·ÂÀ̱⠶§¹®ÀÌ´Ù.
[µµ¼ ±¸¼º]
À̷аú ½Ç½ÀÀ» ÅëÇØ ¿À¶óŬ SQL ½ÇÀü Æ©´×¿¡ ÇÊ¿äÇÑ ±âº»±â¸¦ Å͵æÇÏÀÚ.
ÀÌ Ã¥¿¡¼ »ç¿ëÇÑ »ùÇà ½ºÅ°¸¶ µ¥ÀÌÅÍ¿Í SQL ½ºÅ©¸³Æ®´Â ÇÊÀÚÀÇ BLOG (BLOG.NAVER.COM/CYSZERO7)¸¦ ÅëÇØ Á¦°øµÇ±â ¶§¹®¿¡ Á÷Á¢ ½Ç½ÀÀ» ÅëÇÑ ÇнÀÀÌ °¡´ÉÇÏ´Ù. ÀÌ Ã¥¿¡¼ ´Ù·ç´Â ³»¿ëÀº ¾Æ·¡¿Í °°´Ù.
1. Æ©´×µµ±¸
2. ½ÇÇà °èȹ ºÐ¼®
3. Æ©´× ´ë»ó SQL ÃßÃâ ¹× Æ©´× ¹æ¾È
4. INDEX
5. JOIN
6. ¼ºêÄõ¸®
7. Ç¥ÁØ PAGENATION
8. µ¿ÀÏ µ¥ÀÌÅÍ ¹Ýº¹ ACCESS Æ©´×
9. ½ÇÇà °èȹ ºÐ¸®
10. PGA Æ©´×
11. ±âŸ ÀÀ¿ë Æ©´×
12. Æ©´× ½Ç¹« »ç·Ê
ºÎ·Ï1. Á¤±Ô½Ä
ºÎ·Ï2. ROLLUP, CULE, GROUPING SETS
ºÎ·Ï3. Æ©´× ´ë»ó SQL ÃßÃâ
¸ñÂ÷
1.Æ©´× µµ±¸
1.1 DBMS_XPLAN.DISPLAY_CURSOR
1.2 DBMS_XPLAN.DISPLAY_AWR
1.3 SQL_MONITOR
2. ½ÇÇà °èȹ ºÐ¼®
2.1 ½ÇÇà °èȹ ¼ø¼ ±âº» ºÐ¼®¹ý
2.1 ½ÇÇà °èȹ ¼ø¼ ¿¹¿Ü »çÇ× ºÐ¼®¹ý
3. Æ©´× ´ë»ó SQL ÃßÃâ ¹× Æ©´× ¹æ¾È
3.1 AWR µ¥ÀÌÅ͸¦ ÀÌ¿ëÇÑ TOP SQL ÃßÃâ
3.2 ÇöÀç »óÅÂÀÇ TOP SQL ÃßÃâ
3.3 ±âŸ Æ©´× ´ë»ó SQL ÃßÃâ ¹æ¹ý ¼Ò°³
Operating System Statistics - Detail
3.4 °³¹ß ȯ°æ¿¡¼ÀÇ Æ©´×
3.5 ¿î¿µ ȯ°æ¿¡¼ÀÇ Æ©´×
4. INDEX
4.1 B-TREE INDEX ±¸Á¶
4.2 INDEX RANGE SCAN
4.3 INDEX RANGE SCAN DESCENDING
4.4 INDEX RANGE SCAN(MIN/MAX)
4.5 INDEX Ä÷³ °¡°ø
4.6 CLUSTERING FACTOER
4.7 INDEX RANGE SCAN VS FULL TABLE SCAN
4.8 INDEX ACCESS Á¶°Ç, FILTER Á¶°Ç, ¼±Åõµ
4.9 INDEX SKIP SCAN
4.11 INDEX FULL SCAN(MIN/MAX)
4.12 INDEX FAST FULL SCAN
4.13 INDEX COMBINATION
4.14 INDEX JOIN
4.15 INDEX COMBINE°ú INDEX JOINÀÇ Â÷ÀÌÁ¡ ºñ±³
4.16 INDEX FILTERING È¿°ú
5. JOIN
5.1 NESTED LOOP JOIN
5.2 HASH JOIN
5.3 SORT MERGE JOIN
5.4 JPPD(Join Predicate Push Down)
5.5 Á¶ÀÎ ¼ø¼°¡ ¼º´É¿¡ ¹ÌÄ¡´Â ¿µÇâ
6. ¼ºêÄõ¸®
6.1 FILTER ¼ºêÄõ¸®
6.2 EARLIER FILTER ¼ºê Äõ¸®
6.3 NL SEMI / ANTI JOIN
6.4. »ó°ü°ü°è ¼ºêÄõ¸®(FILTER, NL SEMI Á¶ÀÎ) È°¿ë
6.5 HASH SEMI / ANTI JOIN
6.6 SORT MERGE SEMI / ANTI JOIN
6.7 ½ºÄ®¶ó ¼ºêÄõ¸®
6.8 ºñ »ó°ü°ü°è ¼ºêÄõ¸®(Á¦°øÀÚ ¼ºêÄõ¸®)
7. Ç¥ÁØ PAGENATION
7.1 ºÎºÐ ¹üÀ§ ó¸®, Àüü ¹üÀ§ ó¸®
7.2 Ç¥ÁØ PAGENATION »ç¿ë ¹æ¹ý
7.3 Ç¥ÁØ PAGENATION »ç¿ë - ÃÖÀûÀÇ INDEX Á¸Àç
7.4 Ç¥ÁØ PAGENATION »ç¿ë - ÃÖÀûÀÇ À妽º ¾øÀ½
7.5 Ç¥ÁØ PAGENATION »ç¿ë - ó¸® ¼ø¼
7.6 PAGING ó¸® ÀÀ¿ë
7.7 À¥ °Ô½ÃÆÇ ÇüÅ¿¡¼ PAGING ó¸®
8. µ¿ÀÏ µ¥ÀÌÅÍ ¹Ýº¹ ACCESS Æ©´×
8.1 ¼ºêÄõ¸® OR ÀζóÀκ並 ÅëÇÑ ¹Ýº¹ ACCESS - ºÐ¼® ÇÔ¼ö È°¿ë
8.2 UNION ALL ¹Ýº¹ ACCESS - SQL ÅëÇÕ
8.4 UNION ALL ¹Ýº¹ ACCESS - ¼Ò°è ó¸® ÇÔ¼öÀÇ È°¿ë
8.5 UNION ALL ¹Ýº¹ ACCESS - WITH ¹®ÀÇ È°¿ë
8.6 UPDATE ¹® ¼ºê Äõ¸® ÅëÇÑ ¹Ýº¹ ACCESS - MERGE¹® È°¿ë
8.7 MERGE ´ë»ó Å×ÀÌºí ¹Ýº¹ ACCESS
9. ½ÇÇà °èȹ ºÐ¸®
9.1 CONCATNATIONÀ» ÀÌ¿ëÇÑ ½ÇÇà°èȹ ºÐ¸®
9.2 UNION ALLÀ» ÀÌ¿ëÇÑ ½ÇÇà°èȹ ºÐ¸®
10. PGA Æ©´×
10.1 SORT ORDER BY
10.2 SORT ORDER BY & SORT ORDER BY STEOPKEY (STOPKEY)
10.3 SORT GROUP BY & HASH GROUP BY
10.4 SORT UNIQUE & HASH UNIQUE
10.5 HASH JOIN, HASH SEMI JOIN & HASH ANTI JOIN
10.6 SORT MERGE JOIN, MERGE SEMI JOIN & MERGE ANTI JOIN
11. ±âŸ ÀÀ¿ë Æ©´×
11.1 ¿©·¯ Çà -> ÇÑ °³ÀÇ Çà, ¿·Î ¹±â
11.2 ÇÑ °³ÀÇ Çà, ¿·Î ¹ÀÎ µ¥ÀÌÅÍ -> ¿©·¯ ÇàÀ¸·Î ºÐ¸®
11.3 Çà(ROW)°£ÀÇ ´©Àû °ö
11.4 Ä«Å×½Ã¾È Á¶ÀÎ ÀÀ¿ë - ÀÏ, ÁÖ, ¿ù ÇöȲ
11.5 INDEX Á¶ÀÎ ÀÀ¿ë
11.6 OUTLINE Á¤º¸¸¦ ÀÌ¿ëÇÑ Æ©´×
12. Æ©´× ½Ç¹« »ç·Ê
12.1 °ü·Ã´Ü¿ø - 4.INDEX
12.2 °ü·Ã´Ü¿ø - 4.INDEX
12.3 °ü·Ã´Ü¿ø - 5.JOIN
12.4 °ü·Ã´Ü¿ø - 5.JOIN(JPPD)
12.5 °ü·Ã´Ü¿ø - 6.¼ºêÄõ¸®
12.7 °ü·Ã´Ü¿ø - 9.½ÇÇà °èȹ ºÐ¸®
12.8 °ü·Ã´Ü¿ø - 5.JOIN, 9.½ÇÇà °èȹ ºÐ¸®
12.9 °ü·Ã´Ü¿ø - 6.¼ºêÄõ¸®, 10.PGAÆ©´×
12.10 °ü·Ã´Ü¿ø - 5.JOIN, 6.¼ºêÄõ¸®, 10.PGA Æ©´×
12.11 °ü·Ã´Ü¿ø - 8.µ¿ÀÏ µ¥ÀÌÅÍ ¹Ýº¹ ACCESS Æ©´×
12.12 °ü·Ã´Ü¿ø - 4.INDEX, 7.Ç¥ÁØ PAGENATION
ºÎ·Ï 1.REGULAR EXPRESSION(Á¤±Ô½Ä)
1.1 ¸ÞŸ¹®ÀÚ
1.2 REGEXP_LIKE
1.3 REGEXP_REPLACE
1.4 REGEXP_INSTR 310
1.5 REGEXP_SUBSTR
1.6 REGEXP_COUNT
1.7 CHECK CONSTRAINT¿¡¼ Á¤±Ô½Ä »ç¿ë
ºÎ·Ï 2.ROLLUP, CUBE, GROUPING SETS
2.1 ROLLUP, CUBE
2.2 GROUPING SETS
ºÎ·Ï 3.Æ©´× ´ë»ó SQL ÃßÃâ
3.1 AWR DINCTIONARY TABLE ÀÌ¿ë
3.2 GV$SQL(V$SQL) TABLEÀÌ¿ë
ÀúÀÚ¼Ò°³
»ý³â¿ùÀÏ | - |
---|
ÇØ´çÀÛ°¡¿¡ ´ëÇÑ ¼Ò°³°¡ ¾ø½À´Ï´Ù.
ÁÖ°£·©Å·
´õº¸±â»óÇ°Á¤º¸Á¦°ø°í½Ã
À̺¥Æ® ±âȹÀü
Àü°øµµ¼/´ëÇб³Àç ºÐ¾ß¿¡¼ ¸¹Àº ȸ¿øÀÌ ±¸¸ÅÇÑ Ã¥
ÆǸÅÀÚÁ¤º¸
»óÈ£ |
(ÁÖ)±³º¸¹®°í |
---|---|
´ëÇ¥ÀÚ¸í |
¾Èº´Çö |
»ç¾÷ÀÚµî·Ï¹øÈ£ |
102-81-11670 |
¿¬¶ôó |
1544-1900 |
ÀüÀÚ¿ìÆíÁÖ¼Ò |
callcenter@kyobobook.co.kr |
Åë½ÅÆǸž÷½Å°í¹øÈ£ |
01-0653 |
¿µ¾÷¼ÒÀçÁö |
¼¿ïƯº°½Ã Á¾·Î±¸ Á¾·Î 1(Á¾·Î1°¡,±³º¸ºôµù) |
±³È¯/ȯºÒ
¹ÝÇ°/±³È¯ ¹æ¹ý |
¡®¸¶ÀÌÆäÀÌÁö > Ãë¼Ò/¹ÝÇ°/±³È¯/ȯºÒ¡¯ ¿¡¼ ½Åû ¶Ç´Â 1:1 ¹®ÀÇ °Ô½ÃÆÇ ¹× °í°´¼¾ÅÍ(1577-2555)¿¡¼ ½Åû °¡´É |
---|---|
¹ÝÇ°/±³È¯°¡´É ±â°£ |
º¯½É ¹ÝÇ°ÀÇ °æ¿ì Ãâ°í¿Ï·á ÈÄ 6ÀÏ(¿µ¾÷ÀÏ ±âÁØ) À̳»±îÁö¸¸ °¡´É |
¹ÝÇ°/±³È¯ ºñ¿ë |
º¯½É ȤÀº ±¸¸ÅÂø¿À·Î ÀÎÇÑ ¹ÝÇ°/±³È¯Àº ¹Ý¼Û·á °í°´ ºÎ´ã |
¹ÝÇ°/±³È¯ ºÒ°¡ »çÀ¯ |
·¼ÒºñÀÚÀÇ Ã¥ÀÓ ÀÖ´Â »çÀ¯·Î »óÇ° µîÀÌ ¼Õ½Ç ¶Ç´Â ÈÑ¼ÕµÈ °æ¿ì ·¼ÒºñÀÚÀÇ »ç¿ë, Æ÷Àå °³ºÀ¿¡ ÀÇÇØ »óÇ° µîÀÇ °¡Ä¡°¡ ÇöÀúÈ÷ °¨¼ÒÇÑ °æ¿ì ·º¹Á¦°¡ °¡´ÉÇÑ »óÇ° µîÀÇ Æ÷ÀåÀ» ÈѼÕÇÑ °æ¿ì ·½Ã°£ÀÇ °æ°ú¿¡ ÀÇÇØ ÀçÆǸŰ¡ °ï¶õÇÑ Á¤µµ·Î °¡Ä¡°¡ ÇöÀúÈ÷ °¨¼ÒÇÑ °æ¿ì ·ÀüÀÚ»ó°Å·¡ µî¿¡¼ÀÇ ¼ÒºñÀÚº¸È£¿¡ °üÇÑ ¹ý·üÀÌ Á¤ÇÏ´Â ¼ÒºñÀÚ Ã»¾àöȸ Á¦ÇÑ ³»¿ë¿¡ ÇØ´çµÇ´Â °æ¿ì |
»óÇ° Ç°Àý |
°ø±Þ»ç(ÃâÆÇ»ç) Àç°í »çÁ¤¿¡ ÀÇÇØ Ç°Àý/Áö¿¬µÉ ¼ö ÀÖÀ½ |
¼ÒºñÀÚ ÇÇÇغ¸»ó |
·»óÇ°ÀÇ ºÒ·®¿¡ ÀÇÇÑ ±³È¯, A/S, ȯºÒ, Ç°Áúº¸Áõ ¹× ÇÇÇغ¸»ó µî¿¡ °üÇÑ »çÇ×Àº¼ÒºñÀÚºÐÀïÇØ°á ±âÁØ (°øÁ¤°Å·¡À§¿øȸ °í½Ã)¿¡ ÁØÇÏ¿© ó¸®µÊ ·´ë±Ý ȯºÒ ¹× ȯºÒÁö¿¬¿¡ µû¸¥ ¹è»ó±Ý Áö±Þ Á¶°Ç, ÀýÂ÷ µîÀº ÀüÀÚ»ó°Å·¡ µî¿¡¼ÀǼҺñÀÚ º¸È£¿¡ °üÇÑ ¹ý·ü¿¡ µû¶ó ó¸®ÇÔ |
(ÁÖ)ÀÎÅÍÆÄÅ©Ä¿¸Ó½º´Â ȸ¿ø´ÔµéÀÇ ¾ÈÀü°Å·¡¸¦ À§ÇØ ±¸¸Å±Ý¾×, °áÁ¦¼ö´Ü¿¡ »ó°ü¾øÀÌ (ÁÖ)ÀÎÅÍÆÄÅ©Ä¿¸Ó½º¸¦ ÅëÇÑ ¸ðµç °Å·¡¿¡ ´ëÇÏ¿©
(ÁÖ)KGÀ̴Ͻýº°¡ Á¦°øÇÏ´Â ±¸¸Å¾ÈÀü¼ºñ½º¸¦ Àû¿ëÇÏ°í ÀÖ½À´Ï´Ù.
¹è¼Û¾È³»
±³º¸¹®°í »óÇ°Àº Åùè·Î ¹è¼ÛµÇ¸ç, Ãâ°í¿Ï·á 1~2Àϳ» »óÇ°À» ¹Þ¾Æ º¸½Ç ¼ö ÀÖ½À´Ï´Ù.
Ãâ°í°¡´É ½Ã°£ÀÌ ¼·Î ´Ù¸¥ »óÇ°À» ÇÔ²² ÁÖ¹®ÇÒ °æ¿ì Ãâ°í°¡´É ½Ã°£ÀÌ °¡Àå ±ä »óÇ°À» ±âÁØÀ¸·Î ¹è¼ÛµË´Ï´Ù.
±ººÎ´ë, ±³µµ¼Ò µî ƯÁ¤±â°üÀº ¿ìü±¹ Åù踸 ¹è¼Û°¡´ÉÇÕ´Ï´Ù.
¹è¼Ûºñ´Â ¾÷ü ¹è¼Ûºñ Á¤Ã¥¿¡ µû¸¨´Ï´Ù.