·Î±×ÀÎ
¸¶ÀÌÆäÀÌÁö
ÀÌ¿ë¾È³»
°í°´¼¾ÅÍ
¼ºñ½º¾È³»
Áñ°Üã±â
JAVA
½ÅÀÔ»ç¿ø
PHP
ASP
³×Æ®¿öÅ©
°æ·Â»ç¿ø
DBA
°³ÀÎ
±â¾÷
¼Ä¡Æß
Ä¿¹Â´ÏƼ
°Ô½ÃÆÇ
ÀÚÀ¯°Ô½ÃÆÇ
IT ±³À°/±¹ºñÁö¿ø/¼¼¹Ì³ª
¹«·á ¹è³Ê½Åû °Ô½ÃÆÇ
IT ´º½º(NEWS)
ȸ¿ø¿ë ÀÚ·á½Ç
°¶·¯¸®
ȸ¿ø¿ë °¶·¯¸®
ºñȸ¿ø¿ë °¶·¯¸®
À¥Áø°Ô½ÃÆÇ
ȸ¿ø¿ë °Ô½ÃÆÇ
ºñȸ¿ø¿ë °Ô½ÃÆÇ
IT ±³À°/±¹ºñÁö¿ø/¼¼¹Ì³ª
[¹æÇÐƯ°]¿À¶óŬÇпøÃßõ¡Úžũ¸®¿¡µà SQL±âÃÊ°úÁ¤
ÀÛ¼ºÀÚ:
žũ¸®¿¡µà
̵̧:
0°Ç
¹Ý´ë:
0°Ç
Á¶È¸:
5280
µî·ÏÀÏ:
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¾ð¾î, ¸®´ª½º, ³×Æ®¿öÅ© µî ¹«·áÀΰµè±â
¹øÈ£
Á¦¸ñ
ÀÛ¼ºÀÚ
̵̧
¹Ý´ë
Á¶È¸
µî·ÏÀÏ
7248
[KG¾ÆÀÌƼ¹ðÅ©] ¡Ú¸ðÀÇÇØÅ· ÄÁ¼³ÆÃ(ÈÀÌÆ®...
KG¾ÆÀÌƼ¹ðÅ©
0
0
1673
2018-01-22
7247
[KG¾ÆÀÌƼ¹ðÅ©] ¡ÚÁ¤º¸º¸¾È Àü¹®°¡(ÇØÅ·º¸...
KG¾ÆÀÌƼ¹ðÅ©
0
0
1527
2018-01-22
7246
[KG¾ÆÀÌƼ¹ðÅ©] ¡Ú³×Æ®¿öÅ© ¿£Áö´Ï¾î ¹× ³×...
KG¾ÆÀÌƼ¹ðÅ©
0
0
1501
2018-01-22
7245
[KG¾ÆÀÌƼ¹ðÅ©] ¡ÚŬ¶ó¿ìµå ÄÄÇ»Æà °¡»óÈ...
KG¾ÆÀÌƼ¹ðÅ©
0
0
1460
2018-01-22
7244
[KG¾ÆÀÌƼ¹ðÅ©] ¡Úº¸¾È ¼Ö·ç¼Ç ¹× CERT Á¤...
KG¾ÆÀÌƼ¹ðÅ©
0
0
1505
2018-01-22
7243
[2018³âµµ IT±¹ºñÁö¿ø°úÁ¤ / Çѱ¹ITÁ÷¾÷Àü...
´ã´çÀÚ
0
0
2199
2018-01-22
7242
[¹«·á±³À°/ÈƷúñÁö±Þ] 'Á¤º¸½Ã½ºÅÛº¸¾È¿£...
´ã´çÀÚ
0
0
2334
2018-01-22
7241
[¹«·á±³À°/ÈƷúñÁö±Þ] '°ÔÀÓÄÜÅÙÃ÷Á¦ÀÛ' ...
´ã´çÀÚ
0
0
3156
2018-01-22
7240
[Ãë¾÷¹«·á±³À°]Windows/Linux ±â¹ÝÀÇ ½Ã½º...
ÇãÈ¿¼±
0
0
2459
2018-01-22
7239
¢º KG¾ÆÀÌƼ¹ðÅ© °¡»óÈ ½Ã½ºÅÛ ¿£Áö´Ï¾î ...
¾ÆÀÌƼ¹ðÅ©
0
0
2751
2018-01-20
7238
¢º KG¾ÆÀÌƼ¹ðÅ© ³×Æ®¿öÅ©º¸¾È ½Ç¹«ÀÚ ¾ç¼º...
¾ÆÀÌƼ¹ðÅ©
0
0
2230
2018-01-20
7237
¢º KG¾ÆÀÌƼ¹ðÅ© ÀΰÀ¸·Î OCPÃëµæÇϱâ/ ±³...
¾ÆÀÌƼ¹ðÅ©
0
0
3323
2018-01-20
7236
¢ºÇÁ¸®¹Ì¾ö Ãë¾÷Áغñ Ãë¾÷ÄÚĪ¹Ý ¿ÀÇÂ!!
¾ÆÀÌƼ¹ðÅ©
0
0
2097
2018-01-20
7235
¢º KG¾ÆÀÌƼ¹ðÅ© ¸ðÀÇÇØÅ· Ãë¾àÁ¡ ºÐ¼® ½Ç...
¾ÆÀÌƼ¹ðÅ©
0
0
1703
2018-01-20
7234
¢ºKG¾ÆÀÌƼ¹ðÅ© ICTº¸¾È ¿£Áö´Ï¾î ¾ç¼º °ú...
¾ÆÀÌƼ¹ðÅ©
0
0
1821
2018-01-20
811
|
812
|
813
|
814
|
815
|
816
|
817
|
818
|
819
|
820
|
|
|
|
|
Á¦¸ñ ¾øÀ½
À̾ƹäºñÁî ¼³¸³ÀÏ : 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.