Untitled Document
 


Untitled Document
  Oracle & Java °³¹ßÀÚ °úÁ¤
  Network&¸®´ª½ºº¸¾È Ãë¾÷°úÁ¤
  .Net °³¹ßÀÚ Ãë¾÷°úÁ¤
JAVA °³¹ßÀÚ °úÁ¤
C¾ð¾î °³¹ßÀÚ °úÁ¤
C#.NET Àü¹®°³¹ßÀÚ ¾ç¼º°úÁ¤
À¥Ç¥ÁØ ÆÛºí¸®¼Å °úÁ¤
  FLEX Ç÷º½º 3.0 Master

  WDP Oracle OCP 10g+11g
  OAEC Oracle ´Ü±â°úÁ¤
  Unix Platform Oracle
(¿À¶óŬ ¿£´ÏÁö´Ï¾î¸µ °úÁ¤)
  ¿À¶óŬ OCM10g ÀÚ°ÝÁõ
  ¿À¶óŬDB ½Ç¹«Àü¹®°¡ ¾ç¼º°úÁ¤
 
  ½º¸¶Æ®Æù °³¹ß°úÁ¤
  iphone ÇÁ·Î±×·¥ °³¹ß°úÁ¤
  Android ÇÁ·Î±×·¥ °³¹ß°úÁ¤
  Á¤º¸º¸¾ÈÀü¹®°¡ ¾ç¼º°úÁ¤
À¥»çÀÌÆ®Ãë¾àÁ¡ Áø´Ü°úÁ¤
  KISA License (SIS)
  Linux
  Windows 2008
  Unix Solaris
  CCNA
  CCNP
¹æÇÐƯ°­
  °­³²Ä·ÆÛ½º °èÁÂÁ¦°úÁ¤
  ÀÌ´ëÄ·ÆÛ½º °èÁÂÁ¦°úÁ¤
  Á¾·ÎÄ·ÆÛ½º °èÁÂÁ¦°úÁ¤
 

±³À°°úÁ¤¼Ò°³
  Oracle DB ¿î¿µ ¹× Æ©´×±â¼ú, RCA ¼­¹ö ¿î¿µ ±â¹ý µî °í±Þ±â¼úÀÇ ½ÀµæÀ» ÅëÇØ ½Ç¹«¿¡¼­ °¡Àå È°¹ßÈ÷ È°µ¿ÇÏ´Â
Database Engineer·Î ¹ßÀüÇØ ³ª°¥ ¼ö ÀÖ´Ù.
 
±³À°´ë»ó
  10g ¾÷±×·¹À̵尡 ÇÊ¿äÇϽźÐ,
µ¥ÀÌÅͺ£À̽º ±³À°À» ¿øÇϽô ºÐµé
 
Ãëµæ°¡´ÉÀÚ°ÝÁõ
  OCP
 
±³À° ÈÄ Áø·Î ¹× Ãë¾÷ºÐ¾ß
  ¼¼°èÀûÀ¸·Î Oracle Àü¹®°¡·Î °øÀÎµÇ¸ç ¿À¶óŬ°ú °ü·Ã µÈ ¿©·¯ ¼¼¹Ì³ª, Çà»ç µî¿¡ Âü¿©ÇÒ ¼ö ÀÖ´Ù.
ÇöÀç Oracle Database Àü¹®°¡´Â Àý´ëÀûÀ¸·Î °ø±ÞÀÌ ºÎÁ·ÇÑ »óÅ ÀÓÀ¸·Î °í°´²²¼­ Áö±Ý °ðÀå µµÀüÇϽþî ÃëµæÇϽøé
°ø°ø±â°ü, ÀÇ·á±â°ü ¹× ´ë±â¾÷ Àü»ê½Ç µîÀÇ Database °ü¸®ÀÚ·Î ¿ëÀÌÇÏ°Ô ÁøÃâÇÏ½Ç ¼ö ÀÖ´Ù.
   
¼¼ºÎ½Ã°£Ç¥
 
ORACLE ±³À°½Ã°£
ÆòÀϹÝ
- 09:30~17:00 / Á¡½É½Ã°£ : 12:30~14:00 (1½Ã°£ 30ºÐ)
5ÀÏ/35h
   
±³À°ÀÏÁ¤
 
Oracle Database 10g ±³À°ÀÏÁ¤
±³À°
Àϼö
±³À°½ÃÀÛÀÏ (2013³â)
1¿ù
2¿ù
3¿ù
4¿ù
5¿ù
6¿ù
7¿ù
--Oracle Database 10g: Introduction to SQL
--(10g SQL)
5ÀÏ
20
4,25
16
5,26
17
7,28
19
--Oracle Database 10g:Administration workshop I
--(10g WSI )
5ÀÏ
13,27
11,25
8,29
19
4,17
7,28
12,26
--Oracle Database 10g: dministration workshop II
--(10g WSII)
5ÀÏ
20
18
8,22
19
10,31
14
5,19
--Oracle Database 10g: Program with PL/SQL
--(10g PLP)
5ÀÏ
10,27
18
22
26
24
28
26
--Oracle Database 10g: NEw Feature for
--Administrators (10g NF)
5ÀÏ
4
17
--Practice Oriented Course for Developer (Practice l)
5ÀÏ
7
22
7
--Practice Oriented Course for
--Administration & Recovery (Practice ll)
5ÀÏ
27
29
14
--E Oracle Database 10g : Expert for Database
--Administrator (Practice 10g Adm)
3ÀÏ
4
4

