ÀÚ¹ÙSOA°í±Þ°³¹ßÀÚ100%Ãë¾÷º¸ÀåÁö¿ø°úÁ¤
ÀÚ¹ÙCBD°³¹ßÀÚ100%Ãë¾÷º¸ÀåÁö¿ø°úÁ¤
¿À¶óŬ(DBA)ÇöÀå½Ç¹«Àü¹®°¡100%Ãë¾÷º¸ÀåÁö¿ø°úÁ¤
¿À¶óŬ(DBA)Àü¹®°¡100%Ãë¾÷º¸ÀåÁö¿ø°úÁ¤
³×Æ®¿öÅ©Àü¹®°¡100%Ãë¾÷º¸ÀåÁö¿ø°úÁ¤
´å³ÝÀü¹®°¡100%Ãë¾÷º¸ÀåÁö¿ø°úÁ¤
100%Ãë¾÷º¸ÀåÁö¿øÁö¿ø½Ã½ºÅÛ±¸Ãà
±¹ºñÁö¿ø Á÷¾÷´É·Â°³¹ß °èÁÂÁ¦



 
¡¤ ¿À¶óŬ Àü¹®°¡ Ãë¾÷´ëºñ¹Ý
¡¤ ¾ÆÀÌÆ¼Àª ±³À°¼¾ÅÍ ¼­¿ïº»¿ø
¡¤ 20¸í (¼±Âø¼ø ¸ðÁý)
¡¤ Áö¿ø¼­, ¼­¾à¼­, ÀÚ±â¼Ò°³¼­.À̷¼­
¡¤ °­»çÇÁ·ÎÇʺ¸±â
 
 
 

¿À¶óŬ DBA Ãë¾÷´ëºñ¹Ý
(DataBase Admini~)

Á÷¾÷´É·Â°³¹ß °èÁÂÁ¦ Àû¿ë
±¹°¡ 200¸¸¿øºÎ´ã
Àںδãºñ¿ë 180¸¸¿ø

¸ðÁý±â¼ö ¹× Ãë¾÷ÁøÇàÇöȲ
´ã´ç°­»ç
±³ À° ±â °£
Á¦ 1±â ~ 15±â Ãë¾÷ÇöȲ ¹× ½ÅÀÔ¿¬ºÀ È®Àΰ¡´É.
Á¦16±â ¼ö¾÷ (°èÁÂÁ¦) ¹æÇü¿Á 2010³â 04¿ù 05ÀÏ ~ (¿ÀÀü¹Ý)
Á¦17±â ¼ö¾÷ (°èÁÂÁ¦) ¼­Áø¼ö 2010³â 05¿ù 10ÀÏ ~ (¿ÀÀü¹Ý)
Á¦18±â ¼ö¾÷ (°èÁÂÁ¦) ¼­Áø¼ö 2010³â 12¿ù 21ÀÏ ~ (¿ÀÈĹÝ)
Á¦19±â ¼ö¾÷ (°èÁÂÁ¦) ±è¿µÁ¶ 2011³â 03¿ù 09ÀÏ ~ (¿ÀÈĹÝ)
Á¦20±â ¼ö¾÷ (°èÁÂÁ¦) ±è¿µÁ¶ 2011³â 04¿ù 21ÀÏ ~ (¿ÀÈĹÝ)
Á¦21±â ¼ö¾÷ (°èÁÂÁ¦) ±è¿µÁ¶ 2011³â 04¿ù 18ÀÏ ~ (¿ÀÀü¹Ý)
Á¦22±â ¼ö¾÷ (°èÁÂÁ¦) ¹æÇü¿í 2011³â 05¿ù 30ÀÏ ~ (¿ÀÈĹÝ)
Á¦23±â ¼ö¾÷ (°èÁÂÁ¦) ±è¿µÁ¶ 2011³â 06¿ù 30ÀÏ ~ (¿ÀÈĹÝ)
Á¦24±â ¼ö¾÷ (°èÁÂÁ¦) ¹æÇü¿í 2011³â 07¿ù 18ÀÏ ~ (¿ÀÀü¹Ý)
Á¦25±â ¼ö¾÷ (°èÁÂÁ¦) ¼­Áø¼ö 2011³â 08¿ù 29ÀÏ ~ (¿ÀÈĹÝ)
Á¦26±â ¼ö¾÷ (°èÁÂÁ¦) ¼­Áø¼ö 2011³â 11¿ù 21ÀÏ ~ (¿ÀÈĹÝ)
Á¦27±â ¼ö¾÷ (°èÁÂÁ¦) ±è¿µÁ¶ 2012³â 01¿ù 04ÀÏ ~ (¿ÀÈĹÝ)
     
     
     
 
 
 
 
 
 
 
¸¹Àº ±â¾÷ÀÌ »õ·Î¿î Àü»ê ȯ°æÀÇ ÀåÁ¡À» Àû±ØÀûÀ¸·Î Ȱ¿ëÇϱâ À§ÇÏ¿© ±âÁ¸ÀÇ µ¥ÀÌÅͺ£À̽º Æ©´×°ú À籸ÃËÀ» ÇÊ¿ä·Î
Çϰí ÀÖ½À´Ï´Ù. ¶ÇÇÑ, µ¥ÀÌÅÍ º£À̽º °ü¸®ÀÚ¸¦ ¿ä±¸Çϰųª ±âÁ¸ »ç¿øÀÇ µ¥ÀÌÅÍ º£À̽º °ü¸®ÀÚ ±³À°À» ¿øÇϰí ÀÖ´Â
±â¾÷ÀÇ ¼ö¿ä°¡ ¸¹¾Æ ÇöÀç µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚÀÇ °ø±ÞÀÌ »ó´çÈ÷ ºÎÁ·ÇÑ »óȲ¿¡¼­ Ãë¾÷ Àü¸ÁÀº ¸Å¿ì ¹à´Ù°í ÇÒ ¼ö ÀÖ½À´Ï´Ù.

 

[Ÿ±³À°±â°üµéÀÇ ¿À¶óŬÃë¾÷¹ÝÀÇ ¹®Á¦Á¡]
1. ½Ç¹«¿¡¼­ »ç¿ëÇÏ´Â OS ´É·ÂÀÌ ºÎÁ·ÇÏ´Ù(hpuxµî)
2. ¿À¶óŬÀº 10g °úÁ¤À» ÁøÇàµÈ(½Ç¹«¿¡¼­´Â ÇÏÀ§¹öÁ¯ ¼³Ä¡¿Í »óÀ§·ÎÀÇ ÆÐÄ¡±â¼úÀ» ¿ä±¸ÇÑ´Ù)
3. ¹öÁ¯º° ¿À¶óŬ ¼³Ä¡/ÆÐÄ¡/¿î¿µ/¹é¾÷º¹±¸µî ¼¼ºÎ°úÁ¤ÀÌ ÀüÇô¾ø´Ù(ÁÖ¿ä¾÷¹«)
4. RAC¿Í °°Àº ½Ç¹«¿¡¼­ ²À ÇÊ¿äÇÑ Áß¿äÇÑ ±â¼úÀÌ °úÁ¤¿¡ ¾ø´Ù.
5. ä¿ë´ã´çÀÚµéÀÌ ¿À¶óŬÃë¾÷¹Ý ¼ö·á»ýµé¿¡ ´ëÇÑ ±â´ë°¡ ÀúÇϵȴÙ

°¢ °ú¸ñº° ÁÖ¿ë³»¿ëÀ» ¿äÇÐÇÏ¸é ¾Æ·¡¿Í °°´Ù.

¼ø¼­ °ú¸ñ ³»¿ë
1 OS
- ¼Ö¶ó¸®½º(9/10) ¼³Ä¡ ¹× ¼¼ÆÃ/¿î¿µ/¿À¶óŬ¼³Ä¡
2 Oracle ¼³Ä¡/ÆÐÄ¡
- ÇÊ¿äÇÑ ÆÐÄ¡ °Ë»ö ¹× ¼³Á¤¹æ¹ý
- °¢ ¹öÁ¯º° ¼³Ä¡(8i/9i/10g/11g)
- °¢ ¹öÁ¯º° ÆÐÄ¡(9.2.0.1 -> 9.2.0.8 / 10.2.0.1 - > 10.2.0.4)
- °¢ OSº° ±âŸ ÆÐÄ¡Àû¿ë
3

Administration

(¿î¿µ / °ü¸® - ¸í·É¾î·Î)

- ¿À¶óŬ ±âÃÊ ¾ÆÅ°ÅØÃ³ ¹× ÀÛµ¿¿ø¸®
- ÆÄ¶ó¹ÌÅÍ ÆÄÀϰü¸®
- control file °ü¸®
- Data file °ü¸® / Dablespace »ý¼­ / À̵¿ /»èÁ¦
- Redo log °ü¸®
- Undo °ü¸®
- User / Privilege / Profile / Role °ü¸®µî
4

Backup & Recovery

