·Î±×ÀÎ
¸¶ÀÌÆäÀÌÁö
ÀÌ¿ë¾È³»
°í°´¼¾ÅÍ
¼ºñ½º¾È³»
Áñ°Üã±â
JAVA
½ÅÀÔ»ç¿ø
PHP
ASP
³×Æ®¿öÅ©
°æ·Â»ç¿ø
DBA
°³ÀÎ
±â¾÷
¼Ä¡Æß
Ä¿¹Â´ÏƼ
°Ô½ÃÆÇ
ÀÚÀ¯°Ô½ÃÆÇ
IT ±³À°/±¹ºñÁö¿ø/¼¼¹Ì³ª
¹«·á ¹è³Ê½Åû °Ô½ÃÆÇ
IT ´º½º(NEWS)
ȸ¿ø¿ë ÀÚ·á½Ç
°¶·¯¸®
ȸ¿ø¿ë °¶·¯¸®
ºñȸ¿ø¿ë °¶·¯¸®
À¥Áø°Ô½ÃÆÇ
ȸ¿ø¿ë °Ô½ÃÆÇ
ºñȸ¿ø¿ë °Ô½ÃÆÇ
IT ±³À°/±¹ºñÁö¿ø/¼¼¹Ì³ª
[SQL±âÃÊÇпø,IT½Ç¹«°í±Þ±³À°ÇпøÃßõ¡ßžũ¸®¿¡µà]SQL±âÃÊ°úÁ¤
ÀÛ¼ºÀÚ:
žũ¸®¿¡µà
̵̧:
0°Ç
¹Ý´ë:
0°Ç
Á¶È¸:
4792
µî·ÏÀÏ:
2016-09-27
SQL±âÃÊ°úÁ¤(ÆòÀÏÁÖ°£)
¼±¼öÇнÀ :
µ¥ÀÌÅͺ£À̽º ±âº»
±³À°±â°£ :
ÇпøȨÆäÀÌÁöÂüÁ¶(topcredu.co.kr)
°ÀÇÀå¼Ò :
žũ¸®¿¡µà±³À°¼¾ÅÍ [A°ÀÇÀå]
[¾àµµº¸±â]
±³À°¹®ÀÇ :
02-851-4790
¼ö°·á :
520,000¿ø
364,000¿ø
[½Ç¹«Á߽ɱ³À°]°í¿ëº¸Çè ¹ÌÁö¿ø, ÀÏ¹Ý °úÁ¤ ÀÔ´Ï´Ù. (¼Ò¼öÁ¤¿¹, ½ºÆĸ£Å¸½Ä ±³À° ÀÔ´Ï´Ù.)
ÇѺÐÇѺÐÀÇ ¼ö°»ý ¿©·¯ºÐµé²² ÃÖ¼±À» ´ÙÇÏ´Â ½Ç¹«/½Ç½À À§ÁÖÀÇ ±³À° ÀÔ´Ï´Ù.
°áÁ¦¹æ¹ý :
°èÁÂÀÌü / ¹æ¹®Ä«µå°áÁ¦
±³Àç :
PDF ¹«·áÁ¦°ø
±³À°°³¿ä
½Ç¹«¿¡¼ ´Ù ³â°£ SQLÆ©´×À» °æÇèÇÑ ½ÇÀü SQL Àü¹®°¡°¡ ÁøÇàÇÏ´Â º» °úÁ¤Àº SQL±âÃʺÎÅÍ ±âº» DML, SQLÇÔ¼ö, ±âº»ÀûÀÎ Select±¸¹® »ç¿ë¹ýºÎÅÍ ¼ºêÄõ¸®, Á¶ÀÎ, °³¹ß ½Ã ÈçÈ÷ °Þ°Ô µÇ´Â ÃÖÀûÀÇ SQL »ç¿ë¹ý¿¡ ÁßÁ¡À» µÐ °Á ÀÔ´Ï´Ù.
SQL±¸¹®À» »ç¿ëÇÏ¸é¼ ÀÚÁÖ º¸°ÔµÇ´Â ½ºÅ°¸¶ °´Ã¼(Schema Object, Table, Index, View, Sequence, Synonym, DBLink)µé±îÁö ´Ù·ç´Â SQLÀÇ ±âº» °úÁ¤ À̸ç, °³¹ßÀÚ¶ó¸é ¹Ýµå½Ã ¾Ë°í°è¼Å¾ß ÇÏ´Â ¿µ¿ª ÀÔ´Ï´Ù.
¼ö·áÁ¶°Ç
Ãâ¼®·ü 80%ÀÌ»ó
±³À°¸ñÇ¥
SQL*Plus »ç¿ë¹ý¿¡ ´ëÇÑ ÀÌÇØ
SQL ±âº»ÇÔ¼ö¿¡ ´ëÇÑ ÀÌÇØ
SQL °í±ÞÇÔ¼ö¿¡ ´ëÇÑ ÀÌÇØ
SQL ºÐ¼®ÇÔ¼ö¿¡ ´ëÇÑ ÀÌÇØ
SELECT ±¸¹®¿¡ ´ëÇÑ ÀÌÇØ
Group ÇÔ¼ö¿¡ ´ëÇÑ ÀÌÇØ
Join¿¡ ´ëÇÑ ÀÌÇØ
Sub Query¿¡ ´ëÇÑ ÀÌÇØ
DML, DDL, DCL¿¡ ´ëÇÑ ÀÌÇØ
Oracle Table¿¡ ´ëÇÑ ÀÌÇØ
Oracle Index¿¡ ´ëÇÑ ÀÌÇØ
Oracle ±âŸ Schema Object ¿¡ ´ëÇÑ ÀÌÇØ
(View, Synonym, Trigger, DataBase Link, Sequenceµî)
È¿À²ÀûÀÎ ½ºÅ°¸¶¿ÀºêÁ§Æ® ¿î¿µ ¹× °ü¸®
±³À°´ë»ó
Ãʺ¸ °³¹ßÀÚ
SQL ±âÃʱ³À°ÀÌ ÇÊ¿äÇϽŠºÐ
µ¥ÀÌÅͺ£À̽º °ü·Ã °³¹ßÀÚ
Çлý ¹× ÀϹÝÀÎ
±³À°³»¿ë
±³Àç ¹Ì¸®º¸±â
SQLÃʺ¸¿¡¼SchemaObject±îÁö
SQL±âÃÊ¿¡¼Schema Objects±îÁö
1. °³¿ä ¹× ½Ç½Àµ¥ÀÌÅÍ ¼³Ä¡
1-1. ¿À¶óŬ, µ¥ÀÌÅͺ£À̽º°ü·Ã ¿ë¾î
1-2. ¿À¶óŬ ¿¡µð¼Ç(ORACLE EDITION)
1-3. ¿À¶óŬ ¹öÀü º¯È
1-4. ½Ç½Àµ¥ÀÌÅÍ ¼³Ä¡ ¹× SQL*PLUS ½ÇÇàȯ°æ ¼³Á¤
1-4. ½Ç½Àµ¥ÀÌÅÍ ±¸Á¶(Å×À̺í Á¤ÀǼ)
1-5. µ¥ÀÌÅͺ£À̽º ¹«°á¼º(DataBase Integrity)
2. SQL*Plus
2-1. °³¿ä, ½ÃÀÛ, Á¾·á
2-2. µ¥ÀÌÅͺ£À̽º ½ÃÀÛ, Á¾·á
2-2. SQL*Plus ¸í·É¾î
2.2.1 ÁÖ¿ä ¸í·É¾î
2.2.2 ÆíÁý ¸í·É¾î
2.2.3 ÆÄÀÏ°ü·Ã ¸í·É¾î
2.2.4 SET ¸í·É¾î
2.2.5 Çü½Ä ¸í·É¾î
3. ±âº» SQL ¸í·É¾î
3.1 Schema °èÁ¤¿¡¼ÀÇ ±âº» Äõ¸®¹®
3.2 ±âº» Äõ¸®¹®
3.2.1 SELECT¹®
3.2.2 »ê¼ú Ç¥Çö½Ä(Arithmetic Expression)
3.2.3 Ä®·³ º°¸í(Column Alias)
3.2.4 ÇÕ¼º ¿¬»êÀÚ(Concatenated Operator)
3.2.5 Á¶°ÇÁúÀÇ¿Í ORDER BY
3.2.6 SQL Á¶°Ç¿¬»êÀÚ¸¦ ÀÌ¿ëÇÑ Á¶°Ç°Ë»ö
3.2.7 ANY(SOME), ALL, EXISTS
3.2.8 ÁýÇÕ ¿¬»êÀÚ
3.3 ROWNUM ¹× NULL°ª, NLS_DATE_FORMAT
3.3.1 ROWNUM
3.3.2 NULLÀ̶õ?
3.3.3 NLS Parameters
3.4 µ¥ÀÌÅÍ Å¸ÀÔ(Data Type)
4. SQL ÇÔ¼ö
4.1 ¹®ÀÚÇÔ¼ö
4.2 ÁýÇÕ ÇÔ¼ö(Aggreation Function), GROUP BY, HAVING
4.3 ¼ýÀÚ ¹× ³¯Â¥ ÇÔ¼ö(Number And Date Function)
4.3 º¯È¯ ÇÔ¼ö(Conversion Function)
4.4 ÀÏ¹Ý ÇÔ¼ö ¹× Á¶°Ç½Ä(General Functions and Conditional Expressions)
5. ¼ºê Äõ¸®(SUB QUERY)
5.1 ¼ºê Äõ¸®(SUB QUERY) °³¿ä
5.2 º¹¼öÇà ¼ºêÄõ¸®(Multi-Row Sub Query)
5.3 »ó°ü ¼ºêÄõ¸®(Correlated Sub Query)
5.4 Scalar SubQuery
5.5 ÀζóÀκä(IN_LINE VIEW)
5.6 WITH ±¸¹®
6. Á¶ÀÎ(JOIN)
6.1 Å×ÀÌºí º°¸í(Table Alias)
6.2 īƼ¼Ç ÇÁ·Î´öÆ®(Cartesian Product)
6.3 EquiJoin, Non EquiJoin
6.4 Self Join
6.5 Outer Join
6.6 °èÃþÇü Äõ¸®(Hierarchical Query)
7. ¿À¶óŬ ºÐ¼®ÇÔ¼ö(Analytic Function) ¹× SQL È°¿ë
7.1 ºÐ¼®ÇÔ¼ö¶õ?
7.2 ºÐ¼®ÇÔ¼ö ±âº»Çü½Ä(PARTITION BY, ORDER BY, WINDOW±¸, MAX, MIN, SUM, AVG, DENSE RANK FIRST/LAST, KEEP, OVER)
7.3 ºÐ¼®ÇÔ¼ö(LISTAGG)
7.4 ºÐ¼®ÇÔ¼ö(FIRST_VALUE, LAST_VALUE, RANK, DENSE_RANK, ROW_NUMBER)
7.5 SQLÈ°¿ë
8. Å×À̺í(Table)
8.1 Å×À̺í(Table)À̶õ?
8.1.1 Create Table
8.1.2 Å×ÀÌºí ±¸Á¶ º¯°æ
8.1.3 Å×À̺í À̸§º¯°æ ¹× »èÁ¦, ÁÖ¼®Ãß°¡
8.1.5 FlashBack Drop ¹× Recycle Bin
8.1.6 µ¥ÀÌÅÍ ¹«°á¼º(Data Integrity) Á¦¾àÁ¶°Ç(Constraints)
8.1.7 ¿À¶óŬ11g ÀбâÀü¿ë Å×À̺í
8.1.8 ¿À¶óŬ11g °¡»ó Ä®·³(Virtual Column)
9. µ¥ÀÌÅÍ µñ¼Å³Ê¸®(Data Dictionary)
9.1 µ¥ÀÌÅÍ µñ¼Å³Ê¸® °³¿ä
9.2 USER_ µ¥ÀÌÅÍ µñ¼Å³Ê¸® ºä
10. DML(Data Manipulation Language)
10.1 DML °³¿ä
10.2 INSERT ¸í·É¾î
10.2.1 ´ÜÀÏÇà ÀÔ·Â
10.2.2 º¹¼öÇà ÀÔ·Â(Multi Row Insert)
10.3 UPDATE ¸í·É¾î
10.4 DELETE ¸í·É¾î
10.5 MERGE ¸í·É¾î
11. À妽º(INDEX)
11.1 ´ÜÀÏ/º¹ÇÕ(°áÇÕ) À妽º(Single Column/Composite Index)
11.2 °íÀ¯/ºñ°íÀ¯ À妽º(Unique/Non Unique Index)
11.3 Descending Index
11.4 ÇÔ¼ö±â¹Ý À妽º(Function Based Index)
11.5 À妽º À籸¼º ¹× »èÁ¦
11.6 À妽º ¼û±â±â(Index Invisible)
12. ºä(VIEW)
12.1 ´Ü¼ø ºä(Simple View)
12.2 º¹ÇÕ ºä(Complex View)
12.3 ÀζóÀÎ ºä(Inline View)
12.4 WITH CHECK OPTION
12.5 DROP VIEW
13. µ¿ÀǾî(Synonym)
14. ½ÃÄö½º(Sequence)
Æ®À§ÅÍ
ÆäÀ̽ººÏ
´ñ±Û :
0
°Ç
ÀÌÀü±Û
[Á¾·ÎC¾ð¾îÇпø] ´ëÇлýÀü°ø´ëºñ C¾ð¾îÇÁ·ÎÁ§Æ® ÃßõÇпø¿¡¼ °øºÎÇÏÀÚ!!
´ÙÀ½±Û
¡Ú±¹ºñÁö¿ø. ä¿ë¿¹Á¤ÀÚ±³À°¡Ú ÈƷüö´ç 2,496,000¿ø Áö±Þ. À¥Ç¥ÁØ(ÀÚ¹Ù) JAVA Programming & ¾Û(¾Èµå·ÎÀ̵å) ÇÁ·Î±×·¥ °³¹ßÀÚ °úÁ¤.
¹øÈ£
Á¦¸ñ
ÀÛ¼ºÀÚ
̵̧
¹Ý´ë
Á¶È¸
µî·ÏÀÏ
1576
c¾ð¾î, ÀÚ¹Ù, ¸®´ª½º, ³×Æ®¿öÅ© 150,000¸¸...
¾ÆÀÌƼ¹ðÅ©
0
0
5145
2016-09-29
1575
[¡Ú¼ö°·á30%ÇÒÀΡÚÀÚ¹ÙÇпø,JSPÇпø,½ºÇÁ...
žũ¸®¿¡µà
0
0
6486
2016-09-29
1574
[KG¾ÆÀÌƼ¹ðÅ©] ¡Ú¸ðÀÇÇØÅ· ÄÁ¼³ÆÃ(ÈÀÌÆ®...
KG¾ÆÀÌƼ¹ðÅ©
0
0
4638
2016-09-29
1573
[KG¾ÆÀÌƼ¹ðÅ©] ¡ÚÁ¤º¸º¸¾È Àü¹®°¡(ÇØÅ·º¸...
KG¾ÆÀÌƼ¹ðÅ©
0
0
4558
2016-09-29
1572
[KG¾ÆÀÌƼ¹ðÅ©] ¡Ú³×Æ®¿öÅ© ¿£Áö´Ï¾î ¹× ³×...
KG¾ÆÀÌƼ¹ðÅ©
0
0
4341
2016-09-29
1571
[KG¾ÆÀÌƼ¹ðÅ©] ¡ÚŬ¶ó¿ìµå ÄÄÇ»Æà °¡»óÈ...
KG¾ÆÀÌƼ¹ðÅ©
0
0
4464
2016-09-29
1570
[KG¾ÆÀÌƼ¹ðÅ©] ¡Ú º¸¾È ¼Ö·ç¼Ç ¹× CERT Á¤...
KG¾ÆÀÌƼ¹ðÅ©
0
0
4683
2016-09-29
1569
ÇѺû±³À°¼¾ÅÍ ½ÅÃÌ ÀÚ¹Ù±¹ºñÇпø »ç¹°ÀÎÅÍ...
IT¼±»ý´Ô
0
0
4896
2016-09-29
1568
[Ãë¾÷¼º°øÆÐÅ°Áö¡Ú] ¿À¶óŬ&ÀÚ¹Ù ±â¹Ý À¥ ...
±è³«±Ù
0
0
6175
2016-09-28
1567
¡Ú¾ÆÀÌƼÀª_³×Æ®¿öÅ© ÀÚ°ÝÁõ CCNA, CCNP ±¹...
±è³«±Ù
0
0
5347
2016-09-28
1566
¡Ú[±¹ºñÁö¿ø] RÇÁ·Î±×·¡¹ÖÀ» È°¿ëÇÑ ºòµ¥ÀÌ...
±è³«±Ù
0
0
6058
2016-09-28
1565
[¡Ú¼ö°·á30%ÇÒÀΡÚC#Çпø,ÀÚ¸¶¸°Çпø,IT½Ç...
žũ¸®¿¡µà
0
0
5535
2016-09-28
1564
¢º ÈÀÌÆ®ÇØÄ¿ ¾ç¼º°úÁ¤
¾ÆÀÌƼ¹ðÅ©
0
0
4909
2016-09-28
1563
¢º Ŭ¶ó¿ìµå ±â¹Ý ºòµ¥ÀÌÅÍ °³¹ß Àü¹® °úÁ¤
¾ÆÀÌƼ¹ðÅ©
0
0
5225
2016-09-28
1562
¢º Ŭ¶ó¿ìµå °¡»óÈ ½Ã½ºÅÛ ¿£Áö´Ï¾î ¾ç¼º ...
¾ÆÀÌƼ¹ðÅ©
0
0
4953
2016-09-28
1191
|
1192
|
1193
|
1194
|
1195
|
1196
|
1197
|
1198
|
1199
|
1200
|
|
|
|
|
Á¦¸ñ ¾øÀ½
À̾ƹäºñÁî ¼³¸³ÀÏ : 2015 ³â 12¿ù 1ÀÏ ´ëÇ¥ÀÌ»ç : ¹Ú¿øÁ¤ °³ÀÎÁ¤º¸Ã¥ÀÓÀÚ : ¹Ú¿øÁ¤ À̸ÞÀÏ :
admin@itnjob.com
»ç¾÷ÀÚµî·Ï¹øÈ£ : 609-23-93848
Åë½ÅÆǸž÷ : Á¦2013-â¿ø¼º»ê-0131È£ Á÷¾÷Á¤º¸Á¦°ø:â¿ø Á¦2013-4 È£
¼¹ö¼ÒÀç
:
(135-920)
¼¿ï °³²±¸ Å×Çì¶õ·Î 216
½Å¿õŸ¿ö
ÁÖ¼Ò : (5
3182) °æ³² â¿ø½Ã ÀÇⱸ Áßµ¿·Î 77
´ëÇ¥ÀüÈ : 010-2371-4579 (Àü±¹)
Copyright
ITnJOB.COM
Ltd. All rights reserved.