Oracle Database 11g ±³À°ÀÏÁ¤
±³À°
Àϼö
±³À°½ÃÀÛÀÏ (2013³â)
1¿ù
2¿ù
3¿ù
4¿ù
5¿ù
6¿ù
7¿ù
--Oracle Database 11g: Introduction to SQL
--(11g SQL)
5ÀÏ
20
11
1,29
19
4,24
21
12
--Oracle Database 11g:Administration workshop I
--(11g WSI )
5ÀÏ
7,20
18
8,22
19
10,31
14
5,19
--Oracle Database 11g: dministration workshop II
--(11g WSII)
5ÀÏ
27
11
16
26
24
21
26
--Oracle Database 11g: Program with PL/SQL
--(11g PLP)
5ÀÏ
27
11
8
5
10
7
12
--Oracle Database 11g: NEw Feature for
--Administrators  (11g NF)
5ÀÏ
27
11
8
5
4
7
5
   

¼¼ºÎ±³À°°úÁ¤

Oracle Database 10g: Introduction to SQL (SQL 10g) - 5Àϱ³À°
±³À°°³¿ä
ÀÌ °úÁ¤¿¡¼­´Â ¼ö°­»ýµé¿¡°Ô Oracle Database 10g µ¥ÀÌÅͺ£À̽º ±â¼úÀ» ¼Ò°³ÇÕ´Ï´Ù. ¼ö°­»ýµéÀº °ü°èÇü
µ¥ÀÌÅͺ£À̽ºÀÇ °³³ä°ú °­·ÂÇÑ SQL ÇÁ·Î±×·¡¹Ö ¾ð¾î¿¡ ´ëÇØ ¹è¿ó´Ï´Ù. ÀÌ °úÁ¤¿¡¼­´Â ´ÜÀÏ Å×À̺í°ú ´ÙÁß Å×ÀÌºí¿¡
´ëÇÑ query ÀÛ¼º, Å×ÀÌºí µ¥ÀÌÅÍ Á¶ÀÛ, µ¥ÀÌÅͺ£À̽º °´Ã¼ »ý¼º ¹× ¸ÞŸ µ¥ÀÌÅÍ query ÀÛ¾÷ µîÀ» ¼öÇàÇÒ ¼ö ÀÖ´Â
°³¹ßÀÚ¿¡°Ô ÇʼöÀûÀÎ SQL ±â¼ú¿¡ ´ëÇØ ¼³¸íÇÕ´Ï´Ù.¶ÇÇÑ ¼ö°­»ýµéÀº SQLÀÇ °í±Þ ±â´ÉÀ» »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽ºÀÇ
µ¥ÀÌÅ͸¦ query ¹× Á¶ÀÛÇÏ´Â ¹æ¹ýÀ» ¹è¿ó´Ï´Ù. °í±Þ query ¹× º¸°í ±â¹ý¿¡ ´ëÇؼ­µµ ÇнÀÇÕ´Ï´Ù. ¶ÇÇÑ µ¥ÀÌÅÍ
¿þ¾îÇÏ¿ì¡ ¹× ´Ù¸¥ ÀÀ¿ë ÇÁ·Î±×·¥ ¿µ¿ª¿¡ À¯¿ëÇÑ ½ºÅ°¸¶ °´Ã¼¸¦ ÀÚ¼¼È÷ ÀÍÈ÷°Ô µË´Ï´Ù. ¼ö°­»ýµéÀº ´ëÇü µ¥ÀÌÅÍ
ÁýÇÕÀ» Á¶ÀÛÇÏ´Â ¹æ¹ý°ú ´Ù¸¥ ½Ã°£´ë¿¡ µû¶ó ³¯Â¥¸¦ ÀúÀå ¹× °Ë»öÇÏ´Â ¹æ¹ýÀ» ¹è¿ó´Ï´Ù.
±³À°¸ñÇ¥

- Retrieve row and column data from tables with the SELECT statement.
- Employ SQL functions to generate and retrieve customized data.
- Run data manipulation statements (DML) to update data in the Oracle Database 10g.
- Control user access and manage schema objects
- Search data using advanced sub queries