(ÀüºÎ ½Ç¹«¿¡¼­ ¹ß»ýÇß´ø Àå¾Ö »óȲº° ½Ç½ÀÀ¸·Î ±¸¼ºµÊ

- Archive log mode / no archive log mode
- backup (hot backup / cold backup)
- Recovery -> incomplete Recovery (No archive mode)
-> time based Recovery (archive mode)
-> using backup controlfile
-> Complete Recovery
- Redo log Recovery
- Control file Recovery
- export / import / datapump / flashback Recovery
- RMAN -> backup ( backup set / image copy)
-> Recovery ( complete / incomplete )

5 Æ©´×

- ¼­¹ö Æ©´× -> instance Æ©´× (DB cache / sp /redo)
-> °¢ file Æ©´×

- SQL Æ©´× -> ¿ÉƼ¸¶ÀÌÁ®
-> À妽º (¿ø¸® / Ư¡ / ÁÖÀÇ»çÇ× µî)
-> Á¶ÀÎ (¿ø¸® / Ư¡ / ÁÖÀÇ»çÇ× µî)
-> Á¤·Ä
-> ½ÇÁ¦ ¿¹Á¦¸¦ ÅëÇÑ Äõ¸® ÀÛ¼º¹æ¹ý

6 RAC / Dataguard - 10g RAC 2 node ¼³Ä¡ -> NFS / ASM / Rawdevice
- RAC ¿î¿µ ¹× Àå¾Ö ´ëó
- Dataguard ¼³Ä¡
- Ÿ Çпø°úÁ¤¿¡¼­´Â ÇÏÁö ¾Ê´Â ÁýÁß ±³À° ÁøÇà
°ú¸ñ ³»¿ë ±â°£
UNIX,LINUX UNIX Essential Course 3ÁÖ
SQL10g - Oracle Database 9i: Introduction to SQL 2ÁÖ
10gWSI - Oracle Database 9i: Oracle9i Database Administration : Fundamentals 2ÁÖ
10gWSII

- Oracle Database 9i: Oracle9i Database Administration : Fundamentals II

2ÁÖ
10gPTW - Oracle Database 9i: Oracle9i Database Administration : Performance Tuning 2ÁÖ
RAC10g - Oracle Database 10g: RAC for Administrators 1ÁÖ
´ë¿ë·® ´ë¿ë·® µ¥ÀÌÅÍ º£À̽º 2ÁÖ
RDM Data Modeling & RDB Design 2ÁÖ
Ãë¾÷ Ư°­ À̷¼­ ÀÛ¼º ¿ä·É, ä¿ë´ã´çÀÚ ¸éÁ¢ ±â¼ú, Á÷ÀåÀÎÀÇ ±âº»¼Ò¾ç ÀλçÀü¹®CEO
 
°ü°èÇü µ¥ÀÌÅͺ£À̽ºÀÇ ±âº» °³³ä ÇнÀ ¹× °ü°èÇü µ¥ÀÌÅÍ ¸ðµ¨ÀÇ °³³äÀ» ÇнÀÇÕ´Ï´Ù. OracleÀ» ¼³Ä¡ ÇØº¸°í OracleÀÇ ±¸Á¶¸¦ ÇнÀÇϸç, OracleÀ» »ç¿ëÇϱâ À§ÇÑ ±âº» SQL ¹× OracleÀÇ Å×ÀÌºí½ºÆäÀ̽º¸¦ ÀÌÇØÇÏ´Â °Í°ú µ¿½Ã¿¡ OracleÀÇ ÁÖ¿ä °´Ã¼µéÀ» ¾Ë¾Æº¸°í ½Ç½ÀÀ» ÅëÇØ Ȱ¿ë¹ýÀ» ½ÀµæÇÕ´Ï´Ù.
 

1. Ãë¾÷ÀÌ ÃÖ¿ì¼±ÀÌ´Ù.
2. ÀÔÇнÿ¡ Ãë¾÷ °¡´ÉÇÑ ±³À°È¸¿ø´Ô¸¸ ¼±º°.
3. ¸Å °úÁ¤ÀÌ ³¡³¯¶§¸¶´Ù Áø±Þ½ÃÇèÀ» Ä£´Ù.
4. ¾îµå¹Î/¹é¾÷º¹±¸/RAC°úÁ¤Àº Ưº°È÷ ¼öÇàÇÏ´Â ¸ðµç ³»¿ëÀ» ÇÁ·ÎÁ§Æ®·Î ÁøÇàÇØ Æ÷Æ®Æú¸®¿À·Î ¸¸µç´Ù .
5. Á¹¾÷½ÃÇèÀ» Ãļ­ ¼ºÀû¼øÀ¸·Î Ãë¾÷ÃßõÇÔ.
6. ÇöÀå ½Ç½ÀÀ» º´ÇàÇØ¼­ ½Ç¹«°¨°¢°ú ÀÌÇØµµ¸¦ ³ôÀδÙ.
7. Á¹¾÷½ÃÁ¡ Àü¿¡ OCP/SCSA ÀÚ°ÝÁõ Çʼö Ãëµæ ¹× Æ÷Æ®Æú¸®¿À ÀÛ¼º.

 

¸¹Àº ±â¾÷ÀÌ »õ·Î¿î Àü»ê ȯ°æÀÇ ÀåÁ¡À» Àû±ØÀûÀ¸·Î Ȱ¿ëÇϱâ À§ÇÏ¿© ±âÁ¸ÀÇ µ¥ÀÌÅͺ£À̽º Æ©´×°ú À籸ÃàÀ» ÇÊ¿ä·Î Çϰí ÀÖ´Ù. ¶ÇÇÑ, µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ¸¦ ¿ä±¸Çϰųª ±âÁ¸ »ç¿øÀÇ µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ ±³À°À» ¿øÇϰí ÀÖ´Â ±â¾÷ÀÇ ¼ö¿ä°¡ ¸¹¾Æ ÇöÀç µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚÀÇ °ø±ÞÀÌ »ó´çÈ÷ ºÎÁ·ÇÑ »óȲ¿¡¼­ Ãë¾÷ Àü¸ÁÀº ¸Å¿ì ¹à´Ù°í ÇÒ ¼ö ÀÖ´Ù.

µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ´Â ÃÊÀÓÀ¸·Î ¿¬ºÀ1,800¿¡¼­ 2,800¸¸¿ø Á¤µµ¸¦ ¹Þ°í, 5³â Á¤µµÀÇ °æ·ÂÀ» ½×À¸¸é ¿¬ºÀ 5,000¿¡¼­ 6,000¸¸¿ø Á¤µµ¸¦ ¹Þ°Ô µÈ´Ù. ±×·¯³ª ±â¾÷ÀÌ µ¥ÀÌÅͺ£À̽ºÀÇ Á»´õ ¾ÈÀüÇÏ°í ´Ù¾çÇÑ È°¿ëÀ» ¿ä±¸Çϰí ÀÖ´Â »óȲÀ̾ µ¥ÀÌÅͺ£À̽º °ü¸®Àڷμ­ÀÇ ¾÷¹« ¼öÇà ´É·ÂÀÌ ¶Ù¾î³­ °æ¿ì ´õ ÁÁÀº Á¶°ÇÀÇ È¸»ç·Î ÁÁÀº Á¶°Ç¿¡ ½ºÄ«¿ìÆ®µÇ°í ÀÖ´Ù.
[¾ÆÀÌÆ¼Àª '¿À¶óŬÀü¹®°¡ 100%Ãë¾÷´ëºñ¹Ý'ÀÇ ±³À°ÀÇ Æ¯Â¡]
- º»Ãë¾÷¹ÝÀÇ Æ¯Â¡Àº ±â¾÷ ¸ÂÃã½Ä±³À° Àη¾缺°úÁ¤À¸·Î ±âÃÊ, Áß±Þ, Áß°í±Þ, °í±Þ, ÀÀ¿ëÁß°í±Þ, ÀÀ¿ë°í±ÞµîÀÇ Çаú°øºÎ¿Ü¿¡ Ãë¾÷ÇÁ·ÎÁ§Æ®µîÀÇ ¹ßÇ¥¸¦ ÅëÇÑ ±â¾÷ÀÇ Çö Á÷Àå¾÷¹«¸¦ ¸ðÅ·ÎÇϰíÀÖ´Ù.

 
°ú¸ñ ±â°£ ³»¿ë
UNIX / LINUX/HPUX
UNIX Essential Course
4ÁÖ
º» °úÁ¤Àº ¼ö°­»ýµé¿¡°Ô µ¥½ºÅ©Åé ½Ã½ºÅÛÀÇ ÄÄÆ÷³ÍÆ® »ç¿ë, ÆÄÀÏ ¹× µð·ºÅ丮 °ü¸®,
ÆÄÀÏ ÀÛ¼º ¹× º¯°æ, »ç¿ëÀÚ ÀÛ¾÷ ȯ°æ °ü¸®, ÆÄÀÏ º¸°ü, ¿ø°Ý ¸í·É¾î¸¦ »ç¿ëÇÏ´Â µ¥
ÇʼöÀûÀÎ Áö½Ä ¹× ±â¼ú°ú ¼ÒÇÁÆ®¿þ¾î ¼³Ä¡, ÆÄÀÏ ½Ã½ºÅÛ °ü¸®, ½Ã½ºÅÛ ºÎÆ®
ÇÁ·Î½ÃÀú ¼öÇà, »ç¿ëÀÚ ¹× º¸¾È °ü¸® ¼öÇà, ³×Æ®¿öÅ© ÇÁ¸°ÅÍ ¹× ½Ã½ºÅÛ ÇÁ·Î¼¼½º
°ü¸®¿Í ½Ã½ºÅÛ ¹é¾÷ ¹× º¹±¸ ¼öÇà°ú °°Àº Solaris 9 ¿î¿µÈ¯°æ¿¡¼­ ÇʼöÀûÀÎ
½Ã½ºÅÛ °ü¸® ¾÷¹«µéÀ» ¼öÇàÇϴµ¥ ÇʼöÀûÀÎ Áö½Ä ¹× ±â¼úÀ» ±³À°ÇÕ´Ï´Ù.
- (¼Ö¶ó¸®½º/¸®´ª½º/HPUXµîÀÇ ¿î¿µ¹æ¹ý)
SQL9i
Oracle Database9i:
Introduction to Oracle9i : SQL
2ÁÖ

Object Database¿Í Relational DatabaseÀÇ ÁÖ¿ä °³³äÀ» ¼Ò°³Çϰí ÀÖÀ¸¸ç °³¹ßÀÚ°¡ È¿À²ÀûÀ¸·Î Oracle9i Database¿Í »óÈ£ÀÛ¿ëÀ» ÇÏ´Â °Í¿¡ ÁßÁ¡À» µÎ°í ÀÖ½À´Ï´Ù. °ü°èÇü µ¥ÀÌŸº£À̽ºÀÇ °³³ä°ú SQL ¾ð¾îÀÇ »ç¿ë¹ýÀ» ÇнÀÇÏ´Â °úÁ¤ÀÔ´Ï´Ù. ÀÌ °úÁ¤¿¡¼­ ¼ö°­»ýµéÀº µ¥ÀÌŸº£À̽º ¿ÀºêÁ§Æ®¸¦ »ý¼ºÇÏ°í °ü¸®ÇÏ´Â ¹æ¹ý, µ¥ÀÌŸ¸¦ ÀúÀåÇÏ°í °Ë»ö, Á¶ÀÛÇÏ´Â ¹æ¹ýÀ» ¹è¿ï ¼ö ÀÖ½À´Ï´Ù.

ROLLUP, CUBE, subquery, ÁýÇÕ ¿¬»êÀÚ, °èÃþÇü ÁúÀÇ µîÀÇ Çâ»óµÈ ±â¼ú°ú multi table inserts, grouping with sets, WITH Àý µî Oracle9iÀÇ »õ·Î¿î ±â´É, ±×¸®°í SQL ¹× iSQL*Plus ½ºÅ©¸³Æ® ÆÄÀÏ ÀÛ¼º¹ýÀ» °­ÀÇ¿Í ½Ç½ÀÀ» ÅëÇØ ÀÍÈú ¼ö ÀÖ½À´Ï´Ù.
- ¿À¶óŬ¼³Ä¡(8i, 9i, 10g, 11g) ¹× ÆÐÄ¡Àû¿ë
- SQL ±âÃÊÀÛ¼º ´É·Â

ADM9i
Oracle Database 9i:
Oracle9i Database Administration : Fundamentals I
2ÁÖ

¿À¶óŬ ¼­¹ö µ¥ÀÌÅͺ£À̽º¸¦ °ü¸®ÇÏ°í ±¸¼ºÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ ÄÚ½ºÀÔ´Ï´Ù. ¿À¶óŬ ÀνºÅϽº¿Í ¸Þ¸ð¸® ÄÄÆ÷³ÍÆ®¸¦ ±¸¼ºÇÏ°í ½ÃÀÛÇÏ¸ç ¿À¶óŬ µ¥ÀÌÅͺ£À̽º repository¸¦ »ý¼ºÇÏ´Â ¹æ¹ý, ¹°¸®Àû°ú ³í¸®Àû µ¥ÀÌÅͺ£À̽º °´Ã¼¸¦ »ý¼ºÇϰí Oracle Enterprise Manager¸¦ »ç¿ëÇÏ´Â ¹æ¹ýµµ ¹è¿ì°Ô µË´Ï´Ù.

ÀÌ °úÁ¤¿¡¼­ ¼ö°­»ýµéÀº Oracle9i database ±¸Á¶¿¡ ´ëÇÑ °³³äÀû ÀÌÇØ¸¦ ¾òÀ» ¼ö ÀÖ½À´Ï´Ù.

µ¥ÀÌŸº£À̽º¸¦ »ý¼ºÇϰí È¿À²ÀûÀÎ ¹æ½ÄÀ¸·Î °ü¸®ÇÏ´Â ¹æ¹ýÀ» ÇнÀÇÒ ¼ö ÀÖ½À´Ï´Ù. ¶ÇÇÑ µ¥ÀÌŸº£À̽º °ü¸®µµ±¸¸¦ ÀÌ¿ëÇØ DBA ¾÷¹«¸¦ ¼öÇàÇÏ´Â ½Ç½ÀÀ» ÅëÇØ µ¥ÀÌŸº£À̽º °ü¸®¸¦ À§ÇÑ ´Ù¾çÇÑ ¸í·É¹®µéÀ» ÀÍÈú ¼ö ÀÖ½À´Ï´Ù.
- 9i ¹öº¯À» ±âÃÊ·Î ¿À¶óŬ ±¸Á¶, ¿ì³ç¹æ¹ýµîÀ» ¸í·É¾î¸¦ °¡Áö°í ¿î¿µÇÏ´Â ¹ý

NBR9i
Oracle Database 9i:
Oracle9i Database Administration : Fundamentals II
2ÁÖ

Oracle9i databaseÀÇ Oracle9i server architecture¿Í system resources¸¦ °ü¸®ÇÏ´Â ¿©·¯ °¡Áö advanced options¿¡ ´ëÇØ¼­ ´Ù·ç°Ô µË´Ï´Ù. °¡Àå Áß¿äÇÑ ³×Æ®¿öÅ· ºÎºÐ°ú ¹é¾÷/º¹±¸ ºÎºÐÀ¸·Î ³ª´©¾î¼­ ÁøÇàµË´Ï´Ù.

ÀÌ °úÁ¤¿¡¼­ ¼ö°­»ýµéÀº µ¥ÀÌŸº£À̽º¿¡ data loading ¹× transporting À» ¼öÇàÇÏ´Â ¹æ¹ý, µ¥ÀÌŸº£À̽º ¹é¾÷ ¹× º¹±¸ ¹æ¹ý, µ¥ÀÌŸº£À̽º ¹é¾÷ ¹× º¹±¸ À¯Æ¿¸®Æ¼ÀÎ Recovery Manager (RMAN)À» »ç¿ëÇÏ¿© ¹é¾÷ ¹× º¹±¸¸¦ ¼öÇàÇÏ´Â ¹æ¹ý µîÀ» ÇнÀÇÕ´Ï´Ù. ¶ÇÇÑ ¿À¶óŬ ³×Æ®¿öÅ© ¼Ö·ç¼ÇÀÇ ±â´É°ú ¼³Á¤ ¹æ¹ý ¹× ³×Æ®¿öÅ© ¹®Á¦ ÇØ°á ¹æ¹ý¿¡ ´ëÇØ¼­µµ ÇнÀÇÏ°Ô µË´Ï´Ù. ÀÌ °úÁ¤À» ÅëÇØ ¼ö°­»ýµéÀº ³×Æ®¿öÅ©, µ¥ÀÌŸº£À̽º ¹é¾÷ ¹× º¹±¸¿¡ °üÇÑ ´Ù¾çÇÑ ½Ã³ª¸®¿ÀÀÇ ½Ç½ÀÀ» ¼öÇàÇØ º¼ ¼ö ÀÖ½À´Ï´Ù.

- ¿À¶óŬ °ü·Ã Àå¾Ö¸¦ ÇØ°áÇÏ´Â ¹æ¹ý
PTW9i
Oracle Database 9i:
Oracle9i Database Administration : Performance Tuning
1ÁÖ

Performance¿Í tuningÀ» ÇÏ´Â advanced skillsÀ» ¹è¿ì´Â ÄÚ½º·Î¼­ ¼º´É Åë°è¸¦ ºÐ¼®Çϰí physical I/O¸¦ ÁÙÀ̴ ij½¬ ¿µ¿ªÀ» Æ©´×Çϰí internal Oracle structures¿Í physical database structuresÀÇ ¹®Á¦¸¦ ÃÖ¼ÒÈ­ÇÏ´Â ¹æ¹ýÀ» ¹è¿ó´Ï´Ù.

¼ö°­»ýµéÀº ÀÌ °úÁ¤À» ÅëÇØ µ¥ÀÌŸº£À̽º¿Í ÀνºÅϽºÀÇ Æ©´×¿¡ °üÇÑ °³³äÀ» ½ÀµæÇÏ°í ½Ç½ÀÀ» ÅëÇØ ½ÇÁ¦·Î ¿À¶óŬ µ¥ÀÌŸº£À̽ºÀÇ ¼º´É¿¡ °ü·ÃµÈ ¹®Á¦µéÀ» ÀνÄÇϰí ÇØ°áÇÏ´Â ¹æ¹ýÀ» ÇнÀÇÒ ¼ö ÀÖ½À´Ï´Ù

´ë¿ë·® 2ÁÖ
½Ç¹« °³¹ßÀÚµéÀ» À§ÇÑ ´ë¿ë·® ¿À¶óŬ Æ©´×ÀÇ ±âº» ±â¼ú ¹× SQL ¹®Àå Æ©´×ÀÇ ±âº» °³³ä ½Àµæ
RAC 10g / DataguardOracle Database 10g: RAC for Administrators 2ÁÖ
ÀÌ °úÁ¤¿¡¼­´Â Oracle RAC(Real Application Clusters)¿ë Oracle Database 10g Release 2ÀÇ ÀϹÝÀûÀΠƯ¡ ¹× ±â´ÉÀ» ¼Ò°³ÇÕ´Ï´Ù. ¼ö°­»ýµéÀº OracleClusterware, RAC(Real Application Clusters) ¹× Automatic Storage Management¸¦ ¼³Ä¡ÇÏ°í ±¸¼ºÇÏ´Â ¹æ¹ýÀ» ¹è¿ó´Ï´Ù. ¶ÇÇÑ Enterprise Manager Grid ControlÀ» »ç¿ëÇÏ¿© RAC(Real Application Clusters)¿¡¼­ µ¥ÀÌÅͺ£À̽º¸¦ °ü¸®ÇÏ´Â ¹æ¹ýÀ» ¹è¿ì°Ô µË´Ï´Ù. RAC ȯ°æ¿¡¼­ µ¥ÀÌÅͺ£À̽º ¼­ºñ½º ¹× Load Balancing Advisory ±¸¼º ¹× »ç¿ë ¹æ¹ýÀ» ÀÍÇô È¿À²¼ºÀ» ³ôÀÏ ¼ö ÀÖ½À´Ï´Ù. Ŭ·¯½ºÅÍ¿¡¼­ ³ëµå¸¦ Ãß°¡Çϰí Á¦°ÅÇÏ´Â ¹æ¹ý ¹× Oracle Clusterware¿Í RAC(Real Application Clusters) ¼ÒÇÁÆ®¿þ¾î¸¦ ·Ñ¸µ ¹æ½ÄÀ¸·Î µÑ ´Ù ÆÐÄ¡ÇÏ´Â ¹æ¹ýÀ» ¹è¿ó´Ï´Ù.
- 10g·Î RAC¸¦ Á÷Á¢ ±¸ÇöÇÏ°í ¿î¿µÇÏ´Â ¹æ¹ý/Dataguard¸¦ ¼³Ä¡ÇÏ°í ¿î¿µÇÏ´Â ¹æ¹ý
RDM
Data Modeling & RDB Design
1ÁÖ Entity Relationship (ER) Modeling°ú °ü°èÇü µ¥ÀÌÅͺ£À̽º ¼³°è ¹æ¹ý¿¡ ´ëÇØ
ÇнÀÇÏ´Â °úÁ¤ÀÌ´Ù. ÀÌ °úÁ¤¿¡¼­ ¼ö°­»ýµéÀº ¿©·¯ °¡Áö ¾÷¹« ¿ä±¸ »çÇ×°ú °ü·ÃµÈ
´Ù¾çÇÑ ¿¹Á¦½Ç½ÀÀ» ÅëÇÏ¿© ER ModelÀ» ÀÛ¼ºÇÏ´Â ¹æ¹ýÀ» ½ÀµæÇÒ ¼ö ÀÖÀ¸¸ç À̸¦
¹ÙÅÁÀ¸·Î °ü°èÇü µ¥ÀÌÅͺ£À̽º¸¦ ¼³°èÇÏ´Â °úÁ¤°ú ¾ÈÁ¤ÀûÀÌ°í °ü¸®°¡ ¿ëÀÌÇϵµ·Ï
Àß ¼³°èµÈ °ü°èÇü µ¥ÀÌÅͺ£À̽º¸¦ ±¸ÃàÇϱâ À§ÇÏ¿© °í·ÁÇØ¾ß ÇÒ »çÇ׵鿡
°üÇØ ÇнÀÇÒ ¼ö ÀÖ´Ù.
- ±âÃʸ𵨸µ ±â¼ú
Ãë¾÷ Ư°­  
- À̷¼­ ÀÛ¼º ¿ä·É, ä¿ë´ã´çÀÚ ¸éÁ¢ ±â¼ú, Á÷ÀåÀÎÀÇ ±âº»¼Ò¾ç(ÀλçÀü¹®CEO)

- Á¤±Ôº´
°í·Á´ë »çȸÇаú Á¹¾÷, °í·Á´ë °íÀ°´ëÇпø Á¹¾÷, (ÁÖ)Çѱ¹¸®´õ½Ê¼¾ÅÍ »ó¹«ÀÌ»ç,
ENKºê·¹ÀδëÇ¥(ÇöÀç)

- °­¼º·æ
¿¬¼¼´ë µ¶¹®°ú Á¹¾÷,¿¬¼¼´ë ±³À°´ëÇпøÁ¹¾÷, ÇѼֱ׷ì ÀÎÀç°³¹ßÆÀ,
(ÁÖ)Cyber BMAÀÌ»ç ,Àª¸¶Æ® ÀÎÀç°³¹ßÆÀºÎÀå, ÀÎÀç°³¹ß ÄÁ¼³ÆÃ»ç »ó¹«(ÇöÀç)

- ±è¼®Áø
±¤¿î´ë ÀüÀÚ°øÇаú Á¹¾÷,¿¬¼¼´ë ±³À°´ëÇпø Á¹¾÷, (ÁÖ)½Ã±×¸¶¿ÍÀÌÁî ÀÌ»ç,
(ÁÖ)EM Beidge´ëÇ¥ÀÌ»ç(ÇöÀç)

- ÃÖÇõÁØ
¿¬¼¼´ë°æÁ¦Çаú Á¹¾÷,Æ÷Ç×°ø´ë»ê¾÷°øÇдëÇпøÁ¹¾÷,ÇѼֱ׷ìÀü·«±âȹÆÀ,
´ë»óÁ¤º¸Åë½Å»ó¹«, (ÁÖ)¶óÀÓ ±Û·Îºê ´ëÇ¥ÀÌ»ç(ÇöÀç)

- ÀÌÆÇÁ¤
(ÁÖ)³ÝÇǾƴåÄÄ ´ëÇ¥ÀÌ»ç(ÇöÀç)

- ¿ÀÄ¡¿µ
(ÁÖ)Áö¶õÁö±³ ¼ÒÇÁÆ® ´ëÇ¥ÀÌ»ç(ÇöÀç)
ÀÌ °úÁ¤Àº ´Ü°ú¹ÝÀ» Á¶ÇÕ½ÃŲ °úÁ¤ÀÌ ¾Æ´Ñ Ãë¾÷À» ÁغñÁßÀÎ ºÐµéÀ» À§ÇÑ Ãë¾÷º¸Àå±³À°°úÁ¤ÀÔ´Ï´Ù.
°ú¸ñ ±â°£ ³»¿ë
UNIX / LINUX 3ÁÖ
- UNIX Essential Course
SQL 9i 2ÁÖ
- Oracle Database 9i: Introduction to SQL
ADM9i 2ÁÖ
- Oracle Database 9i: Oracle9i Database Administration : Fundamentals
NBR9i 2ÁÖ

- Oracle Database 9i: Oracle9i Database Administration : Fundamentals II

PTW9i 2ÁÖ

- Oracle Database 9i: Oracle9i Database Administration : Performance Tuning

RAC10g 1ÁÖ - Oracle Database 10g: RAC for Administrators
´ë¿ë·® DBÆ©ÆÃ 2ÁÖ
- ¿À¶óŬ ´ë¿ë·® µ¥ÀÌÅÍ º£À̽º
RDM 2ÁÖ
- Data Modeling & RDB Design
Ãë¾÷ Ư°­  
- À̷¼­ ÀÛ¼º ¿ä·É, ä¿ë´ã´çÀÚ ¸éÁ¢ ±â¼ú, Á÷ÀåÀÎÀÇ ±âº»¼Ò¾ç(ÀλçÀü¹®CEO)
°ú¸ñ ±â°£ ³»¿ë
UNIX / LINUX 3ÁÖ
- ¼ÒÇÁÆ®¿þ¾î ¼³Ä¡, ÆÄÀÏ ½Ã½ºÅÛ °ü¸®, ½Ã½ºÅÛ ºÎÆ® ÇÁ·Î½ÃÀú ¼öÇà
- »ç¿ëÀÚ ¹× º¸¾È °ü¸® ¼öÇà, ³×Æ®¿öÅ© ÇÁ¸°ÅÍ ¹× ½Ã½ºÅÛ ÇÁ·Î¼¼½º °ü¸®
- ½Ã½ºÅÛ ¹é¾÷ ¹× º¹±¸ ¼öÇà ½Ã½ºÅÛ ¹é¾÷ ¹× º¹±¸ ¼öÇà
- °¡»óÆÄÀϽýºÅÛ, ÄÚ¾î´ýÇÁ ºÐ¼® ¹× °ü¸®, ½ºÅ丮Áö °ü¸®
- ½Ã½ºÅÛ ¸Þ½Ã¡ ±¸¼º ¹× Á¶Á¤, NIS ³×ÀÌ¹Ö ¼­ºñ½º ±¸Ãà
SQL9i
Oracle Database9i:
Introduction to
Oracle9i : SQL
2ÁÖ
- RDBMS¿Í ORDBMSÀÇ ±âº» °³³ä
- ±âº» Query ÀÛ¼ºÇϱâ : SELECT
- Single Row Functions, Group Functions
- Join, Subquery
- iSQL*Plus ȯ°æ¿¡¼­ Query ÀÛ¼º ¹× ½ºÅ©¸³Æ® ÆÄÀÏ »ý¼ºÇϱâ
- Data Manipulation Language(DML) : INSERT, UPDATE, DELETE
- Tables, Constraints, Views, Sequences, Indexes, Synonyms »ý¼º ¹× °ü¸®
- User, Role, PrivilegeÀÇ °³³ä ¹× °ü¸® ¹æ¹ý
- ÁýÇÕ ¿¬»êÀÚ(Set Operators)
- Oracle9i Single Row Functions
- ROLLUP, CUBE, GROUPING Function, GROUPING SETS, WITH Àý
- °èÃþÇü ÁúÀÇ(Hierarchical Retrieval)
- Multitable Inserts
ADM9i
Oracle Database 9i:
Oracle9i Database
Administration :
Fundamentals
2ÁÖ
- Oracle9i ¼­¹ö±¸Á¶
- Oracle instance¿Í databaseÀÇ startup,shutdown
- Database »ý¼ºÇϱâ
- Oracle database file °ü¸®
- OMF¸¦ ÀÌ¿ëÇÑ Oracle database file °ü¸®
- Storage Structure(Tablespace,segment,extent,block) °ü¸®
- Undo data °ü¸®
- Table, Index, Data Integrity °ü¸®
- User,privilege,resource °ü¸®
- Data Loading
- National Language Support ±â´É »ç¿ëÇϱâ
NBR9i
Oracle Database 9i:
Oracle9i Database
Administration :
Fundamentals II
2ÁÖ

- Oracle9i ³×Æ®¿öÅ© ¼Ö·ç¼Ç
- Oracle Net ±âº» ±¸Á¶
- Oracle Net Server-side ±¸¼º
- Oracle Net Client-side ±¸¼º
- Oracle Shared Server ±¸Á¶ ¹× ¼³Á¤ ¹æ¹ý
- µ¥ÀÌŸº£À̽º ¹é¾÷ ¹× º¹±¸ °³³ä
- Instance¿Í Media º¹±¸ ±¸Á¶
- µ¥ÀÌŸº£À̽º Archivelog mode ¼³Á¤
- Oracle Recovery Manager(RMAN) °³³ä ¹× ¼³Á¤ ¹æ¹ý
- »ç¿ëÀÚ°¡ ¼öµ¿À¸·Î ¹é¾÷Çϱâ
- RMANÀ» »ç¿ëÇÏ¿© ¹é¾÷Çϱâ
- »ç¿ëÀÚ°¡ ¼öµ¿À¸·Î ¿ÏÀü, ºÒ¿ÏÀü º¹±¸Çϱâ
- RMANÀ» »ç¿ëÇÏ¿© ¿ÏÀü, ºÒ¿ÏÀü º¹±¸Çϱâ
- RMAN Repository °ü¸® ¹æ¹ý ¹× Catalog »ý¼º°ú »ç¿ë¹ý
- Export/Import

PTW9i
Oracle Database 9i:
Oracle9i Database
Administration :
Performance Tuning
2ÁÖ

- Oracle9i Performance Tuning Overview
- Áø´Ü ¹× Æ©´× µµ±¸ (Alert file, Trace file, Dynamic Performance Views, STATSPACK, UTLBSTAT/UTLESTAT Utilities, Enterprise Manager)
- Shared Pool Tuning
- Buffer Cache Tuning
- Redo Log Buffer Tuning
- Java Pool Tuning
- Database Configuration and I/O Issues
- Oracle BlockÀÇ È¿À²Àû »ç¿ë
- Sort OperationÀÇ ÃÖÀûÈ­
- Latch Contention Áø´ÜÇϱâ
- Rollback(or UNDO) Segments Tuning
- Lock ContentionÀÇ Monitoring
- Oracle Shared Server Tuning
- Application Tuning (Cluster, Index, Index Organized Table, Materialized View)
- Database Storage Tuning
- SQL ¹®Àå Tuning (Optimizer mode, Stored Outlines, SQL ¹®Àå Áø´Üµµ±¸, Hint, Åë°è °ü¸®)
- O/S Tuning ¹× Resource Manager »ç¿ëÇϱâ

´ë¿ë·® µ¥ÀÌÅͺ£À̽º 2ÁÖ - ½Ç¹« °³¹ßÀÚµéÀ» À§ÇÑ ´ë¿ë·® ¿À¶óŬ Æ©´×ÀÇ ±âº» ±â¼ú ¹× SQL ¹®Àå Æ©´×ÀÇ ±âº» °³³ä ½Àµæ
RAC 10g / Dataguard
Oracle Database 10g:
RAC for Administrators
1ÁÖ - Oracle Clusterware ¹× RAC(Real Application Clusters) ¼³Ä¡
- Oracle Clusterware °ü¸®
- RAC µ¥ÀÌÅͺ£À̽º °ü¸®
- Ŭ·¯½ºÅÍ¿¡¼­ ³ëµå Ãß°¡/Á¦°Å
- RAC ȯ°æ¿¡¼­ µ¥ÀÌÅͺ£À̽º ¼­ºñ½º °ü¸®
- ·Ñ¸µ ¹æ½ÄÀ¸·Î Oracle Clusterware ¹× RAC ¼ÒÇÁÆ®¿þ¾î ÆÐÄ¡
RDM
Data Modeling & RDB Design
1ÁÖ
- Entity Relationship (ER) Modeling°ú °ü°èÇü µ¥ÀÌÅͺ£À̽º ¼³°è ¹æ¹ý
Ãë¾÷ Ư°­  
- À̷¼­ ÀÛ¼º ¿ä·É, ä¿ë´ã´çÀÚ ¸éÁ¢ ±â¼ú, Á÷ÀåÀÎÀÇ ±âº»¼Ò¾ç(ÀλçÀü¹®CEO)
 
¿ÀÀü Ãë¾÷¹Ý ¿ÀÈÄ Ãë¾÷¹Ý Àú³á¹Ý ÁÖ¸»¹Ý
[¿ù~±Ý] 09:00 ~ 13:00 [¿ù~±Ý] 14:00 ~ 18:00 [¿ù~±Ý] ÇØ´ç»çÇ×¾ø½¿ Åä] ÇØ´ç»çÇ×¾ø½¿
ÀÏ] ÇØ´ç»çÇ×¾ø½¿

 
±³À°Àοø : 20¸í
´ë»óÀÚ : ¸¸ 30¼¼ ¹Ì¸¸ÀÇ Àü¹®´ëÀÌ»ó Á¹¾÷¿¹Á¤ÀÚ ¹× Á¹¾÷ÀÚ (°íÁ¹ÀÌ»ó Áö¿ø°¡´É, ´Ü ¿­½ÉÈ÷ ÇÏ¼Å¾ß ÇÕ´Ï´Ù.)

