·Î±×ÀÎ
¸¶ÀÌÆäÀÌÁö
ÀÌ¿ë¾È³»
°í°´¼¾ÅÍ
¼ºñ½º¾È³»
Áñ°Üã±â
JAVA
½ÅÀÔ»ç¿ø
PHP
ASP
³×Æ®¿öÅ©
°æ·Â»ç¿ø
DBA
°³ÀÎ
±â¾÷
¼Ä¡Æß
Ä¿¹Â´ÏƼ
°Ô½ÃÆÇ
ÀÚÀ¯°Ô½ÃÆÇ
IT ±³À°/±¹ºñÁö¿ø/¼¼¹Ì³ª
¹«·á ¹è³Ê½Åû °Ô½ÃÆÇ
IT ´º½º(NEWS)
ȸ¿ø¿ë ÀÚ·á½Ç
°¶·¯¸®
ȸ¿ø¿ë °¶·¯¸®
ºñȸ¿ø¿ë °¶·¯¸®
À¥Áø°Ô½ÃÆÇ
ȸ¿ø¿ë °Ô½ÃÆÇ
ºñȸ¿ø¿ë °Ô½ÃÆÇ
IT ±³À°/±¹ºñÁö¿ø/¼¼¹Ì³ª
[¹æÇÐƯ°]¿À¶óŬÇпøÃßõ¡Úžũ¸®¿¡µà SQL±âÃÊ°úÁ¤
ÀÛ¼ºÀÚ:
žũ¸®¿¡µà
̵̧:
0°Ç
¹Ý´ë:
0°Ç
Á¶È¸:
5272
µî·ÏÀÏ:
2016-08-01
(¿À¶óŬÇпøÃßõ)SQL±âÃÊ°úÁ¤
¹Ù·Î°¡±â
http://topcredu.co.kr/sub/crcl/cate/8
SQL±âÃÊ°úÁ¤
¼±¼öÇнÀ :
µ¥ÀÌÅͺ£À̽º ±âº»
±³À°±â°£ :
»ó´ÜURLÂüÁ¶
°ÀÇÀå¼Ò :
žũ¸®¿¡µà±³À°¼¾ÅÍ [B°ÀÇÀå]
[¾àµµº¸±â]
±³À°¹®ÀÇ :
02-851-4790
¼ö°·á :
420,000¿ø
[½Ç¹«Á߽ɱ³À°]°í¿ëº¸Çè ¹ÌÁö¿ø, ÀÏ¹Ý °úÁ¤ ÀÔ´Ï´Ù. (¼Ò¼öÁ¤¿¹, ½ºÆĸ£Å¸½Ä ±³À° ÀÔ´Ï´Ù.)
ÇѺÐÇѺÐÀÇ ¼ö°»ý ¿©·¯ºÐµé²² ÃÖ¼±À» ´ÙÇÏ´Â ½Ç¹«/½Ç½À À§ÁÖÀÇ ±³À° ÀÔ´Ï´Ù.
°áÁ¦¹æ¹ý :
°èÁÂÀÌü / ¹æ¹®Ä«µå°áÁ¦
±³Àç :
SQLÃʺ¸¿¡¼ Schema Objects ±îÁö(±³Àçºñ 15000¿ø º°µµ)
±³À°°³¿ä
½Ç¹«¿¡¼ ´Ù ³â°£ 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 __EXPRESSION__s)
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
°Ç
ÀÌÀü±Û
[Àü¾×¹«·á±³À°] ITºÐ¾ß Àü¾×¹«·á Ãë¾÷¿¬°è±³À°°úÁ¤ ±³À°»ý¸ðÁý
´ÙÀ½±Û
ÀÚ¹Ù,C¾ð¾î, ¸®´ª½º, ³×Æ®¿öÅ© µî ¹«·áÀΰµè±â
¹øÈ£
Á¦¸ñ
ÀÛ¼ºÀÚ
̵̧
¹Ý´ë
Á¶È¸
µî·ÏÀÏ
9194
[KG¾ÆÀÌƼ¹ðÅ©] ¡Ú¸ðÀÇÇØÅ· ÄÁ¼³ÆÃ(ÈÀÌÆ®...
KG¾ÆÀÌƼ¹ðÅ©
0
0
1464
2018-07-04
9193
[KG¾ÆÀÌƼ¹ðÅ©] ¡ÚÁ¤º¸º¸¾È Àü¹®°¡(ÇØÅ·º¸...
KG¾ÆÀÌƼ¹ðÅ©
0
0
1091
2018-07-04
9192
[KG¾ÆÀÌƼ¹ðÅ©] ¡Ú³×Æ®¿öÅ© ¿£Áö´Ï¾î ¹× ³×...
KG¾ÆÀÌƼ¹ðÅ©
0
0
1139
2018-07-04
9191
[KG¾ÆÀÌƼ¹ðÅ©] ¡ÚŬ¶ó¿ìµå ÄÄÇ»Æà °¡»óÈ...
KG¾ÆÀÌƼ¹ðÅ©
0
0
1204
2018-07-04
9190
[KG¾ÆÀÌƼ¹ðÅ©] ¡Úº¸¾È ¼Ö·ç¼Ç ¹× CERT Á¤...
KG¾ÆÀÌƼ¹ðÅ©
0
0
1311
2018-07-04
9189
2018³â ÇϹݱâ JAVA À¥°³¹ßÀÚ ½ÅÀÔ»ç¿ø ä...
ä¿ë´ã´çÀÚ
0
0
2069
2018-07-04
9188
[±¹ºñÁö¿ø/ÈƷúñÁö±Þ] 'Á¤º¸½Ã½ºÅÛº¸¾ÈÀü...
´ã´çÀÚ
0
0
2330
2018-07-04
9187
[±¹ºñÁö¿ø/ÈƷúñÁö±Þ] 'ij¸¯ÅÍUI/GUIÁ¦ÀÛ...
´ã´çÀÚ
0
0
2501
2018-07-04
9186
[±¹ºñÁö¿ø/ÈƷúñÁö±Þ] '°ÔÀÓÇÁ·Î±×·¡¸Ó¾ç...
´ã´çÀÚ
0
0
2702
2018-07-04
9185
[¹«·á CRM ±³À°] Çΰż¼ÀÏÁî CRM 7¿ù ¹«·á ...
Äɺó
0
0
1508
2018-07-03
9184
¢ºKG¾ÆÀÌƼ¹ðÅ© ¿ÀǼҽº±â¹Ý º¸¾È Ãë¾àÁ¡ ...
¾ÆÀÌƼ¹ðÅ©
0
0
1669
2018-07-03
9183
¢º KG¾ÆÀÌƼ¹ðÅ© °¡»óÈ ½Ã½ºÅÛ ¿£Áö´Ï¾î ...
¾ÆÀÌƼ¹ðÅ©
0
0
1677
2018-07-03
9182
¢º KG¾ÆÀÌƼ¹ðÅ© ³×Æ®¿öÅ©º¸¾È ½Ç¹«ÀÚ ¾ç¼º...
¾ÆÀÌƼ¹ðÅ©
0
0
1991
2018-07-03
9181
¢º KG¾ÆÀÌƼ¹ðÅ© ÀΰÀ¸·Î OCPÃëµæÇϱâ/ ±³...
¾ÆÀÌƼ¹ðÅ©
0
0
2882
2018-07-03
9180
¢ºÇÁ¸®¹Ì¾ö Ãë¾÷Áغñ Ãë¾÷ÄÚĪ¹Ý ¿ÀÇÂ!!
¾ÆÀÌƼ¹ðÅ©
0
0
1907
2018-07-03
681
|
682
|
683
|
684
|
685
|
686
|
687
|
688
|
689
|
690
|
|
|
|
|
Á¦¸ñ ¾øÀ½
À̾ƹäºñÁî ¼³¸³ÀÏ : 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.