±³À°´ë»ó - Application Developers
- Business Intelligence Developer
- Database Administrators
- End Users
- Forms Developer
- PL/SQL Developer
- Portal Developer
±³À°³»¿ë - SQL ¹®À» »ç¿ëÇÏ¿© Å×ÀÌºí¿¡¼­ µ¥ÀÌÅÍ °Ë»ö
- °´Ã¼ ¹× ½Ã½ºÅÛ ·¹º§¿¡¼­ ±ÇÇÑ Á¦¾î
- Å×À̺í°ú ±âŸ ½ºÅ°¸¶ °´Ã¼ »ý¼º ¹× °ü¸®
- DML(µ¥ÀÌÅÍ Á¶ÀÛ¾î)À» ½ÇÇàÇÏ¿© Oracle Database 10g¿¡¼­ µ¥ÀÌÅÍ °»½Å
- SQL ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© Ä¿½ºÅ͸¶ÀÌÁîµÈ µ¥ÀÌÅÍ »ý¼º ¹× °Ë»ö
- °í±Þ Sub query¸¦ »ç¿ëÇÏ¿© µ¥ÀÌÅÍ °Ë»ö ¹× °èÃþÀû µ¥ÀÌÅÍ °Ë»ö
¹öÀü ¹×
»çÀüÀ̼ö
°úÁ¤
Familiarity with Data Processing Concepts and Techniques
Ability to use a graphical user interface (GUI)

Oracle Database 10g : Administration workshop I (10g WS I) - 5Àϱ³À°
±³À°°³¿ä
º» °úÁ¤Àº ±âº» µ¥ÀÌÅͺ£À̽º °ü¸®ÀÇ ±âÃʸ¦ Æ°Æ°È÷ ´Û¾Æ ¿À¶óŬ Àü¹®°¡·Î¼­ÀÇ ¼º°øÀ» À§ÇÑ Ã¹¹ßÀ» ³»µðµô ¼ö ÀÖµµ·Ï
¼³°èµÇ¾ú½À´Ï´Ù. º» °úÁ¤¿¡¼­´Â ¿À¶óŬ µ¥ÀÌÅͺ£À̽ºÀÇ ¼³Ä¡ ¹× À¯Áö °ü¸® ¹æ¹ýÀ» ¹è¿ó´Ï´Ù. ¼ö°­»ýµéÀº ¿À¶óŬ µ¥ÀÌÅͺ£À̽º ±¸Á¶ ¹× ÇØ´ç ±¸¼º ¿ä¼ÒÀÇ »óÈ£ ÀÛ¿ë ¹æ¹ýÀ» °³³äÀûÀ¸·Î ÀÌÇØÇÏ°Ô µË´Ï´Ù. ¶ÇÇÑ ¿î¿ë µ¥ÀÌÅͺ£À̽º¸¦ »ý¼ºÇÏ´Â ¹æ¹ý°ú ¼º´É ¸ð´ÏÅ͸µ, µ¥ÀÌÅͺ£À̽º º¸¾È, À¯Àú °ü¸®, ¹é¾÷/Recovery ±â¼ú µî ´Ù¾çÇÑ ±¸Á¶¸¦ È¿À²ÀûÀ¸·Î °ü¸®ÇÏ´Â
¹æ¹ýÀ» ¹è¿ó´Ï´Ù. º» °úÁ¤¿¡´Â ÇнÀ È¿°ú¸¦ ³ôÀ̱â À§ÇÑ ½Ç½ÀÀÌ Æ÷ÇԵǾî ÀÖ½À´Ï´Ù.
º» °úÁ¤Àº Oracle Certified Associate ½ÃÇè¿¡ ´ëºñÇÒ ¼ö ÀÖµµ·Ï ±¸¼ºµÇ¾ú½À´Ï´Ù.
±³À°¸ñÇ¥

- Oracle Net ¼­ºñ½º ±¸¼º
- À¯Àú °èÁ¤ »ý¼º ¹× °ü¸®
- Oracle Database 10g ¼³Ä¡ ¹× µ¥ÀÌÅͺ£À̽º ±¸¼º
- µ¥ÀÌÅͺ£À̽º ÀúÀå ¿µ¿ª ±¸Á¶ °ü¸®
- Oracle Instance °ü¸®
- µ¥ÀÌÅͺ£À̽º ¸ð´ÏÅÍ, ¹®Á¦ ÇØ°á ¹× À¯Áö °ü¸®
- µ¥ÀÌÅͺ£À̽º ¹× ÆÄÀÏ °£ µ¥ÀÌÅÍ À̵¿
- µ¥ÀÌÅͺ£À̽º ¹é¾÷ ¹× Recovery ¼öÇà

±³À°´ë»ó - Database Administrators
- Database Designers
- Project Manager
- Sales Consultants
- Support Engineer
- Technical Consultant
±³À°³»¿ë - µ¥ÀÌÅͺ£À̽º ¼³Ä¡
- µ¥ÀÌÅͺ£À̽º °£ µ¥ÀÌÅÍ À̵¿
- µ¥ÀÌÅÍ ¹é¾÷ ¹× Recovery
- µ¥ÀÌÅÍ °ü¸®
- À¯Àú °ü¸® ³×Æ®¿öÅ© ±¸¼º
¹öÀü ¹×
»çÀüÀ̼ö
°úÁ¤
- Oracle10g