Á¢¼ö¼­·ù
Áö¿ø¼­, ¼­¾à¼­ ,
ÀÚ±â¼Ò°³¼­, À̷¼­(ÀÚÀ¯¾ç½Ä, »çÁø ÇÊÈ÷ ÷ºÎÇÒ °Í)

 
¿ùº° ¼ö¾÷ (ÃÑ 5°³¿ù±³À°)
Á¤±Ô ±â¼ú ½Àµæ ¼ö¾÷: 80½Ã°£*5°³¿ù
ÆÀº° ¹× °³Àκ° °úÁ¦ ÇØ°á ½Ç½À: 50½Ã°£ * 6°³¿ù
ÀÏÀÏ ¼ö¾÷(¿ù20ÀϱâÁØ)
Á¤±Ô ±â¼ú ½Àµæ ¼ö¾÷: 4½Ã°£*20ÀÏ
ÆÀº° ¹× °³Àκ° °úÁ¦ ÇØ°á ½Ç½À: 2.5½Ã°£ *20ÀÏ
 

ÃÑ ±³À°ºñ : 760¸¸¿ø (5°³¿ù)

º»ÀÎ ºÎ´ã±Ý : 180¸¸¿ø (¡Ø ¾ÆÀÌÆ¼Àª + Ãë¾÷Çù·Â¾÷ü ±³À°ºñ 50% Áö¿ø / °èÁÂÁ¦Áö¿ø : 200¸¸¿ø)

 
1´Ü°è - UNIX Essential Course 3ÁÖ
NO. ¼¼ºÎ ³»¿ë
1 Solaris Fundamental
  - Installing the Solaris Operating System
  - Solaris Operating System Overview
  - Command-Line Features and Help Resources
  - Management File system Basic
  - Searching Files and Directories
  - Visual Editor
  - File Permission Basic
  - Process and Job Control
  - Remote Connection CMD(s)
  - Archives & Compressing
  - Korn Shell Charateristi
