¹Ù·Î°¡±â ¸Þ´º
º»¹® ¹Ù·Î°¡±â
ÁÖ¸Þ´º ¹Ù·Î°¡±â

Cloud Academy

±³À°°³¿ä
±³À° Ä¿¸®Å§·³°ú °­»ç´Â »çÁ¤¿¡ ÀÇÇØ º¯°æµÉ ¼ö ÀÖ½À´Ï´Ù.
±³À°¸í,¸¦ Æ÷ÇÔÇÑ ±³À°°úÁ¤ Ç¥
±³À°¸í Áß±Þ Migrating On-Prem Data Mart to Autonomous Data Warehouse Cloud 1Â÷
±³À°±â°£ 2019-03-28 ~ 2019-03-29
±³À°½Ã°£ 09:30~17:30(1ÀÏ 7½Ã°£, ÃÑ 14½Ã°£)
±³À°Àå ¿µ¿ì±Û·Î¹ú·¯´×  Áöµµº¸±â
°­»ç
Á¤¿ø 20¸í
±³À°ºñ 722,000¿ø[VAT º°µµ]


±³À°¼Ò°³
º» °úÁ¤¿¡ On-Premises Data Mart¸¦ Oracle Autonomous Data Warehouse Cloud·Î ¸¶À̱׷¹À̼ÇÇÏ´Â ¹æ¹ýÀ» ¼³¸íÇÕ´Ï´Ù.
Data Warehousingȯ°æ¿¡¼­ ÀÛ¾÷ÇÏ´Â DBA°¡ µ¥ÀÌÅ͸¦ Ŭ¶ó¿ìµå·Î À̵¿Çϰí Oracle Autonomous Data Warehouse Cloud ¼­ºñ½º¸¦ »ç¿ëÇÏ¿©, ºÎ¼­º° Data Mart¸¦ ½Å¼ÓÇÏ°Ô »ý¼ºÇÏ·Á¸é
¸¶À̱׷¹ÀÌ¼Ç ±â¼úÀ» ¹è¿ó´Ï´Ù.
±³À°¸ñÇ¥
• Data WarehousingÀ» À§ÇÑ Oracle Cloud Platform
• Oracle Autonomous Database Cloud ¼­ºñ½ºÀÇ ÁÖ¿ä ±â´É ½Äº°
• ¸¶À̱׷¹ÀÌ¼Ç ¹æ¹ý ¼±Åà ½Ã °í·ÁÇÒ »çÇ× È®ÀÎ
• ±âÁ¸ Data Marts¸¦ Oracle Cloud·Î ÀÌÀüÇÏ´Â ´Ü°è ½Äº°
• ¸¶À̱׷¹ÀÌ¼Ç Àü·« ºÐ¼® ¹× ¼±ÅÃ
• ¸¶À̱׷¹À̼ÇÀ» À§ÇÑ ¼Ò½º ¹× Ÿ°Ùµ¥ÀÌÅͺ£À̽º ½Ã½ºÅÛ Áغñ
• SQL Developer¸¦ »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º Å×ÀÌºí ¸¶À̱׷¹À̼Ç
• Oracle Data Pump¸¦ »ç¿ëÇÏ¿© On-Premises Oracle Database schema ¸¶À̱׷¹À̼Ç
• ¸¶À̱׷¹ÀÌ¼Ç ÈÄ È®ÀÎ ÀÛ¾÷ ¼öÇà
±³À°´ë»ó
- Database Administrator
- Cloud Administrator
- Cloud System Integrator
- Cloud Application Developer
- Cloud Database Administrator
- Cloud Data Architect
- Cloud Technical Consultant
- Cloud Architect

¡Ø ÇʼöÀ̼ö°úÁ¤: Experience in Oracle Database 11g/12c Administration, Oracle Database Backup & Recovery
±³À°³»¿ë

• °úÁ¤ ¹Ì¸®º¸±â 

- ÄÚ½º ȯ°æ 

- ÄÚ½º ¸ñÇ¥ °³¿ä 

- ÀüÁ¦ Á¶°Ç Oracle Big Data Cloud Service ¼Ò°³ 

 

• On-Premises Data Mart¸¦ Autonomous Data Warehouse·Î ¸¶À̱׷¹ÀÌ¼Ç : °³¿ä 