Oracle Database 10g : Administration workshop I (10g WS Il) - 5Àϱ³À°
±³À°°³¿ä
º» °úÁ¤Àº µ¥ÀÌÅͺ£À̽º °ü¸® ºÐ¾ß¿¡¼­ ¿À¶óŬ Àü¹®°¡·Î¼­ ¼º°øÇÒ ¼ö ÀÖµµ·Ï µµ¿ÍÁÝ´Ï´Ù.
º» °úÁ¤¿¡¼­´Â ¿À¶óŬ µ¥ÀÌÅͺ£À̽º¸¦ ´Ù±¹¾î ÀÀ¿ë ÇÁ·Î±×·¥¿ëÀ¸·Î ±¸¼ºÇÏ´Â ¹æ¹ýÀ» ¹è¿ó´Ï´Ù. ¼ö°­»ýµéÀº RMAN
¹× Flashback ±â¼úÀ» »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º¸¦ RecoveryÇÏ´Â ´Ù¾çÇÑ ¹æ¹ýÀ» ¿¬½ÀÇÕ´Ï´Ù. µ¥ÀÌÅͺ£À̽º ¼º´É
¸ð´ÏÅ͸µ ÅøÀ» ´Ù·ç¸é¼­ °øÅë ¹®Á¦¸¦ ÇØ°áÇÏ°í ¼º´ÉÀ» °³¼±ÇÏ´Â ´Ü°è¸¦ ¹è¿ì°Ô µË´Ï´Ù. ¶ÇÇÑ Resource Manager, Scheduler, ASM(Automatic Storage Management), VLDB ±â´É°ú °°Àº µ¥ÀÌÅͺ£À̽º ±â¼úÀ» »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º¸¦ È¿°úÀûÀ¸·Î °ü¸®ÇÏ´Â ¹æ¹ýÀ» ¹è¿ó´Ï´Ù. VPD(Virtual Private Database)¸¦ »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º º¸¾ÈÀ» ¼³Á¤ÇÏ°í µ¥ÀÌÅͺ£À̽º °£¿¡ È¿°úÀûÀ¸·Î µ¥ÀÌÅ͸¦ À̵¿ÇÏ´Â ¹æ¹ýÀ» ¹è¿ó´Ï´Ù. º» °úÁ¤¿¡´Â ÇнÀ È¿°ú¸¦ ³ôÀ̱â À§ÇØ ½ÇÀü ¿¬½À
¹× ¿öÅ©¼¥ÀÌ ¸¶·ÃµÇ¾î ÀÖ½À´Ï´Ù. º» °úÁ¤Àº Oracle Certified Professional ½ÃÇè¿¡ ´ëºñÇÒ ¼ö ÀÖµµ·Ï ±¸¼ºµÇ¾ú½À´Ï´Ù.
±³À°¸ñÇ¥

- VLDB °ü¸®
- Resource Manager¸¦ »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º ¸®¼Ò½º »ç¿ë·® Á¦¾î
- µ¥ÀÌÅͺ£À̽º ¹× °³º° ¼¼¼Ç¿¡ ´ëÇÑ ¾ð¾î Á¾¼Ó µ¿ÀÛ Ä¿½ºÅ͸¶ÀÌÁî
- ºí·Ï ¼Õ»óÀ» °¨ÁöÇÏ°í ¹®Á¦ ÇØ°áÀ» À§ÇÑ ÀûÀýÇÑ Á¶Ä¡ ¼öÇà
- º¸¾È µ¥ÀÌÅͺ£À̽º ±¸Çö
- ÀÌÀü ½ÃÁ¡À¸·Î µ¥ÀÌÅͺ£À̽º Recovery
- Áø´Ü¿ë µ¥ÀÌÅͺ£À̽º ·Î±× ÆÄÀÏ °ËÅä
- Scheduler¸¦ »ç¿ëÇÏ¿© °ü¸® ¾÷¹« °£¼ÒÈ­
- Ç÷§Æû °£ µ¥ÀÌÅÍ À̵¿
- Oracle Secure BackupÀ» »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º ¹é¾÷ ¹× Recovery
- Oracle Flashback ±â¼úÀ» »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º Recovery
- RMANÀ» »ç¿ëÇÏ¿© ¹é¾÷ ¼Â°ú Image Copy »ý¼º ¹× °ü¸®
- ´Ù¾çÇÑ µ¥ÀÌÅͺ£À̽º Advisor ¹× ºä¸¦ »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º ¼º´É ¸ð´ÏÅÍ ¹× Çâ»ó

