°³¶ËÀ̳׿¡¼ ÆÇ¸ÅµÈ "¿À¶óŬ 11g ºÎÅÍ 12c ¿Ïº® ¹ÙÀ̺í" Á¤°¡ 45,000¿ø Æò±ÕÇÒÀΰ¡
|
|
|
(1±Ç ¸ñÂ÷) Part 01 ÀÛ¾÷ ȯ°æ ¼³Á¤
Chapter 01 °¡»óÈ ¼ÒÇÁÆ®¿þ¾î(OVM VirtualBox) ¼³Ä¡ Section 01 OVM VirtualBox ¼³Ä¡
Chapter 02 ¸®´ª½º Virtual Machine(VM) »ý¼º Section 01 ¸®´ª½º ¼ÒÇÁÆ®¿þ¾î ´Ù¿î·Îµå Section 02 ¸®´ª½º VM »ý¼º(VirtualBox Àû¿ë)
Chapter 03 12c ¿À¶óŬ 12c µ¥ÀÌÅͺ£À̽º ¼ÒÇÁÆ®¿þ¾î ¼³Ä¡ Section 01 ISO À̹ÌÁö º¯È¯ Åø ´Ù¿î·Îµå Section 02 12c ¿À¶óŬ ¼ÒÇÁÆ®¿þ¾î ´Ù¿î·Îµå Section 03 ¿À¶óŬ 12c µ¥ÀÌÅͺ£À̽º ¼ÒÇÁÆ®¿þ¾î ¼³Ä¡¸¦ À§ÇÑ OS ȯ°æ ¼³Á¤ Section 04 ¿À¶óŬ 12c µ¥ÀÌÅͺ£À̽º ¼ÒÇÁÆ®¿þ¾î ¼³Ä¡ Section 05 ¿À¶óŬ 12c µ¥ÀÌÅͺ£À̽º ¼ÒÇÁÆ®¿þ¾î »èÁ¦/Á¦°Å
Chapter 04 ¿À¶óŬ 12c µ¥ÀÌÅͺ£À̽º »ý¼º Section 01 Oracle »ç¿ëÀÚ ÇÁ·ÎÆÄÀÏ ¼³Á¤ Section 02 CDB¿Í PDB µ¿½Ã »ý¼º(DBCA »ç¿ë).Advanced mode ¿É¼Ç ¼±Åà Section 03 CDB¿Í PDB µ¿½Ã »ý¼º(DBCA »ç¿ë) Create a database with default configuration] ¿É¼Ç ¼±Åà Section 04 CDB¸¸ »ý¼º(DBCA »ç¿ë) . Advanced mode ¿É¼Ç ¼±Åà Section 05 Non CDB »ý¼º(DBCA »ç¿ë) . Advanced mode ¿É¼Ç ¼±Åà Section 06 12c µ¥ÀÌÅͺ£À̽º »ý¼º ½Ã ½ºÅ©¸³Æ® »ç¿ë ¹æ¹ý Section 07 »ùÇà ½ºÅ°¸¶ ¼³Ä¡
Part 02 ¿À¶óŬ SQL
Chapter 01 SQL ±âº»°ú Select ¸í·É¾î(¹®Àå) ¼Ò°³ Section 01 SQL ¸í·É¾î(¹®Àå)ÀÇ 5°¡Áö ±¸ºÐ ¹æ½Ä Section 02 Select ¹®ÀåÀÇ Å°¿öµå(Keyword)¿Í ½ÅÅؽº(Syntax)ÀÇ ¼Ò°³ Section 03 SQL ¹®Àå »ç¿ë ½Ã À¯ÀÇ»çÇ× Section 04 »ê¼ú ¿¬»êÀÚ¿Í ¿ì¼±¼øÀ§ Section 05 ³Î(Null) °ªÀÇ »ç¿ë Section 06 Ä÷³ aliasÀÇ Á¤ÀÇ¿Í »ç¿ë Section 07 Concatenation ¿¬»êÀÚÀÇ Á¤ÀÇ¿Í »ç¿ë
Chapter 02 Where Àý »ç¿ë°ú ·Î¿ì µ¥ÀÌÅÍÀÇ ºÐ·ù Section 01 Where ÀýÀÇ »ç¿ë Section 02 ¹®ÀÚ¿°ú ³¯Â¥ÀÇ »ç¿ë Section 03 ºñ±³ Á¶°Ç ¿¬»êÀÚÀÇ »ç¿ë Section 04 ³í¸® ¿¬»êÀÚÀÇ »ç¿ë Section 05 ¿¬»êÀÚ ¿ì¼±¼øÀ§ Section 06 Order by Àý
Chapter 03 ´ÜÀÏ Çà ÇÔ¼ö(Single-row-function) Section 01 SQL ÇÔ¼ö Section 02 ¹®ÀÚ ÇÔ¼ö Section 03 ¼ýÀÚ ÇÔ¼ö Section 04 Date µ¥ÀÌÅÍ Å¸ÀÔ°ú ³¯Â¥ ÇÔ¼ö Section 05 µ¥ÀÌÅÍ Å¸ÀÔ º¯°æ ÇÔ¼ö Section 06 ¿À¶óŬ RR µ¥ÀÌÅÍ Å¸ÀÔ Çü½Ä Section 07 ³×½ºÆ®(Nested) ÇÔ¼ö Section 08 ³Î(Null) °ªÀ» ó¸®ÇÏ´Â ÇÔ¼ö Section 09 Á¶°ÇºÎ ÇÔ¼ö
Chapter 04 ±×·ì ÇÔ¼ö(Group function) Section 01 ±×·ì ÇÔ¼öÀÇ Á¤ÀÇ¿Í ±¸ºÐ Section 02 Avg, Sum Min, Max, Stddev & Variance ÇÔ¼ö Section 03 Count ({*|[Distinct|All]}) ÇÔ¼ö Section 04 ³Î(Null) °ª°ú ±×·ì ÇÔ¼ö Section 05 Group by ¹®ÀåÀÇ »ç¿ë Section 06 Having ÀýÀÇ »ç¿ë
Chapter 05 Å×À̺í Á¶ÀÎ(Table join)°ú ¿¬»ê Section 01 Cartesian products Section 02 Equi Á¶ÀÎ Section 03 Å×À̺í alias¸¦ »ç¿ëÇÏ´Â Á¶ÀÎ Section 04 Non-equi Á¶ÀÎ Section 05 Outer Á¶ÀÎ Section 06 Self Á¶ÀÎ
Chapter 06 ¼ºêÄõ¸®(Subqueries) Section 01 ¼ºêÄõ¸®(Subquery) ½ÅÅؽº(Syntax)¿Í Á¾·ù Section 02 ´ÜÀÏÇà ¼ºêÄõ¸®(Single row subquery) Section 03 ¼ºêÄõ¸®¿¡¼ ±×·ì ÇÔ¼öÀÇ »ç¿ë°ú Having Àý°úÀÇ °ü°è Section 04 º¹¼öÇà ¼ºêÄõ¸®ÀÇ Á¤ÀÇ¿Í In, Any ±×¸®°í All ¿¬»êÀÚÀÇ »ç¿ë Section 05 ¼ºêÄõ¸®¿Í ³Î(Null) °ª
Chapter 07 Data Manipulation Language(DML) »ç¿ë ¹æ¹ý Section 01 Insert ¹®ÀåÀÇ »ç¿ë Section 02 Update ¹®ÀåÀÇ »ç¿ë Section 03 Delete ¹®ÀåÀÇ »ç¿ë Section 04 DML°úWith check optionÀÇ »ç¿ë Section 05 Ä÷³¿¡ ´ëÇÑ ±âº» °ªÀÇ ¼³Á¤ ¹æ¹ý°ú Insert ¹®ÀåÀÇ Àû¿ë Section 06 Merge ¹®ÀåÀÇ »ç¿ë Section 07 Ä¿¹Ô(Commit)°ú ·Ñ¹é(Rollback) ¸í·É¾îÀÇ »ç¿ë Section 08 µ¥ÀÌÅÍ Àбâ ÀÏ°ü¼º(Read consistency) Section 09 µ¥ÀÌÅÍ Àá±Ý(Locking)
Chapter 08 Å×À̺íÀÇ »ý¼º°ú °ü¸®(±âº») Section 01 Å×ÀÌºí »ý¼º°ú ±âº» Çü½Ä Section 02 µ¥ÀÌÅÍ µñ¼Å³Ê¸® Å×À̺í/ºä¿¡ ´ëÇÑ Äõ¸® Section 03 µ¥ÀÌÅÍ Å¸ÀÔ(Data type)ÀÇ ±¸ºÐ Section 04 ¿À¶óŬ Datetime µ¥ÀÌÅÍ Å¸ÀÔÀÇ ¼Ò°³ Section 05 ¼ºêÄõ¸®¸¦ »ç¿ëÇÑ Å×À̺íÀÇ »ý¼º Section 06 Alter table ¹®ÀåÀÇ Àû¿ë- Ä÷³ÀÇ »ðÀÔ, ¼öÁ¤, Á¦°Å Section 07 Set unused ¿É¼ÇÀÇ Àû¿ë Section 08 Å×À̺íÀÇ Á¦°Å(Dropping) Section 09 Truncate table ¸í·ÉÀ» »ç¿ëÇÑ Å×À̺íÀÇ ·Î¿ì µ¥ÀÌÅÍÀÇ Á¦°Å
Chapter 09 Á¦¾à Á¶°Ç(Constraints) Section 01 Á¦¾à Á¶°ÇÀÇ Á¤ÀÇ¿Í ±¸ºÐ Section 02 Not null Á¦¾à Á¶°Ç Section 03 Primary key¿Í Foreign key Á¦¾à Á¶°Ç Section 04 Unique Á¦¾à Á¶°Ç Section 05 Check Á¦¾à Á¶°Ç Section 06 Á¦¾à Á¶°ÇÀÇ Ãß°¡ Section 07 Á¦¾à Á¶°ÇÀÇ Á¦°Å Section 08 Á¦¾à Á¶°ÇÀ» »ç¿ë ºÒ°¡´É »óÅÂ(Disable)·Î º¯°æ Section 09 Á¦¾à Á¶°ÇÀ» »ç¿ë °¡´É »óÅÂ(Enable)·Î º¯°æ Section 10 Ä÷³ Á¦°Å ½Ã Á¦¾à Á¶°ÇÀ» ÇÔ²² ¿¬¼ÓÀû(Cascade)À¸·Î Á¦°Å Section 11 ¾î¶² Ä÷³¿¡ ¾î¶² Á¦¾à Á¶°ÇÀÌ ¼³Á¤µÇ¾î ÀÖ´ÂÁö È®ÀÎ
Chapter 10 ºä(Views) Section 01 Simple ºä¿Í Complex ºäÀÇ ¼Ò°³ Section 02 ºä(View)ÀÇ »ý¼º Section 03 ºäÀÇ º¯°æ(Modify) Section 04 DML°ú ºä¿ÍÀÇ °ü°è Section 05 With check option Section 06 With read only option Section 07 ºä¸¦ ÅëÇÑ ·Î¿ì µ¥ÀÌÅÍÀÇ »èÁ¦ Section 08 ºä¸¦ ÅëÇÑ ·Î¿ì µ¥ÀÌÅÍÀÇ °»½Å°ú Ãß°¡ Section 09 ºäÀÇ Á¦°Å Section 10 ÀζóÀÎ ºä(Inline view)ÀÇ ¼Ò°³ Section 11 Top-N ºÐ¼®
Chapter 11 µ¥ÀÌÅͺ£À̽º ½ºÅ°¸¶ ¿ÀºêÁ§Æ® ¼Ò°³ Section 01 ½ÃÄö½ºÀÇ »ý¼º Section 02 Currval°ú NextvalÀÇ »ç¿ë Section 03 Æ®¸®°Å(Trigger)¿¡¼ÀÇ ½ÃÄö½º »ç¿ë Section 04 ½ÃÄö½ºÀÇ ¼öÁ¤°ú Á¦°Å Section 05 À妽ºÀÇ »ý¼º°ú Á¦°Å Section 06 ·Î¿ì ¾ÆÀ̵ð(ROWID) Section 07 ½Ã³ë´Ô(Synonym)ÀÇ »ý¼º°ú Á¦°Å
Part 04 ¸ÖƼÅ׳ÍÆ®(Multitenant) ¾ÆÅ°ÅØÃÄ
Chapter 01 ¸ÖƼÅ׳ÍÆ® ¾ÆÅ°ÅØó °³¿ä Section 01 ¸ÖƼÅ׳ÍÆ® ¾ÆÅ°ÅØó °³¿ä Section 02 CDB¿Í PDB ¿µ¿ª ÀÌÇØ Section 03 »ç¿ëÀÚ °ü¸® Section 04 ¼¼¼Ç°ú ¼ºñ½º Section 05 ¸®¼Ò½º °ü¸® Section 06 ¹é¾÷/º¹±¸/Ç÷¡½Ã¹é µ¥ÀÌÅͺ£À̽º Section 07 12.1 CDB·ÎÀÇ µ¥ÀÌÅͺ£À̽º ÀÌ°ü Chapter 02 CDB, PDB Á¢¼Ó ¹× ±âº» ¼³Á¤ ÀÌÇØ Section 01 CDB, PDB Á¢¼ÓÀ» À§ÇÑ ³×Æ®¿öÅ© ±¸¼º Section 02 CDB, PDB Á¢¼Ó ¹æ¹ý
Chapter 03 PDB »ý¼º, Á¦°Å, Ç÷¯±×ÀÎ, ¾ðÇ÷¯±×, Ãß°¡ ±¸¼º(Manual) Section 01 PDB ½Å±Ô »ý¼º Section 02 PDB ¾ðÇ÷¯±× Section 03 PDB Ç÷¯±×ÀÎ
Chapter 04 PDB »ý¼º, Á¦°Å, Ç÷¯±×ÀÎ, ¾ðÇ÷¯±×, Ãß°¡ ±¸¼º(DBCA) Section 01 PDB ½Å±Ô »ý¼º 301 Section 02 PDB ¾ðÇ÷¯±×(Generate pluggable database file set ¿É¼Ç) Section 03 PDB ¾ðÇ÷¯±×(Generate pluggable database archive ¿É¼Ç) Section 04 PDB Ç÷¯±×(Generate pluggable database file set ¿É¼Ç) Section 05 PDB Ç÷¯±×(Generate pluggable database archive ¿É¼Ç) Section 06 PDB Á¦°Å Section 07 PDB ±¸¼º ¿É¼Ç ¼³Á¤
Chapter 05 CDB, PDB ¼¼ºÎ °ü¸® Section 01 ¸ÖƼÅ׳ÍÆ® CDB, PDB ±âº» ±¸¼º Á¤º¸ È®ÀÎ Section 02 CDB, PDB ½ÃÀÛ°ú Á¾·á Section 03 CDB Á¢¼ÓÀ» À§ÇÑ ³×Æ®¿öÅ© ¼³Á¤ Section 04 PDB Á¢¼ÓÀ» À§ÇÑ ³×Æ®¿öÅ© ¼³Á¤ Section 05 CDB, PDB »ç¿ëÀÚ ¹× ±ÇÇÑ °ü¸® Section 06 CDB, PDB ÃʱâÈ ÆĶó¹ÌÅÍ ¼³Á¤ Section 07 CDB, PDB Å×ÀÌºí½ºÆäÀ̽º °ü¸®
Chapter 06 CDB, PDB ¹é¾÷ ¹× º¹±¸ Section 01 RMAN ¹é¾÷ Section 02 RMAN º¹¿ø/º¹±¸ Part 05 ¹é¾÷ ¹× º¹±¸
Chapter 01 RMAN °³¿ä Section 01 Backup & Recovery ¿ë¾î ¼Ò°³ Section 02 RMANÀÇ ±â´É ¼Ò°³
Chapter 02 RMAN ¸í·É¾î Section 01 RMAN Á¢¼Ó°ú ¸í·É¾î È®ÀÎ Section 02 RMAN ¸í·É¾î Á¾·ù Section 03 RMAN ¸í·É¾î ¼Ò°³ Section 04 RMAN ¹èÄ¡ ÆÄÀÏ
Chapter 03 ¹é¾÷ Àü ¼³Á´ Section 01 µ¥ÀÌÅͺ£À̽º ¼³Á¤ Section 02 Backup ´ë»ó È®ÀÎ Section 03 RMAN ¼³Á¤
Chapter 04 RMAN ¹é¾÷ Section 01 ÀÏ¹Ý ¹é¾÷ Section 02 Incremental ¹é¾÷
Chapter 05 RMAN º¹±¸ Section 01 ¿ÏÀü º¹±¸ Section 02 ºÒ¿ÏÀü º¹±¸ Section 03 Block corruption repair
Chapter 06 RMAN °ü¸® Section 01 Retention policy Section 02 Cross check
Chapter 07 RMAN º¹±¸ ½Ã³ª¸®¿À ½Ç½À Section 01 ±âÁ¸°ú ´Ù¸¥ À§Ä¡·Î º¹±¸ Section 02 ¿ÀÇÁ¶óÀÎ ºÒ°¡´ÉÇÑ ´ë»ó º¹±¸ Section 03 Drop table º¹±¸ Section 04 ÄÁÆ®·Ñ ÆÄÀÏ º¹±¸ Section 05 Spfile º¹±¸
Chapter 08 RMAN Catalog °ü¸® Section 01 Catalog »ý¼º Section 02 Catalog µ¥ÀÌÅͺ£À̽º µî·Ï Section 03 Catalog¸¦ È°¿ëÇÑ ½ºÅ©¸³Æ® ÀÛ¼º
Chapter 09 Datapump Àû¿ë ¹é¾÷ ¹× º¹±¸ Section 01 DatadumpÀÇ °³³ä Section 02 Expdp ½ÇÇà Section 03 Impdp ½ÇÇà
»öÀÎ(Index)
À̹ø¿¡ Ãâ°£Çϴ åÀº ±âº»ÀûÀ¸·Î 12c ¹öÀüÀ» ÅëÇØ »õ·Ó°Ô ¼Ò°³µÇ´Â ¸ÖƼÅ׳ÍÆ® ¾ÆÅ°ÅØó ÀÌÇØ°¡ Áß¿äÇÑ Æ÷ÀÎÆ®°¡ µÇ°ÚÁö¸¸ »ç½Ç»ó 11g¿Í 12c ¹öÀüÀ» ¸ðµÎ ¾Æ¿ì¸¦ ¼ö ÀÖ´Â ³»¿ëÀ¸·Î ±¸¼ºµÇ¾ú½À´Ï´Ù.
Part01¿¡¼´Â µ¶ÀÚµéÀÌ ¿À¶óŬ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ ³»¿ë ÀÌÇظ¦ À§ÇØ ½Ç½ÀÇÒ ¼ö Àִ ȯ°æÀ» ±¸¼ºÇÒ ¶§ Âü°íÇÒ ¼ö ÀÖ´Â ºÎºÐÀ» ¼Ò°³ÇÏ°í ÀÖ½À´Ï´Ù. ƯÈ÷ °¡»óÈ Linux ȯ°æ ±¸¼º °úÁ¤À» ÅëÇØ ¿äÁò ÇÑÂü ¿ä±¸µÇ°í ÀÖ´Â Linux OS¸¦ Á¶±Ý ´õ ÀÌÇØÇÒ ¼ö ÀÖ´Â ±âȸ°¡ µÇ±â ¹Ù¶ø´Ï´Ù. Part02¿¡¼´Â ¿À¶óŬ µ¥ÀÌÅͺ£À̽º¸¦ ´Ù·ç±â À§ÇØ ±âº»ÀûÀ¸·Î ÀÌÇØÇØ¾ß ÇÏ´Â SQL¿¡ ´ëÇÑ ³»¿ëÀÌ ¼Ò°³µË´Ï´Ù. Part03¿¡¼´Â µ¥ÀÌÅͺ£À̽º ¿î¿µÀÚ¿¡°Ô °¡Àå °ü½ÉÀÌ µÉ ¼ö ÀÖ´Â ¿À¶óŬ ¾ÆÅ°ÅØó¿Í ¼¼ºÎ °ü¸® ±â´ÉµéÀÌ ÀÚ¼¼È÷ ¼Ò°³µË´Ï´Ù. Part03Àº ÀúÀÚ°¡ °¡Àå °í¹ÎÀÌ ¸¹¾Ò´ø ÆÄÆ®·Î¼ ³Ê¹« ³»¿ëÀ» ±íÀÌ µé¾î°¡µµ ¾ÈµÇ°Ú°í ³Ê¹« ¾è°Ô µé¾î°¡µµ ¾ÈµÇ°Ú±â¿¡ °á±¹ Áß±Þ Á¤µµ¸¦ Ÿ°ÙÀ¸·Î ÇÏ°í ³ª¸§ Ãʺ¸Àڵ鵵 Áß±Þ ÀÌ»óÀÇ ³»¿ëÀ» ÀÌÇØÇÒ ¼ö ÀÖµµ·Ï ÇÏ¿´½À´Ï´Ù. Part04¿¡¼´Â 12c ¹öÀüÀÇ ÇÙ½É ¾ÆÅ°ÅØóÀÎ ¸ÖƼÅ׳ÍÆ®¿¡ ´ëÇÑ ³»¿ëÀÌ ´Ù·ç¾îÁý´Ï´Ù. ¾Æ¹«·¡µµ ¿ÏÀüÈ÷ »õ·Î¿î ¾ÆÅ°ÅØóÀ̹ǷΠÁ»´õ ½ÅÁßÇÏ°Ô ÇнÀÇÏ´Â °ÍÀ» ÃßõÇÕ´Ï´Ù. Part05¿¡¼´Â 12c µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ ¹é¾÷ ¹× º¹±¸ °úÁ¤¿¡ ´ëÇÏ¿© ´Ù·ç¾îÁý´Ï´Ù. RMANÀº ±× ÀÚü¸¸ ÇÏ´õ¶óµµ º°µµÀÇ Ã¥À¸·Î ÁýÇÊÇؾßÇÒ ¸¸Å Å« ÅäÇÈÀÌÁö¸¸ ÀÌ Ã¥¿¡¼´Â RMAN¿¡ ´ëÇÑ ±âº»ÀûÀÎ ³»¿ë ¼Ò°³ Á¤µµ·Î ´Ù·ç¾îÁý´Ï´Ù.
|
|
|
|
|