2 Linux
  - ¸®´ª½º ¼³Ä¡
  - Linux ¹èÆ÷ÆÇ, Çϵå¿þ¾î ¿ä±¸»çÇ×
  - ½© »ç¿ëÇϱâ, Command Line »ç¿ë, ȯ°æº¯¼ö¿Í ¼³Á¤, ÇÁ·Î¼¼½º °ü¸®
  - Software ¼³Ä¡Çϱâ, °øÀ¯µÈ ¶óÀ̺귯¸® °ü¸®
  - Processing Text, ÀÔÃâ·Â ÀÛ¾÷, ÇÊÅÍ·Î Text ¼öÁ¤
  - Partitions°ú File Systems
  - Files °ü¸®, Managing Files, °èÃþ±¸Á¶ÀÇ ÀÌÇØ, File Link ¸¸µé±â
  - Permission ÀÛ¾÷Çϱâ
  - Documentation »ç¿ë, Man Pages »ç¿ëÇϱâ, /usr/doc³» ¹®¼­ÀÛ¾÷
  - Boot Process, LILO »ç¿ë, Runlevels°ú init, Boot Process Ä¿½ºÅ͸¶ÀÌ¡
  - X Window System, X ¼³Ä¡Çϱâ
  - Users¿Í Groups °ü¸®
  - ½Ã½ºÅÛ Administering, Daemons ½ÃÀÛ°ú Á¾·á, È¿À²ÀûÀÎ ¹é¾÷
  - Printing, Printers ¼³Ä¡
  - Kernel ¸ðµå ÀÛ¾÷Çϱâ
  - Shells°ú Scripts ÀÛ¾÷, vi »ç¿ëÇϱâ
