|
|
|
|
|
±³À°°úÁ¤¼Ò°³ |
|
|
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 |
|
|
|
|
|
|
|
|
|