±³À°´ë»ó - Database Administrators
- Sales Consultants
- Support Engineer
- Technical Consultant
±³À°³»¿ë - Recovery Manager ±¸¼º
- Recovery Manager »ç¿ë
- Oracle Secure Backup
- Non-Critical ¼Õ½Ç·ÎºÎÅÍ Recovery
- Incomplete Recovery
- Flashback
- µ¥ÀÌÅͺ£À̽º ¼Õ»ó ó¸®
- ¸Þ¸ð¸® ¸ð´ÏÅÍ ¹× °ü¸®
- Automatic Performance Management
- ÀúÀå ¿µ¿ª ¸ð´ÏÅÍ ¹× °ü¸® I
- ÀúÀå ¿µ¿ª ¸ð´ÏÅÍ ¹× °ü¸® II
- ASM(Automatic Storage Management)
- VLDB Áö¿ø
- ¸®¼Ò½º °ü¸®
- Scheduler ¸¦ »ç¿ëÇÏ¿© ¾÷¹« ÀÚµ¿È­
- µ¥ÀÌÅͺ£À̽º º¸¾È
- µ¥ÀÌÅÍ À̵¿
- Globalization Support »ç¿ë
- ¿öÅ© ¼¥
¹öÀü ¹×
»çÀüÀ̼ö
°úÁ¤
- Oracle10g
- Knowledge of basic database administration
- Oracle Database 10g: Administration Workshop I Rel 2
- Oracle Database 10g: SQL Fundamentals I

Oracle Database 10g: Program with PL/SQL (PLP 10g) - 5Àϱ³À°
±³À°°³¿ä
ÀÌ °úÁ¤¿¡¼­´Â ¼ö°­»ýµé¿¡°Ô PL/SQLÀ» ¼Ò°³ÇÏ°í ÀÌ °­·ÂÇÑ ÇÁ·Î±×·¡¹Ö ¾ð¾îÀÇ ÀåÁ¡À» ¼³¸íÇÕ´Ï´Ù.
ÀÌ °úÁ¤¿¡¼­ ¼ö°­»ýµéÀº ´ÙÁß Form, º¸°í¼­ ¹× µ¥ÀÌÅÍ °ü¸® ÀÀ¿ë ÇÁ·Î±×·¥¿¡¼­ °øÀ¯ÇÒ ¼ö ÀÖ´Â ÀÀ¿ë ÇÁ·Î±×·¥ ÄÚµåÀÇ PL/SQL ºí·ÏÀ» »ý¼ºÇÏ´Â ¹æ¹ýÀ» ¹è¿ó´Ï´Ù. ¶ÇÇÑ À͸í PL/SQL ºí·Ï »ý¼º ¹æ¹ý°ú ³»Àå ÇÁ·Î½ÃÀú ¹× ÇÔ¼ö¿¡ ´ëÇØ
ÇнÀÇÕ´Ï´Ù. º¯¼ö ¼±¾ð°ú ¿¹¿Ü Æ®·¦¿¡ ´ëÇØ ¹è¿ì°í Ä¿¼­ ¼±¾ð ¹× Á¦¾î¿¡ ´ëÇؼ­µµ ¹è¿ó´Ï´Ù.
ÀÌ °úÁ¤¿¡¼­ ¼ö°­»ýµéÀº ÇÁ·Î½ÃÀú, ÇÔ¼ö, ÆÐÅ°Áö, µ¥ÀÌÅͺ£À̽º Æ®¸®°Å¿Í °°Àº PL\SQL ³»Àå ÇÁ·Î±×·¥ ´ÜÀ§¸¦ °³¹ß,
½ÇÇà ¹× °ü¸®ÇÏ´Â ¹æ¹ý¿¡ ´ëÇØ ¹è¿ì°í °´Ã¼ Á¾¼Ó¼º °ü¸®¿Í ºÎÀûÇÕÇÑ °´Ã¼ ÀçÄÄÆÄÀÏ¿¡ ´ëÇؼ­µµ ¹è¿ó´Ï´Ù.
¶ÇÇÑ LOB(Large Object)ÀÇ Æ¯¼º ¹× Á¶ÀÛ ¹æ¹ýÀ» ÀÍÈü´Ï´Ù. ¸î °¡Áö ¿À¶óŬ Á¦°ø ÆÐÅ°Áö¸¦ È°¿ëÇÏ´Â ¹æ¹ý¿¡ ´ëÇؼ­µµ
ÇнÀÇÕ´Ï´Ù.
±³À°¸ñÇ¥