2´Ü°è - SQL9i(Oracle Database 9i: Introduction to SQL) 2ÁÖ
1Z0-007 : Introduction to Oracle9i : SQL
¼Ò°³

Object Database¿Í Relational DatabaseÀÇ ÁÖ¿ä °³³äÀ» ¼Ò°³Çϰí ÀÖÀ¸¸ç °³¹ßÀÚ°¡ È¿À²ÀûÀ¸·Î Oracle9i Database¿Í »óÈ£ÀÛ¿ëÀ» ÇÏ´Â °Í¿¡ ÁßÁ¡À» µÎ°í ÀÖ½À´Ï´Ù. °ü°èÇü µ¥ÀÌŸº£À̽ºÀÇ °³³ä°ú SQL ¾ð¾îÀÇ »ç¿ë¹ýÀ» ÇнÀÇÏ´Â °úÁ¤ÀÔ´Ï´Ù. ÀÌ °úÁ¤¿¡¼­ ¼ö°­»ýµéÀº µ¥ÀÌŸº£À̽º ¿ÀºêÁ§Æ®¸¦ »ý¼ºÇÏ°í °ü¸®ÇÏ´Â ¹æ¹ý, µ¥ÀÌŸ¸¦ ÀúÀåÇÏ°í °Ë»ö, Á¶ÀÛÇÏ´Â ¹æ¹ýÀ» ¹è¿ï ¼ö ÀÖ½À´Ï´Ù.

ROLLUP, CUBE, subquery, ÁýÇÕ ¿¬»êÀÚ, °èÃþÇü ÁúÀÇ µîÀÇ Çâ»óµÈ ±â¼ú°ú multi table inserts, grouping with sets, WITH Àý µî Oracle9iÀÇ »õ·Î¿î ±â´É, ±×¸®°í SQL ¹× iSQL*Plus ½ºÅ©¸³Æ® ÆÄÀÏ ÀÛ¼º¹ýÀ» °­ÀÇ¿Í ½Ç½ÀÀ» ÅëÇØ ÀÍÈú ¼ö ÀÖ½À´Ï´Ù.


³»¿ë RDBMS¿Í ORDBMSÀÇ ±âº» °³³ä
- ±âº» Query ÀÛ¼ºÇϱâ : SELECT
- Single Row Functions, Group Functions
- Join, Subquery
- iSQL*Plus ȯ°æ¿¡¼­ Query ÀÛ¼º ¹× ½ºÅ©¸³Æ® ÆÄÀÏ »ý¼ºÇϱâ
- Data Manipulation Language(DML) : INSERT, UPDATE, DELETE
- Tables, Constraints, Views, Sequences, Indexes, Synonyms »ý¼º ¹× °ü¸®
- User, Role, PrivilegeÀÇ °³³ä ¹× °ü¸® ¹æ¹ý
- ÁýÇÕ ¿¬»êÀÚ(Set Operators)
- Oracle9i Single Row Functions
- ROLLUP, CUBE, GROUPING Function, GROUPING SETS, WITH Àý
- °èÃþÇü ÁúÀÇ(Hierarchical Retrieval)
- Multitable Inserts
½Ç½À

- List the capabilities of SQL SELECT statements
- Execute a basic SELECT statement
- Differentiate between SQL statements and iSQL*Plus commands
- Limit the rows retrieved by a query
- Sort the rows retrieved by a query
- Describe various types of functions available in SQL
- Use character, number, and date functions in SELECT statements
- Use conversion functions
- Write SELECT statements to access data from more than one table using equality and nonequality joins
- View data that generally does not meet a join condition by using outer joins
- Join a table to itself using a self-join
- Identify the available group functions
- Use group functions
- Group data using the GROUP BY clause
- Include or exclude grouped rows by using the HAVING clause

 
3´Ü°è - Oracle9i Database Administration : Fundamentals I (2ÁÖ)
1Z0-031 : Oracle9i Database Administration : Fundamentals I
¼Ò°³

¿À¶óŬ ¼­¹ö µ¥ÀÌÅͺ£À̽º¸¦ °ü¸®ÇÏ°í ±¸¼ºÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ ÄÚ½ºÀÔ´Ï´Ù. ¿À¶óŬ ÀνºÅϽº¿Í ¸Þ¸ð¸® ÄÄÆ÷³ÍÆ®¸¦ ±¸¼ºÇÏ°í ½ÃÀÛÇÏ¸ç ¿À¶óŬ µ¥ÀÌÅͺ£À̽º repository¸¦ »ý¼ºÇÏ´Â ¹æ¹ý, ¹°¸®Àû°ú ³í¸®Àû µ¥ÀÌÅͺ£À̽º °´Ã¼¸¦ »ý¼ºÇϰí Oracle Enterprise Manager¸¦ »ç¿ëÇÏ´Â ¹æ¹ýµµ ¹è¿ì°Ô µË´Ï´Ù.

ÀÌ °úÁ¤¿¡¼­ ¼ö°­»ýµéÀº Oracle9i database ±¸Á¶¿¡ ´ëÇÑ °³³äÀû ÀÌÇØ¸¦ ¾òÀ» ¼ö ÀÖ½À´Ï´Ù.

