·Î±×ÀÎ
¸¶ÀÌÆäÀÌÁö
ÀÌ¿ë¾È³»
°í°´¼¾ÅÍ
¼ºñ½º¾È³»
Áñ°Üã±â
JAVA
½ÅÀÔ»ç¿ø
PHP
ASP
³×Æ®¿öÅ©
°æ·Â»ç¿ø
DBA
°³ÀÎ
±â¾÷
¼Ä¡Æß
Ä¿¹Â´ÏƼ
°Ô½ÃÆÇ
ÀÚÀ¯°Ô½ÃÆÇ
IT ±³À°/±¹ºñÁö¿ø/¼¼¹Ì³ª
¹«·á ¹è³Ê½Åû °Ô½ÃÆÇ
IT ´º½º(NEWS)
ȸ¿ø¿ë ÀÚ·á½Ç
°¶·¯¸®
ȸ¿ø¿ë °¶·¯¸®
ºñȸ¿ø¿ë °¶·¯¸®
À¥Áø°Ô½ÃÆÇ
ȸ¿ø¿ë °Ô½ÃÆÇ
ºñȸ¿ø¿ë °Ô½ÃÆÇ
IT ±³À°/±¹ºñÁö¿ø/¼¼¹Ì³ª
[¹æÇÐƯ°]¿À¶óŬÇпøÃßõ¡Úžũ¸®¿¡µà SQL±âÃÊ°úÁ¤
ÀÛ¼ºÀÚ:
žũ¸®¿¡µà
̵̧:
0°Ç
¹Ý´ë:
0°Ç
Á¶È¸:
5285
µî·ÏÀÏ:
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¾ð¾î, ¸®´ª½º, ³×Æ®¿öÅ© µî ¹«·áÀΰµè±â
¹øÈ£
Á¦¸ñ
ÀÛ¼ºÀÚ
̵̧
¹Ý´ë
Á¶È¸
µî·ÏÀÏ
9109
2018³â ÇϹݱâ JAVA À¥/¾Û°³¹ßÀÚ Ã¤¿ë±³À°(...
ä¿ë´ã´çÀÚ
0
0
1876
2018-06-25
9108
[¹«·á CRM ±³À°] Çΰż¼ÀÏÁî CRM 7¿ù ¹«·á ...
Äɺó
0
0
1292
2018-06-25
9107
[±¹ºñÁö¿ø/ÈƷúñÁö±Þ] 'ij¸¯ÅÍUI/GUIÁ¦ÀÛ...
´ã´çÀÚ
0
0
2442
2018-06-25
9106
[±¹ºñÁö¿ø/ÈƷúñÁö±Þ] 'Á¤º¸½Ã½ºÅÛº¸¾ÈÀü...
´ã´çÀÚ
0
0
2311
2018-06-25
9105
[±¹ºñÁö¿ø/ÈƷúñÁö±Þ] '°ÔÀÓÇÁ·Î±×·¡¸Ó¾ç...
´ã´çÀÚ
0
0
2659
2018-06-25
9104
[±¹ºñÁö¿ø] IT ÀçÁ÷ÀÚÇпø ¿À¶óŬÀÚ¹Ù±³À°...
¿øµ¿Áø
0
0
2380
2018-06-22
9103
[ÃÖ´ë100% ±¹ºñÁö¿ø] IT ÀçÁ÷ÀÚÇпø ¿À¶óŬ...
¿øµ¿Áø
0
0
2598
2018-06-22
9102
[¹«·á CRM ±³À°] Çΰż¼ÀÏÁî CRM 7¿ù ¹«·á ...
Äɺó
0
0
1374
2018-06-22
9101
¢Ää¿ë¿¬¼ö ¹«·á±³À°¢Å ¸ÖƼÇÁ·¹ÀÓ¿öÅ© ±â...
¿¡ÀÌÄܾÆÄ«µ¥¹Ì
0
0
1333
2018-06-22
9100
¢Ää¿ë¿¬¼ö ¹«·á±³À°¢Å µö·¯´×(Àΰø½Å°æ¸Á ...
¿¡ÀÌÄܾÆÄ«µ¥¹Ì
0
0
1407
2018-06-22
9099
¢¾Ãë¾÷¹«·á±³À°¢¾ Ŭ¶ó¿ìµå ±â¹Ý ºòµ¥ÀÌÅÍ ...
KICÄ·ÆÛ½º
0
0
1274
2018-06-22
9098
¢¾Ãë¾÷¹«·á±³À°¢¾ ¸Ó½Å·¯´× ±â¹ÝÀÇ ºòµ¥ÀÌ...
KICÄ·ÆÛ½º
0
0
1350
2018-06-22
9097
¡Úä¿ë¿¹Á¤ÀÚ¹«·á±³À°¡Ú ÈƷüö´ç 249¸¸¿ø ...
Áß¾ÓÁ¤º¸±â¼úÀÎÀç°³¹ß¿ø
0
0
1855
2018-06-22
9096
KG¾ÆÀÌƼ¹ðÅ©] ¡Ú¸ðÀÇÇØÅ· ÄÁ¼³ÆÃ(ÈÀÌÆ®ÇØ...
KG¾ÆÀÌƼ¹ðÅ©
0
0
1089
2018-06-22
9095
[KG¾ÆÀÌƼ¹ðÅ©] ¡ÚÁ¤º¸º¸¾È Àü¹®°¡(ÇØÅ·º¸...
KG¾ÆÀÌƼ¹ðÅ©
0
0
1089
2018-06-22
691
|
692
|
693
|
694
|
695
|
696
|
697
|
698
|
699
|
700
|
|
|
|
|
Á¦¸ñ ¾øÀ½
À̾ƹäºñÁî ¼³¸³ÀÏ : 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.