- µ¥ÀÌÅͺ£À̽º¿ÍÀÇ »óÈ£ ÀÛ¿ëÀ» À§ÇÑ PL/SQL ÄÚµå ÀÛ¼º
- È¿À²ÀûÀ¸·Î ½ÇÇàµÇ´Â PL/SQL ÇÁ·Î±×·¥ ´ÜÀ§ ¼³°è
- PL/SQL ÇÁ·Î±×·¡¹Ö »ý¼ºÀÚ ¹× Á¶°ÇºÎ Á¦¾î¹® »ç¿ë
- ·±Å¸ÀÓ ¿À·ù ó¸®
- ³»Àå ÇÁ·Î½ÃÀú ¹× ÇÔ¼ö ¼³¸í
- º¸´Ù À¯¿¬¼º ÀÖ´Â ÄÚµùÀ» À§ÇÑ µ¿Àû SQL ÀÛ¼º
- ¹Ì¸® Á¤ÀÇµÈ µ¥ÀÌÅÍ À¯Çü, ·ÎÄà ¼­ºê ÇÁ·Î±×·¥, Ãß°¡ ÇÁ·Î±×·¥, Ç¥ÁØÈ­µÈ »ó¼ö ¹×
¿¹¿Ü¿¡ ´ëÇÑ PL/SQL ÄÚµå ¼³°è
- ÄÄÆÄÀÏ·¯ Warning Infrastructure »ç¿ë
- LOB(Large Object) Á¶ÀÛ
- ¾÷¹« °úÁ¦ ÇØ°áÀ» À§ÇÑ Æ®¸®°Å ÀÛ¼º
- PL/SQL ¼­ºê ÇÁ·Î±×·¥ °£ÀÇ Á¾¼Ó¼º °ü¸®
- µ¶¸³ÀûÀ¸·Î ½ÇÇàµÇµµ·Ï PL/SQL ÀÛ¾÷ ½ºÄÉÁÙ¸µ
- ³»Àå ÇÁ·Î½ÃÀú ¹× ÇÔ¼ö ÀÛ¼º
- °ü·Ã »ý¼ºÀÚ¸¦ ±×·ìÈ­ÇÏ°í Æ÷ÇÔÇϵµ·Ï PL/SQL ÆÐÅ°Áö ¼³°è
- À¯¿¬¼º Áõ´ë¸¦ À§ÇØ ¿À¹ö·ÎµåµÈ ÆÐÅ°Áö ¼­ºê ÇÁ·Î±×·¥ »ý¼º
- ¿À¶óŬ Á¦°ø PL/SQL ÆÐÅ°Áö ºÐ·ù

±³À°´ë»ó - Database Administrators
- Database Designers
- Forms Developer
- PL/SQL Developer
- Technical Consultant
±³À°³»¿ë - ½ÇÇà ¼½¼Ç »ý¼º ¹× Á¦¾î ±¸Á¶ ÀÛ¼º
- ÀÀ¿ë ÇÁ·Î±×·¥ °³¹ß ½Ã ¿À¶óŬ Á¦°ø ÆÐÅ°Áö È°¿ë
- ÇÁ·Î½ÃÀú, ÇÔ¼ö, ÆÐÅ°Áö, Æ®¸®°Å »ý¼º ¹× °ü¸®
- ¿¹¿Ü ó¸® Æ÷ÇÔ
- Á¶ÇÕ µ¥ÀÌÅÍ À¯Çü ¹× Ä¿¼­ ÀÛ¾÷
- Á¾¼Ó¼º ¹× LOB(Large Object) °ü¸®
¹öÀü ¹×
»çÀüÀ̼ö
°úÁ¤
Oracle Database 10g: Introduction to SQL

Introduction to Oracle9i : SQL (SQL 9i) - 5Àϱ³À°
±³À°°³¿ä
°ü°èÇü µ¥ÀÌŸº£À̽ºÀÇ °³³ä°ú 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
¹öÀü ¹×
»çÀüÀ̼ö
°úÁ¤
Oracle9i / »çÀüÀ̼ö°úÁ¤ ¾øÀ½

Oracle9i : Program with PL/SQL (PLP 9 i) - 5Àϱ³À°
±³À°°³¿ä
PL/SQL ¾ð¾îÀÇ ±â´É°ú ÇÁ·Î±×·¡¹Ö ¹æ¹ýÀ» ¼Ò°³ÇÏ´Â °úÁ¤ÀÌ´Ù. ÀÌ °úÁ¤À» ÅëÇؼ­ ¼ö°­»ýµéÀº PL/SQL ºí·ÏÀ»
ÀÛ¼ºÇÏ´Â ¹æ¹ýÀ» ¹è¿ï ¼ö ÀÖÀ¸¸ç, ¿©·¯ °³ÀÇ ÀÀ¿ëÇÁ·Î±×·¥¿¡¼­ °øÀ¯ÇÒ ¼ö ÀÖµµ·Ï ÀÀ¿ëÇÁ·Î±×·¥ Äڵ带 ´Ù¾çÇÑ
PL/SQL ÇÁ·Î±×·¥ÀÇ ÇüÅÂ(procedures, functions, packages, database triggers)·Î »ý¼ºÇÏ¿© µ¥ÀÌŸº£À̽º¿¡ ÀúÀå,
°ü¸®, »ç¿ëÇÏ´Â ¹æ¹ýÀ» ÀÍÈú ¼ö ÀÖ´Ù. ¶ÇÇÑ PL/SQL ÇÁ·Î±×·¥ÀÇ Á¾¼Ó¼º °ü¸®, Large Objects(LOBs) ¹× ÀϺÎ
Oracle-Supplied Packages »ç¿ë ¹æ¹ý µîµµ ½ÀµæÇÏ°Ô µÈ´Ù.
±³À°´ë»ó - ÀÀ¿ëÇÁ·Î±×·¥ °³¹ßÀÚ
- µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ
- ½Ã½ºÅÛ ºÐ¼®°¡
- ±â¼ú Áö¿ø Àü¹®°¡
±³À°³»¿ë - PL/SQLÀÇ ¿ëµµ ¹× Ư¼º
- PL/SQL Anonymous Block ±¸Á¶
- º¯¼ö ¹× »ó¼ö ¼±¾ð, PL/SQL ºí·Ï ÀÛ¼º ¹× ½ÇÇàÇϱâ
- PL/SQL¿¡¼­ SQL »ç¿ëÇÏ´Â ¹æ¹ý
- IF ¹®, LOOP ¹® ÀÛ¼º
- Composite Data Types : PL/SQL Table, PL/SQL Records
- Explicit Cursors ÀÛ¼º
- PL/SQL Exceptions ó¸®
- Procedure, Function, Package, Database Trigger ÀÛ¼º ¹× °ü¸®
- Oracle-Supplied Packages
- Object °£ÀÇ Á¾¼Ó¼º °ü¸®
- Large Objects (LOBs) »ç¿ë
¹öÀü ¹×
»çÀüÀ̼ö
°úÁ¤
Oracle9i / »çÀüÀ̼ö°úÁ¤ : Introduction to Oracle9i : SQL (Çʼö)