µ¥ÀÌŸº£À̽º¸¦ »ý¼ºÇϰí È¿À²ÀûÀÎ ¹æ½ÄÀ¸·Î °ü¸®ÇÏ´Â ¹æ¹ýÀ» ÇнÀÇÒ ¼ö ÀÖ½À´Ï´Ù. ¶ÇÇÑ µ¥ÀÌŸº£À̽º °ü¸®µµ±¸¸¦ ÀÌ¿ëÇØ DBA ¾÷¹«¸¦ ¼öÇàÇÏ´Â ½Ç½ÀÀ» ÅëÇØ µ¥ÀÌŸº£À̽º °ü¸®¸¦ À§ÇÑ ´Ù¾çÇÑ ¸í·É¹®µéÀ» ÀÍÈú ¼ö ÀÖ½À´Ï´Ù

³»¿ë

- Oracle9i ¼­¹ö±¸Á¶
- Oracle instance¿Í databaseÀÇ startup,shutdown
- Database »ý¼ºÇϱâ
- Oracle database file °ü¸®
- OMF¸¦ ÀÌ¿ëÇÑ Oracle database file °ü¸®
- Storage Structure(Tablespace,segment,extent,block) °ü¸®
- Undo data °ü¸®
- Table, Index, Data Integrity °ü¸®
- User,privilege,resource °ü¸®
- Data Loading
- National Language Support ±â´É »ç¿ëÇϱâ

½Ç½À

- Describe the Oracle architecture and its main components
- Describe the structures involved in connecting a user to an Oracle instance
- Identify the features of the Oracle Universal Installer
- Explain the benefits of Optimal Flexible Architecture
- Set up password file authentication
- List the main components of the Oracle Enterprise Manager and their uses
- Create and manage initialization parameter files
- Configure OMF
- Start up and shut down an instance
- Monitor the use of diagnostic files
- Describe the prerequisites necessary for database creation
- Create a database using Oracle Database Configuration Assistant
- Create a database manually

4´Ü°è - Oracle9i Database Administration : Fundamentals II (2ÁÖ)ÁÖ
1Z0-032 : Oracle9i Database Administration : Fundamentals II
¼Ò°³

Oracle9i databaseÀÇ Oracle9i server architecture¿Í system resources¸¦ °ü¸®ÇÏ´Â ¿©·¯ °¡Áö advanced options¿¡ ´ëÇØ¼­ ´Ù·ç°Ô µË´Ï´Ù. °¡Àå Áß¿äÇÑ ³×Æ®¿öÅ· ºÎºÐ°ú ¹é¾÷/º¹±¸ ºÎºÐÀ¸·Î ³ª´©¾î¼­ ÁøÇàµË´Ï´Ù.

ÀÌ °úÁ¤¿¡¼­ ¼ö°­»ýµéÀº µ¥ÀÌŸº£À̽º¿¡ data loading ¹× transporting À» ¼öÇàÇÏ´Â ¹æ¹ý, µ¥ÀÌŸº£À̽º ¹é¾÷ ¹× º¹±¸ ¹æ¹ý, µ¥ÀÌŸº£À̽º ¹é¾÷ ¹× º¹±¸ À¯Æ¿¸®Æ¼ÀÎ Recovery Manager (RMAN)À» »ç¿ëÇÏ¿© ¹é¾÷ ¹× º¹±¸¸¦ ¼öÇàÇÏ´Â ¹æ¹ý µîÀ» ÇнÀÇÕ´Ï´Ù. ¶ÇÇÑ ¿À¶óŬ ³×Æ®¿öÅ© ¼Ö·ç¼ÇÀÇ ±â´É°ú ¼³Á¤ ¹æ¹ý ¹× ³×Æ®¿öÅ© ¹®Á¦ ÇØ°á ¹æ¹ý¿¡ ´ëÇØ¼­µµ ÇнÀÇÏ°Ô µË´Ï´Ù. ÀÌ °úÁ¤À» ÅëÇØ ¼ö°­»ýµéÀº ³×Æ®¿öÅ©, µ¥ÀÌŸº£À̽º ¹é¾÷ ¹× º¹±¸¿¡ °üÇÑ ´Ù¾çÇÑ ½Ã³ª¸®¿ÀÀÇ ½Ç½ÀÀ» ¼öÇàÇØ º¼ ¼ö ÀÖ½À´Ï´Ù.


³»¿ë

- Oracle9i ³×Æ®¿öÅ© ¼Ö·ç¼Ç
- Oracle Net ±âº» ±¸Á¶
- Oracle Net Server-side ±¸¼º
- Oracle Net Client-side ±¸¼º
- Oracle Shared Server ±¸Á¶ ¹× ¼³Á¤ ¹æ¹ý
- µ¥ÀÌŸº£À̽º ¹é¾÷ ¹× º¹±¸ °³³ä
- Instance¿Í Media º¹±¸ ±¸Á¶
- µ¥ÀÌŸº£À̽º Archivelog mode ¼³Á¤
- Oracle Recovery Manager(RMAN) °³³ä ¹× ¼³Á¤ ¹æ¹ý
- »ç¿ëÀÚ°¡ ¼öµ¿À¸·Î ¹é¾÷Çϱâ
- RMANÀ» »ç¿ëÇÏ¿© ¹é¾÷Çϱâ
- »ç¿ëÀÚ°¡ ¼öµ¿À¸·Î ¿ÏÀü, ºÒ¿ÏÀü º¹±¸Çϱâ
- RMANÀ» »ç¿ëÇÏ¿© ¿ÏÀü, ºÒ¿ÏÀü º¹±¸Çϱâ
- RMAN Repository °ü¸® ¹æ¹ý ¹× Catalog »ý¼º°ú »ç¿ë¹ý
- Export/Import

½Ç½À

- Explain solutions included with Oracle9i for managing complex networks
- Describe Oracle networking add[ ]on solutions
- Explain the key components of the Oracle Net layered architecture
- Explain Oracle Net Services role in client server connections
- Describe how web client connections are established through Oracle networking products
- Identify how the listener responds to incoming connections
- Configure the listener using Oracle Net Manager
- Control the listener using the Listener Control Utility (lsnrctl)
- Describe Dynamic Service Registration
- Configure the listener for IIOP and HTTP connections
- Describe the difference between host naming and local service name resolution
- Use Oracle Net Configuration Assistant to configure: Host Naming, Local naming method, Net service names
- Perform simple connection troubleshooting
- Identify the components of the Oracle Shared Server
- Describe the Oracle Shared Server architecture
- Configure the Oracle Shared Server
- Identify and explain usefulness of related dictionary views

5´Ü°è - Oracle9i Database Administration : Performance Tuning (1ÁÖ)
1Z0-033 : Oracle9i Database Administration : Performance Tuning
¼Ò°³

Performance¿Í tuningÀ» ÇÏ´Â advanced skillsÀ» ¹è¿ì´Â ÄÚ½º·Î¼­ ¼º´É Åë°è¸¦ ºÐ¼®Çϰí physical I/O¸¦ ÁÙÀ̴ ij½¬ ¿µ¿ªÀ» Æ©´×Çϰí internal Oracle structures¿Í physical database structuresÀÇ ¹®Á¦¸¦ ÃÖ¼ÒÈ­ÇÏ´Â ¹æ¹ýÀ» ¹è¿ó´Ï´Ù.

¼ö°­»ýµéÀº ÀÌ °úÁ¤À» ÅëÇØ µ¥ÀÌŸº£À̽º¿Í ÀνºÅϽºÀÇ Æ©´×¿¡ °üÇÑ °³³äÀ» ½ÀµæÇÏ°í ½Ç½ÀÀ» ÅëÇØ ½ÇÁ¦·Î ¿À¶óŬ µ¥ÀÌŸº£À̽ºÀÇ ¼º´É¿¡ °ü·ÃµÈ ¹®Á¦µéÀ» ÀνÄÇϰí ÇØ°áÇÏ´Â ¹æ¹ýÀ» ÇнÀÇÒ ¼ö ÀÖ½À´Ï´Ù.

³»¿ë

- Oracle9i Performance Tuning Overview
- Áø´Ü ¹× Æ©´× µµ±¸ (Alert file, Trace file, Dynamic Performance Views, STATSPACK, UTLBSTAT/UTLESTAT Utilities, Enterprise Manager)
- Shared Pool Tuning
- Buffer Cache Tuning
- Redo Log Buffer Tuning
- Java Pool Tuning
- Database Configuration and I/O Issues
- Oracle BlockÀÇ È¿À²Àû »ç¿ë
- Sort OperationÀÇ ÃÖÀûÈ­
- Latch Contention Áø´ÜÇϱâ
- Rollback(or UNDO) Segments Tuning
- Lock ContentionÀÇ Monitoring
- Oracle Shared Server Tuning
- Application Tuning (Cluster, Index, Index Organized Table, Materialized View)
- Database Storage Tuning
- SQL ¹®Àå Tuning (Optimizer mode, Stored Outlines, SQL ¹®Àå Áø´Üµµ±¸, Hint, Åë°è °ü¸®)
- O/S Tuning ¹× Resource Manager »ç¿ëÇϱâ

½Ç½À

- Describe the roles associated with the database tuning process
- Describe the dependency between tuning in different development phases
- Describe service level agreements
- Describe appropriate tuning goals
- Describe the most common tuning problems
- Describe the tuning considerations during development and production
- Describe performance and safety tradeoffs
- Explain how the alert.log file is used
- Explain how background trace files are used
- Explain how user trace files are used
- Describe the statistics kept in the dynamic performance views
- Explain how StatsPack collects statisticsd
- Collect statistics using StatsPack
- Collect statistics using Enterprise Manager
- Use other tuning tools
- Measure and tune the library cache hit ratio
- Measure and tune the dictionary cache hit ratio
- Size and pin objects in the shared pool
- Tune the shared pool reserve space
- Describe the UGA and session memory considerations
- Explain other tuning issues related to the shared pool
- Set the large pool

6´Ü°è - RAC 10g / Dataguard Oracle Database 10g: RAC for Administrators 2ÁÖ
RAC 10g / Dataguard Oracle Database 10g: RAC for Administrators
¼Ò°³

