|
|
|
OS / ¸®´ª½ºÈ°¿ë |
¸®´ª½º ¼³Ä¡ |
1~2ÁÖ |
¸í·É¾î(1)-±âÃÊ |
vi ÆíÁý±â È°¿ë ¹× °£´ÜÇÑ ½ºÅ©¸³Æ® ½ÇÇàÆÄÀÏ ¸¸µé±â |
¸í·É¾î(2)-¸Þ¸ð¸® ¹× µð½ºÅ© °ü¸® ¸í·É¾î |
¸í·É¾î(3)-¸Þ¸ð¸® ¹× µð½ºÅ© ¼º´É¸ð´ÏÅ͸µ ¸í·É¾î |
Telnet, FTP ±¸¼º ¹× ¼ºñ½º ÁßÁö |
¹æȺ® ¼³Á¤ ¹× ÇØÁ¦ |
³×Æ®¿öÅ© ¸ð´ÏÅ͸µ |
´ÙÁß ½Ã½ºÅÛ ³×Æ®¿öÅ· ±¸¼º |
±³À°¼º°ú Å×½ºÆ® |
Database °³·Ð ¹× Database Modelling |
Ãʺ¸ÀÚ¸¦ À§ÇÑ µ¥ÀÌÅͺ£À̽º ¼Ò°³ |
1ÁÖ |
¼³°èÀÌ·Ð |
ÆÀº° ¼³°è½Ç½À |
ERD ÀÛ¼º ¹× ½Ç½À |
±³À°¼º°ú Å×½ºÆ® |
½Ç¹«½Ã½ºÅÛ±¸¼º -Oracle Installation & Patch |
Oracle ¼³Ä¡¸¦ À§ÇÑ OS 셑Æà |
1ÁÖ |
9i Installation ¹× Patch |
10g Installation ¹× Patch |
11g Installation ¹× Patch |
±³À°¼º°ú Å×½ºÆ® |
10g SQL (5ÀÏ) |
WDP(WorkForce Development Program)±³À°³»¿ë |
4ÁÖ |
10g Workshop 1(5ÀÏ) |
WDP(WorkForce Development Program)±³À°³»¿ë |
10g Workshop 2(5ÀÏ) |
WDP(WorkForce Development Program)±³À°³»¿ë |
10g Performance Tuning(5ÀÏ) |
WDP(WorkForce Development Program)±³À°³»¿ë |
Database Programing(1) -PL/SQL |
PL/SQL¹®¹ý |
1ÁÖ |
Procedure ÀÛ¼º |
Trigger ÀÛ¼º |
±³À°¼º°ú Å×½ºÆ® |
Database Programing(2) -SQL Tuning |
½ÇÇà°èȹÆľÇÀ» À§ÇÑ È¯°æ¼³Á¤ |
1ÁÖ |
OptimizerÀÌ·Ð |
½ÇÇà°èȹ ºÐ¼® |
SQL¹® ÀÛ¼º¿ä·É |
±³À°¼º°ú Å×½ºÆ® |
Database Backup & Recovery |
OS ToolÀ» ÀÌ¿ëÇÑ ¹é¾÷ |
1ÁÖ |
OS ToolÀ» ÀÌ¿ëÇÑ º¹±¸ |
RmanÀ» ÀÌ¿ëÇÑ ¹é¾÷ |
RmanÀ» ÀÌ¿ëÇÑ º¹±¸ |
±³À°¼º°ú Å×½ºÆ® |
°í±Þ½Ã½ºÅÛ±¸¼º1 - RAC |
RAC °³¿ä - ÀÌ·Ð ¼ö¾÷ |
1ÁÖ |
RAC ±¸¼ºÀ» À§ÇÑ Áغñ |
RAC ±¸¼º ½Ç½À(1)-½Å±Ô±¸¼º |
RAC ±¸¼º ½Ç½À(2)-Node Ãß°¡ |
±³À°¼º°ú Å×½ºÆ® |
°í±Þ½Ã½ºÅÛ±¸¼º2 - Data Guard |
Data Guard °³¿ä - ÀÌ·Ð ¼ö¾÷ |
1ÁÖ |
Data Guard ±¸¼º |
Data Guard È°¿ë-Failover |
Oracle Replication °³¿ä ¹× ±¸¼º |
±³À°¼º°ú Å×½ºÆ® |
°í±Þ½Ã½ºÅÛ±¸¼º3 - Partitioning |
Partitoning °³³ä |
1ÁÖ |
Table Partitoning ±¸¼º |
Index Partitioning ±¸¼º |
Partion °ü¸® |
±³À°¼º°ú Å×½ºÆ® |
½Ç¹«DB°ü¸®ToolÈ°¿ë -Data Migration |
Data export ¹× import |
1ÁÖ |
sqlloaderÀÇ È°¿ë |
Database ÀÌÀü |
Database º¹Á¦ |
±³À°¼º°ú Å×½ºÆ® |
11g New Feature À̷¼ ÀÛ¼º ¹× ¸éÁ¢¿ä·É |
11g¿Í 10gÀÇ ºñ±³, ½Ç½À |
1ÁÖ |
À̷¼ ÀÛ¼º ¹× ¸éÁ¢¿ä·É |