Oracle9i Database Administration Fundamentals I (ADM 9i) - 5Àϱ³À°
±³À°°³¿ä
µ¥ÀÌŸº£À̽º °ü¸®ÀÚ(DBA)µéÀÌ µ¥ÀÌŸº£À̽ºÀÇ °ü¸®¸¦ À§ÇÑ °ü·ÃµÈ ¾÷¹« ¹× ±â´ÉÀ» ½ÀµæÇϱâ À§ÇÑ °úÁ¤ÀÌ´Ù.
ÀÌ °úÁ¤¿¡¼­ ¼ö°­»ýµéÀº 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 ±â´É »ç¿ëÇϱâ
¹öÀü ¹×
»çÀüÀ̼ö
°úÁ¤
Oracle9i / »çÀüÀ̼ö°úÁ¤ : Introduction to Oracle9i : SQL (Çʼö)

Oracle9i Database Administration Fundamentals II (NBR 9i) - 5Àϱ³À°
±³À°°³¿ä
µ¥ÀÌŸº£À̽º °ü¸®ÀÚ(DBA)µéÀÌ Oracle9i µ¥ÀÌŸº£À̽ºÀÇ °ü¸®¸¦ À§ÇÑ °ü·Ã µÈ ¾÷¹« ¹× ±â´ÉÀ» ½ÀµæÇϱâ À§ÇÑ °úÁ¤ÀÌ´Ù. ÀÌ °úÁ¤¿¡¼­ ¼ö°­»ýµéÀº µ¥ÀÌŸº£À̽º¿¡ 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
¹öÀü ¹×
»çÀüÀ̼ö
°úÁ¤
¹öÀü : Oracle9i

»çÀüÀ̼ö°úÁ¤
- Introduction to Oracle9i : SQL (Çʼö)
- Oracle9i Database Administration Fundamentals I (Çʼö)



Oracle9i Database Performance Tuning (PTW 9i) - 5Àϱ³À°
±³À°°³¿ä
µ¥ÀÌŸº£À̽º Ãʱ⠼³°èÀÇ Á߿伺°ú Oracle9i µ¥ÀÌŸº£À̽º Æ©´× ¹æ¹ýÀ» ¼Ò°³ÇÏ´Â °úÁ¤ÀÌ´Ù.
¼ö°­»ýµéÀº ÀÌ °úÁ¤À» ÅëÇØ µ¥ÀÌŸº£À̽º¿Í ÀνºÅϽºÀÇ Æ©´×¿¡ °üÇÑ °³³äÀ» ½ÀµæÇÏ°í ½Ç½ÀÀ» ÅëÇØ ½ÇÁ¦·Î ¿À¶óŬ
µ¥ÀÌŸº£À̽ºÀÇ ¼º´É¿¡ °ü·ÃµÈ ¹®Á¦µéÀ» ÀνÄÇÏ°í ÇØ°áÇÏ´Â ¹æ¹ýÀ» ÇнÀÇÒ ¼ö ÀÖ´Ù.
±³À°´ë»ó - µ¥ÀÌŸº£À̽º °ü¸®ÀÚ
- ±â¼ú Áö¿ø Àü¹®°¡
- ½Ã½ºÅÛ °ü¸®ÀÚ
±³À°³»¿ë - 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 »ç¿ëÇϱâ
¹öÀü ¹×
»çÀüÀ̼ö
°úÁ¤
¹öÀü : Oracle9i