ÀÌ °úÁ¤¿¡¼­´Â Oracle RAC(Real Application Clusters)¿ë Oracle Database 10g Release 2ÀÇ ÀϹÝÀûÀΠƯ¡ ¹× ±â´ÉÀ» ¼Ò°³ÇÕ´Ï´Ù. ¼ö°­»ýµéÀº OracleClusterware, RAC(Real Application Clusters) ¹× Automatic Storage Management¸¦ ¼³Ä¡ÇÏ°í ±¸¼ºÇÏ´Â ¹æ¹ýÀ» ¹è¿ó´Ï´Ù. ¶ÇÇÑ Enterprise Manager Grid ControlÀ» »ç¿ëÇÏ¿© RAC(Real Application Clusters)¿¡¼­ µ¥ÀÌÅͺ£À̽º¸¦ °ü¸®ÇÏ´Â ¹æ¹ýÀ» ¹è¿ì°Ô µË´Ï´Ù. RAC ȯ°æ¿¡¼­ µ¥ÀÌÅͺ£À̽º ¼­ºñ½º ¹× Load Balancing Advisory ±¸¼º ¹× »ç¿ë ¹æ¹ýÀ» ÀÍÇô È¿À²¼ºÀ» ³ôÀÏ ¼ö ÀÖ½À´Ï´Ù. Ŭ·¯½ºÅÍ¿¡¼­ ³ëµå¸¦ Ãß°¡Çϰí Á¦°ÅÇÏ´Â ¹æ¹ý ¹× Oracle Clusterware¿Í RAC(Real Application Clusters) ¼ÒÇÁÆ®¿þ¾î¸¦ ·Ñ¸µ ¹æ½ÄÀ¸·Î µÑ ´Ù ÆÐÄ¡ÇÏ´Â ¹æ¹ýÀ» ¹è¿ó´Ï´Ù

³»¿ë

RAC(Real Application Clusters) ±¸¼º ¿ä¼Ò ½Äº°
- RAC(Real Application Clusters) ÀÌÇØ
- Ŭ·¯½ºÅÍ È®À强 ¹× °í°¡¿ë¼º(High Availability)
- Global ¸®¼Ò½ºÀÇ Çʿ伺
- RAC¿¡¼­ º´·Ä ½ÇÇà(Parallel Execution)
- RAC ¼ÒÇÁÆ®¿þ¾î ¹× µ¥ÀÌÅͺ£À̽º ¿ø¸®
- RAC ¹× °øÀ¯ ÀúÀå ¿µ¿ª ±â¼ú
- VIP ÀÌÇØ
- Fast Application NotificationÀÇ ÀÌÁ¡ ¼³¸í

RAC(Real Application Clusters) µ¥ÀÌÅͺ£À̽º ¼³Ä¡, »ý¼º, °ü¸® ¹× ¸ð´ÏÅÍ
- Oracle RAC 10g ¼³Ä¡ ¼³¸í
- RAC ¼³Ä¡ Àü(Pre-installation) ÀÛ¾÷ ¼öÇà
- Ŭ·¯½ºÅÍ ¼³Á¤ ÀÛ¾÷ ¼öÇà
- Oracle Clusterware ¼³Ä¡
- ASM(Automatic Storage Management) ¼³Ä¡ ¹× ±¸¼º
- ¿À¶óŬ µ¥ÀÌÅͺ£À̽º ¼ÒÇÁÆ®¿þ¾î ¼³Ä¡
- Ŭ·¯½ºÅÍ µ¥ÀÌÅͺ£À̽º »ý¼º

RAC(Real Application Clusters) µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ ±¸¼º ¹× °ü¸® µµ±¸ »ç¿ë
- Enterprise Manager Ŭ·¯½ºÅÍ µ¥ÀÌÅͺ£À̽º ÆäÀÌÁö »ç¿ë
- RAC ȯ°æÀÇ ¸®µÎ ·Î±× ÆÄÀÏ Á¤ÀÇ
- RAC ȯ°æÀÇ ¾ðµÎ Å×ÀÌºí½ºÆäÀ̽º Á¤ÀÇ
- RAC µ¥ÀÌÅͺ£À̽º ¹× Instance ½ÃÀÛ/Á¤Áö
- RAC ȯ°æ¿¡¼­ ÃʱâÈ­ ÆÄ¶ó¹ÌÅÍ ¼öÁ¤
- RAC ȯ°æ¿¡¼­ ASM instance °ü¸®
- RAC ƯÁ¤ ´ë±â À̺¥Æ®, Global enqueue ¹× ½Ã½ºÅÛ Åë°è ÆÇº°
- °¡Àå ÀϹÝÀûÀÎ RAC Æ©´× ÆÁ ±¸Çö

ÀÛ¾÷ ·Îµå °ü¸® ¹× ÀÀ¿ë ÇÁ·Î±×·¥ °í°¡¿ë¼º(High availability)À» À§ÇÑ ¼­ºñ½º ¼³Á¤
- RAC ȯ°æ¿¡¼­ ¼­ºñ½º ±¸¼º ¹× °ü¸®
- ¼­ºñ½º¿¡ ´ëÇÑ ¼º´É metric ÀÓ°è°ª ¼³Á¤
- ¼­ºñ½º Áý°è ¹× Trace ±¸¼º
- ¼­¹öÃø Connect-time ·Îµå ¹ë·±½Ì ±¸¼º
- Load Balancing Advisory »ç¿ë
- ¼­¹öÃø Äݾƿô ±¸¼º
- ¼­¹öÃø ¹× Ŭ¶óÀ̾ðÆ®Ãø ONS ±¸¼º
- TAF(Transparent Application Failover) ±¸¼º

RAC(Real Application Clusters) µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ ¹é¾÷ ¹× Recovery Àü·« °³¹ß
- ARCHIVELOG ¸ðµå ¹× Flash recovery area¸¦ »ç¿ëÇϵµ·Ï RAC µ¥ÀÌÅͺ£À̽º ±¸¼º
- RAC ȯ°æ¿¡ ¸Â°Ô RMAN ±¸¼º

Oracle Clusterware ¸®¼Ò½º ±¸¼º ¹× ¸ð´ÏÅÍ
- Oracle Clusterware ½ºÅà ¼öµ¿ Á¦¾î
- ¼±È£ µð½ºÅ©(Voting disk) ¹× OCR ±¸¼º º¯°æ
- ¼±È£ µð½ºÅ© ¹× OCR ÆÄÀÏ ¹é¾÷ ¶Ç´Â Recovery
- VIP ÁÖ¼Ò º¯°æ
- CRS ÇÁ·¹ÀÓ¿öÅ© »ç¿ë
- Oracle Clusterware Áø´Ü ÆÄÀÏ ¼öÁý
- Oracle Clusterware µð¹ö±ë Ȱ¼ºÈ­

ÃÖÀûÀÇ °í°¡¿ë¼º(High availability) Best practice °ËÅä
- Ŭ·¯½ºÅÍ µ¥ÀÌÅͺ£À̽º¿¡ »õ ³ëµå Ãß°¡
- Ŭ·¯½ºÅÍ µ¥ÀÌÅͺ£À̽º¿¡¼­ ³ëµå Á¦°Å
- À¯Àú ȯ°æÀÇ ÃÖ´ë °¡¿ë¼º ±¸Á¶ ¼³°è
- »ç¿ëÇÒ ÃÖÀû ASM ±¸¼º °áÁ¤
- ·Ñ¸µ ¹æ½ÄÀ¸·Î RAC ½Ã½ºÅÛ ÆÐÄ¡

6´Ü°è - ´ë¿ë·®(´ë¿ë·® µ¥ÀÌÅÍ º£À̽º) 3ÁÖ
Oracle Database 10g: ´ë¿ë·® µ¥ÀÌÅÍ º£À̽º
¼Ò°³

½Ç¹« °³¹ßÀÚµéÀ» À§ÇÑ ´ë¿ë·® ¿À¶óŬ Æ©´×ÀÇ ±âº» ±â¼ú ¹× SQL ¹®Àå Æ©´×ÀÇ ±âº» °³³ä ½Àµæ

³»¿ë

Æ©´×À̶õ
- Æ©´×À» ½ÃÀÛÇϸç
- µ¥ÀÌÅͺ£À̽º Æ©´×
- Æ©´× ÀýÂ÷ Á¤¸³

¼º´É µ¥ÀÌÅÍ ¼öÁý
- µ¥ÀÌÅͺ£À̽º ¾ÆÅ°ÅØÃÄ Æ©´×
- ¾îÇø®ÄÉÀÌ¼Ç ºÐ¼® ¹× Æ©´×
- Æ©´× ÀýÂ÷ Á¤¸³
- ¼º´É µ¥ÀÌÅÍ ¼öÁý

µ¥ÀÌÅͺ£À̽º ¾ÆÅ°ÅØÃÄ Æ©´×
- ¾îÇø®ÄÉÀÌ¼Ç ºÐ¼® ¹× Æ©´×
- Statspack »ç¿ë ¹æ¹ý
- Statspack ºÐ¼®
- Statspack ºÐ¼® ½Ã °í·Á»çÇ×

ÀÏ¹Ý Á¤º¸
- CPU »ç¿ë Á¤º¸
- ºñÈ¿À² SQL
- µð½ºÅ© IO ºÐ»ê °í·Á»çÇ×
- ÃÖÀûÈ­µÈ µð½ºÅ© ±¸¼º

º¼·ý ±×·ì
- ³í¸®Àû º¼·ý
- ÆÄÀÏ ½Ã½ºÅÛ
- ¿À¶óŬ ½ºÅ丮Áö ±¸Á¶

¼º´É °ü·Ã ºä
- µ¥ÀÌÅÍ µñ¼Å³Ê¸® ºä ¹× µ¿Àû ¼º´É ºä
- µ¥ÀÌÅÍ µñ¼Å³Ê¸® ºä ¹× µ¿Àû ¼º´É ºä¸¦ ÀÌ¿ëÇÑ ¼º´É µ¥ÀÌÅÍ ¼öÁý

Wait Event ¼öÁý
- Wait Event °ü·Ã View
- ÀÏ¹Ý Wait Event Á¶È¸
- B£ªTREE Index
- Bitmap Index
- Reverse Key Index
- Function Base Index
- Random Access

IOTÀÇ °³³ä
- IOTÀÇ Æ¯Â¡
- IOTÀÇ ¼º´É ºÐ¼®
- IOT ±¸Á¶ ¹× »ý¼º
- Range Partition
- Hash Partition
- List Partition
- Composite Partition
- Chapter 10 ¿ÉƼ¸¶ÀÌÀú