- Oracle Autonomous Data Warehouse Cloud : ÁÖ¿ä ±â´É 

- ±âº» Data Warehouse ¾ÆÅ°ÅØÃ³ 

- Data WarehousingÀ» À§ÇÑ Oracle Cloud Platform 

- Data Warehouse : ¼Ò°³ ¹× Á¤ÀÇ 

- Autonomous Data Warehouse Cloud·ÎÀÇ ¼Õ½¬¿î ¸¶À̱׷¹À̼Ǡ

- Oracle Data Warehouse Cloud Services¸¦ Á¦°øÇؾßÇÏ´Â ÀÌÀ¯ 

- ¸¶À̱׷¹ÀÌ¼Ç ¹æ¹ýÀ» ¼±ÅÃÇϱâ À§ÇÑ ÀϹÝÀûÀÎ °í·Á »çÇ× 

- Oracle Autonomous Cloud Platform 

 

• ¸¶À̱׷¹ÀÌ¼Ç Àü·« ºÐ¼® ¹× ¼±Åà

- ¹æ¹ý ¼±ÅÃÇϱâ 

- Ÿ°Ù Ŭ¶ó¿ìµå µ¥ÀÌÅͺ£À̽ºÀÇ ¸¶À̱׷¹ÀÌ¼Ç ¶óÀÌÇÁ »çÀÌŬ 

- ¸¶À̱׷¹ÀÌ¼Ç °í·Á »çÇ× 

- ¸¶À̱׷¹ÀÌ¼Ç Àü·« : ¼±Åà ±âÁØ 

- ¸¶À̱׷¹À̼ÇÀÇ ÀÌÁ¡

 

• ¸¶À̱׷¹À̼ÇÀ» À§ÇÑ ¼Ò½º ¹× ´ë»ó ½Ã½ºÅÛ Áغñ 

- Ÿ°Ù ¼­ºñ½º ÀνºÅϽº Áغñ

- ¸¶À̱׷¹À̼ÇÀ» À§ÇÑ ¼Ò½º µ¥ÀÌÅͺ£À̽º Áغñ 

- Ÿ°Ù ½Ã½ºÅÛ ¸¸µé±â : Autonomous Data Warehouse Cloud ÀνºÅϽº 

- Oracle Cloud Infrastructure °´Ã¼ ÀúÀå¼Ò¸¦ »ç¿ëÇÏ¿© ÀúÀå¼Ò ¹öŶ 

 

• SQL Developer¸¦ »ç¿ëÇÏ¿© ¸¶À̱׷¹À̼Ǡ

- ¸¶À̱׷¹ÀÌ¼Ç ÈÄ È®ÀÎ : üũ¸®½ºÆ® 

- Ưº° °í·Á »çÇ× 

- SQL Developer¸¦ »ç¿ëÇÏ¿© °³Ã¼ ¸¶À̱׷¹À̼Ǡ

- ¸¶À̱׷¹À̼ÇÀ» À§ÇÑ SQL Developer ¿ÀÆÛ¸µ 

- Oracle SQL Developer : ¸¶À̱׷¹ÀÌ¼Ç °í·Á »çÇ× 

 

• Data Pump¸¦ »ç¿ëÇÏ¿© On-Premises Database Schema ¸¶À̱׷¹À̼Ǡ

- ¿ÜºÎ Å×À̺í 

- On-Premises 11g ¶Ç´Â 12c Non-CDB ¶Ç´Â CDB¿¡¼­ ADWC ¼­ºñ½º ÀνºÅϽº·Î ½ºÅ°¸¶ ¸¶À̱׷¹À̼Ǡ

- Ưº° °í·Á »çÇ× 

- Oracle Data Pump : °³¿ä ¹× ÁÖ¿ä ±â´É 

- Data Pump°¡ Å×ÀÌºí ·Î¿ì µ¥ÀÌÅ͸¦ ·ÎµåÇÏ°í ¾ð·ÎµåÇÏ´Â ¹æ¹ý 

- Oracle Autonomous Data Warehouse Cloud·Î ´ýÇÁ ÆÄÀÏ °¡Á® ¿À±â 

- Á÷Á¢ °æ·Î ·Îµå ¹× ¾ð·Îµå 

 