»çÀüÀ̼ö°úÁ¤
- Introduction to Oracle9i : SQL (Çʼö)
- Oracle9i Database Administration Fundamentals I (Çʼö)
- Oracle9i Database Administration Fundamentals II (Çʼö)

Oracle9i Database : SQL Tuning Workshop (SQLT 9i) - 3Àϱ³À°
±³À°°³¿ä
Oracle9i ¼­¹ö ȯ°æ¿¡¼­ ApplicationÀÇ ¼º´ÉÀ» Çâ»ó½ÃÅ°±â À§ÇØ SQL¹®À» È¿À²ÀûÀ¸·Î »ç¿ëÇÏ´Â ¹æ¹ýÀ» ÇнÀÇÏ´Â
°úÁ¤ÀÌ´Ù. Oracle9i Rule-Based Optimizer¿Í Cost-Based OptimizerÀÇ °³³ä, EXPLAIN, SQL Trace¿Í TKPROF, SQL*Plus AUTOTRACE µî Oracle Áø´Ü µµ±¸µéÀ» »ç¿ëÇÏ´Â ¹æ¹ý°ú Optimizer¿¡ ¿µÇâÀ» ÁÖ´Â ¹æ¹ý µîÀ» °­ÀÇ¿Í
½Ç½ÀÀ» ÅëÇØ ¹è¿ï ¼ö ÀÖ´Ù. ¶ÇÇÑ Oracle9iÀÇ »õ·Î¿î ±â´É È°¿ëÀ» ÅëÇÑ ¼º´É Çâ»óÀ» ÆľÇÇÑ´Ù.
±³À°´ë»ó - ÀÀ¿ëÇÁ·Î±×·¥ °³¹ßÀÚ
- µ¥ÀÌŸº£À̽º °ü¸®ÀÚ
- ¿À¶óŬ ÄÁ¼³ÅÏÆ®
- ±â¼ú Áö¿ø ºÐ¼®°¡
- ½Ã½ºÅÛ °ü¸®ÀÚ
±³À°³»¿ë - Tuning ¼Ò°³
- SQL¹®ÀÇ Ã³¸® °úÁ¤(Parsing ÃÖ¼ÒÈ­Çϱâ)
- ¿À¶óŬ ¸Þ¸ð¸® ±¸Á¶
- EXPLAIN, AUTOTRACE, SQL Trace, TKPROF »ç¿ë¹ý
- Rule-Based Optimization vs. Cost-Based Optimization
- À妽º,Ŭ·¯½ºÅÍ,Index-Organized Table
- Åë°è¼öÁýÇϱâ(Analyze ¸í·É, È÷½ºÅä±×·¥)
- Optimizer¿¡ ¿µÇâÁÖ±â(ÃʱâÈ­ ÆĶó¹ÌÅÍ setting ¹× hint »ç¿ë¹ý)
- Sorting°ú Joining
- Optimizer Plan Stability
- Materialized View¿Í Temporary Table
- Datawarehousing °ü·Ã±â´É
- (WITH Àý, Grouping set, Multitable Insert, MERGE, External table)
¹öÀü ¹×
»çÀüÀ̼ö
°úÁ¤
¹öÀü : Oracle9i

»çÀüÀ̼ö°úÁ¤
- Introduction to Oracle9i : SQL (Çʼö)
- Introduction to Oracle9i : PL/SQL (Çʼö)

Oracle Ids Forms : Build internet Aplications I (6i) (FRB1) - 5Àϱ³À°
±³À°°³¿ä
Oracle Developer¸¦ ÀÌ¿ëÇÏ¿© Internet ¹× Application °³¹ß ¹æ¹ýÀ» ÀÍÈ÷´Â °úÁ¤À¸·Î, Forms ¸ðµâÀ» ÅëÇØ ´Ù¾çÇÑ
À¯ÀúÀÎÅÍÆäÀ̽º¸¦ ¸¸µé°í DBÀÇ µ¥ÀÌÅ͸¦ ó¸®ÇÏ´Â ¹æ¹ýÀ» ÀÍÈ÷´Â °ÍÀÌ ÀÌ °úÁ¤ÀÇ ÁÖ¿ä ÁÖÁ¦ÀÌ´Ù.
±³À°´ë»ó - Enterprise Database Application Developer
- Technical Support Professionals
±³À°³»¿ë - Introduction to Oracle Forms Developer and Oracle Forms Server
- Running a Form Builder Application
- Working in the Form Builder Environment
- Creating a Basic Form Module
- Working with Data blocks and Frames
- Working with Text Items
- Creating LOVs, Editors, and Additional Input Items
- Creating Non-input Items
- Creating Windows and Content Canvases
- Working with Other Canvas-Views
- Introduction to Triggers
- Producing Triggers
- Adding Functionality to Items
- Runform Messages and Alerts
- Query Triggers
- Validation and Navigation
- Transaction Processing
- Writing Flexible Code
- Sharing Objects and Code
¹öÀü ¹×
»çÀüÀ̼ö
°úÁ¤
Oracle6i
   
 
   

 

Untitled Document