SQL ½ÇÇà ¾ÆÅ°ÅØÃÄ
- SQL ½ÇÇà °³³ä
- SQL ½ÇÇà ÀýÂ÷
- Cluster Factor ÃÖÀûÈ­¿¡ »ç¿ëÇÒ ¼ö ÀÖ´Â ¹æ¹ý
- Cluster Factor ÃÖÀûÈ­ ¹æ¹ý Àû¿ë »ç·Ê
- Cluster Factor ÃÖÀûÈ­ ¹æ¹ý Àû¿ë »ç·Ê

½ÇÇà °èȹ ±âº» ÇØ¼®
- Row Source Operators¸¦ ÅëÇÑ ½ÇÇà °èȹ ÇØ¼®
- Data Flow Operators Tree¸¦ ÅëÇÑ ½ÇÇà °èȹ ÇØ¼®
- Index Access Operation
- Unique Scan
- Range Scan
- Range Scan(IN°ú OR)

 

7´Ü°è - RDM(Data Modeling and Relational Database Design) 2ÁÖ

Data Modeling and Relational Database Design
¼Ò°³

Entity Relationship (ER) Modeling°ú °ü°èÇü µ¥ÀÌÅͺ£À̽º ¼³°è ¹æ¹ý¿¡ ´ëÇØ ÇнÀÇÏ´Â °úÁ¤ÀÌ´Ù. ÀÌ °úÁ¤¿¡¼­ ¼ö°­»ýµéÀº ¿©·¯ °¡Áö ¾÷¹« ¿ä±¸ »çÇ×°ú °ü·ÃµÈ ´Ù¾çÇÑ ¿¹Á¦½Ç½ÀÀ» ÅëÇÏ¿© ER ModelÀ» ÀÛ¼ºÇÏ´Â ¹æ¹ýÀ» ½ÀµæÇÒ ¼ö ÀÖÀ¸¸ç À̸¦ ¹ÙÅÁÀ¸·Î °ü°èÇü µ¥ÀÌÅͺ£À̽º¸¦ ¼³°èÇÏ´Â °úÁ¤°ú ¾ÈÁ¤ÀûÀÌ°í °ü¸®°¡ ¿ëÀÌÇϵµ·Ï Àß ¼³°èµÈ °ü°èÇü µ¥ÀÌÅͺ£À̽º¸¦ ±¸ÃàÇϱâ À§ÇÏ¿© °í·ÁÇØ¾ß ÇÒ »çÇ׵鿡 °üÇØ ÇнÀÇÒ ¼ö ÀÖ´Ù.

³»¿ë

Entity Relationship Modeling
- Why create conceptual models
- Distinguishing Data and Information
- Tracking Entities in various source materials
- Modeling Subtypes and Supertypes
- Tracking Attributes
- Distinguishing Entities and Attributes
- Establishing Relationships
- Creating appropriate Names for Entities, Attributes and Relationships

Relational Database Design
- Why create a Database Design
- Creating well structured Names for Database Objects
- Establishing the Basic Mapping of an ER Model to Table Model
- Mapping Entities and Attributes
- Mapping various Types of Relationships
- Mapping Arcs
- Selecting an appropriate Subtype Implementation
- Various ways of Denormalizing your Table Design

8´Ü°è - Ãë¾÷ Ư°­
À̷¼­ ÀÛ¼º ¿ä·É, ä¿ë´ã´çÀÚ ¸éÁ¢ ±â¼ú, Á÷ÀåÀÎÀÇ ±âº»¼Ò¾ç(ÀλçÀü¹®CEO)
¼Ò°³

¿À¶óŬ Àü¹®°¡ 100% Ãë¾÷´ëºñ¹ÝÀÇ À̷¼­ ÀÛ¼º¿ä·É, ä¿ë´ã´çÀÚ ¸éÁ¢ ±â¼ú, Á÷ÀåÀÎÀÇ ±âº»¼Ò¾ç¿¡ ´ëÇÑ ÀλçÀü¹® CEOÀÇ ¼¼¹Ì³ª

³»¿ë

Ãë¾÷Ư°­
- À̷¼­ ÀÛ¼º¿ä·É
- ä¿ë´ã´çÀÚ ¸éÁ¢±â¼ú
- Á÷ÀåÀÎÀÇ ±âº» ¼Ò¾ç

 
 


Ãë¾÷º¸µµ½Ç(HRÆÀ) ¿î¿µ - Ãë¾÷»çÀÌÆ® ¿î¿µ
½Å°³³ä ±³À° System Infra±¸Ãà.
ÃÖ÷´Ü Àåºñ ½Ã½ºÅÛ ¹× IT±³À°°è ÃÖ°íÀÇ °­»çÁø(T.P°øÀÎÆ®·¹ÀÌ´×ÈÄ ±³À°ÅõÀÔ)
Prometric»ç ÁöÁ¤ ±¹Á¦°øÀνÃÇè¼¾ÅÍ °­³², ºÎ»ê¼¾ÅÍ ÀÚü ¿î¿µ(SK62)
ÇÁ·Î¸ÞÆ®¸¯ ¸ð¹ÙÀÏ Å×½ºÆ® ¼¾ÅÍ ÁöÁ¤(SK62M)
PEARSON VUE »ç ÁöÁ¤ ±¹Á¦°øÀνÃÇè¼¾ÅÍ °­³², ºÎ»ê¼¾ÅÍ ÀÚü ¿î¿µ
Oracle»ç ÁöÁ¤ WDP °øÀα³À°¼¾ÅÍ[°­³², ºÎ»ê]
Oracle»ç ÁöÁ¤ OAEC °øÀα³À°¼¾ÅÍ[°­³², ºÎ»ê]
Microsoft °øÀαâ¼ú ±³À°¼¾ÅÍ ÁöÁ¤ CTEC °øÀα³À°¼¾ÅÍ[°­³², ºÎ»ê]
SUN Microsystems ÀڰݰËÁõ Çù·Â¼¾ÅÍ[°­³², ºÎ»ê]
³×Æ®¿öÅ©º¸¾ÈÀü¹®°¡ Ãë¾÷´ëºñ¹Ý ±â¼öº° ¸ðÁýÀ¸·Î ¾à 100% Ãë¾÷Áö¿ø
ÀÚ¹Ù CBD,SOA Ãë¾÷´ëºñ¹Ý ±â¼öº° ¸ðÁýÀ¸·Î ¾à 100% Ãë¾÷Áö¿ø
UX ±â¹Ý .NET Developer Ãë¾÷´ëºñ¹Ý ±â¼öº° ¸ðÁýÀ¸·Î ¾à 100% Ãë¾÷Áö¿ø
¿À¶óŬÀü¹®°¡Ãë¾÷´ëºñ¹Ý ±â¼öº° ¸ðÁýÀ¸·Î ¾à 100% Ãë¾÷Áö¿ø
°¢ÀÚÀÇ ÀÚ¸®¿¡¼­ °­»çÀÇ ¸ð´ÏÅ͸¦ º¼ ¼ö ÀÖ´Â ¸ð´ÏÅÍ ºÐ¹è±â ½Ã½ºÅÛ ¿î¿µ
Æ÷ÅäÆú¸®¿À¸¦ Á÷Á¢ ¼­¹ö¿¡ ¿Ã·Á ¿î¿µÇÏ´Â 5´ëÀÇ Çпø Àü¿ë ¼­¹ö º¸À¯
Àü°­ÀÇÀå PCLAN(Network) ±¸¼º
E1±Þ ÀÎÅÍ³Ý Àü¿ë ȸ¼± ¹× 100Mbps Ãʰí¼Ó ÀÎÅÍ³Ý Àü¿ë¼±
½Ç½À½Ç »ó½Ã °³¹æ (¿ÀÀü 09:00 - 22 : 30)
Åä¿äÀÏ º¸°­¼ö¾÷, ½Ã½ºÅÛ ¹× IT Á¤º¸±â¼ú ¼¼¹Ì³ª °³ÃÖ(°í°´¼¾ÅÍ ¼¼¹Ì³ªÀÏÁ¤ÂüÁ¶)
°¢ Çаúº° ¼ö°­·á ÇÒÀÎ ¹× ¼±¼ö°ú¸ñ ¹«·á¼ö°­ÀÇ ÇýÅÃ
»çÀÌÆ® Ä¿¹Â´ÏƼ¸¦ ÅëÇÑ Á¹¾÷»ýµé°ú Ãë¾÷ÀÚµé °£ÀÇ »óÈ£±³·ù ¹× Á¤º¸±³È¯(¾ÆÀÌÆ¼Ä¿¸®¾î Ãë¾÷»çÀÌÆ® ÀÚü¿î¿µ)
öÀúÇÑ Çлç°ü¸® ¹× Àç¼ö°­ Á¦µµ
5´ëÀÇ Àü¿ë¼­¹ö¸¦ ÅëÇÑ Æ÷ÅäÆú¸®¿À ¹× À¥È£½ºÆÃ Áö¿øÀ¸·Î öÀúÇÑ ½Ç¹« ±³À°À»
   ÁøÇàÇÏ¸ç ¹æÈ­º®À» ÅëÇØ ¹ÙÀÌ·¯½º¸¦ Â÷´ÜÇÏ¿© ¾ÈÁ¤ÀûÀÎ ¼ö¾÷ ÁøÇà
öÀúÇÑ È¸¿ø°ü¸®¿Í 1:1 °³º°°ü¸®½Ã½ºÅÛ
º°µµÀÇ Ãë¾÷º¸µµ½Ç ¿î¿µÀ¸·Î ±³À°»ý ½Ç·Â¿¡ ¸Â´Â Ãë¾÷ Áö¿ø
ÇнÀ ¹× ±³À°È¿°ú ±Ø´ëÈ­ ÃßÁøÀ» À§ÇØ ±³À°¿ë µ¿¿µ»ó»çÀÌÆ® ¿î¿µ ¹× ±³À°¿ë CD Á¦°ø
ÃÖ°í »ç¾çÀÇ ¼­¹ö ¹× ½Ã½ºÅÛ ¿î¿µÀ¸·Î ÄèÀûÇÑ ±³À° ȯ°æ À¯Áö
°­»ç Æò°¡ ½Ã½ºÅÛÀ¸·Î ¾ðÁ¦³ª ¼öÁØ ³ôÀº ½Ç¹«Áø °­»çÀÇ ½Ç¹« °­ÀÇ °í¼ö
¼ö·á»ýÀÇ ¾à 90% Á¤µµÀÇ ÇÕ°Ý·üÀ» ÀÚ¶ûÇÏ´Â ±¹Á¦°øÀÎITÀÚ°ÝÁõ Ãëµæ
 
 

Äü¸Þ´º