• ¸¶À̱׷¹ÀÌ¼Ç ÈÄ È®ÀΠ

- Oracle Object Store¿¡¼­ µ¥ÀÌÅÍ Äõ¸® 

- ¿ÜºÎ Å×À̺íÀ» »ç¿ëÇÏ¿© Äõ¸® µ¥ÀÌÅÍ 

- °á·Ð 

- ¿ÜºÎ µ¥ÀÌÅÍ °ËÁõ 

- ¸¶À̱׷¹ÀÌ¼Ç ÈÄ È®ÀΠüũ¸®½ºÆ® 

- ¼Ò½º¿Í Ÿ°Ù ºñ±³ 

- Å×½ºÆ® Äõ¸® ½ÇÇàÇϱâ 

ÇпøÀÇ ¼³¸³¤ý¿î¿µ ¹× °ú¿Ü±³½À¿¡ °üÇÑ ¹ý·ü ½ÃÇà·É¿¡ µû¶ó ´ÙÀ½°ú °°ÀÌ ¼ö°­·á¸¦ ȯºÒÇØµå¸³´Ï´Ù.

  1. ¹Ýȯ±âÇÑ : ¹Ýȯ»çÀ¯°¡ ¹ß»ýÇÑ °æ¿ì ¹Ýȯ±âÁØ¿¡ µû¶ó ¹Ýȯ»çÀ¯ ¹ß»ýÀϷκÎÅÍ 5ÀÏ À̳»¿¡ ±³½ÀºñµîÀ» ȯºÒÇØ µå¸®°Ú½À´Ï´Ù.
  2. ¹Ýȯ±âÁØ
    • 1) ±³½ÀÀ» ÇÒ ¼ö ¾ø°Å³ª ±³½ÀÀå¼Ò¸¦ Á¦°øÇÒ ¼ö ¾ø°Ô µÈ ³¯À» ±âÁØÀ¸·Î ÀÌ¹Ì ³³ºÎÇÑ ±³½ÀºñµîÀ» ÀÏÇÒ °è»êÇÑ ±Ý¾×À» ȯºÒÇØ µå¸®°Ú½À´Ï´Ù.
    • 2) ±³½À±â°£ÀÌ 1°³¿ù À̳»ÀÎ °æ¿ì, ´ÙÀ½°ú °°ÀÌ È¯ºÒÇØ µå¸®°Ú½À´Ï´Ù.
      - ±³½À½ÃÀÛ Àü : ÀÌ¹Ì ³³ºÎÇÑ ±³½ÀºñµîÀÇ Àü¾×
      - ÃÑ ±³½À½Ã°£ 1/3 °æ°ú Àü : ÀÌ¹Ì ³³ºÎÇÑ ±³½ÀºñµîÀÇ 2/3¿¡ ÇØ´çÇÏ´Â ±Ý¾×
      - ÃÑ ±³½À½Ã°£ 1/2 °æ°ú Àü : ÀÌ¹Ì ³³ºÎÇÑ ±³½ÀºñµîÀÇ 1/2¿¡ ÇØ´çÇÏ´Â ±Ý¾×
      - ÃÑ ±³½À½Ã°£ 1/2 °æ°ú ÈÄ : ¹ÝȯÇÏÁö ¾ÊÀ½
    • 3) ±³½À±â°£ÀÌ 1°³¿ùÀ» ÃʰúÇÏ´Â °æ¿ì, ´ÙÀ½°ú °°ÀÌ È¯ºÒÇØ µå¸®°Ú½À´Ï´Ù.
      - ±³½À½ÃÀÛ Àü : ÀÌ¹Ì ³³ºÎÇÑ ±³½ÀºñµîÀÇ Àü¾×
      - ±³½À½ÃÀÛ ÈÄ : ¹Ýȯ»çÀ¯°¡ ¹ß»ýÇÑ ÇØ´ç¿ùÀÇ ¹Ýȯ ´ë»ó ±³½Àºñµî(±³½À±â°£ 1°³¿ù À̳» ±âÁØ »êÃâ±Ý¾×)°ú ³ª¸ÓÁö ¿ùÀÇ ±³½Àºñµî Àü¾×À» ÇÕ»êÇÑ ±Ý¾×