Query¿Í PL/SQLÀº ¿¹Á¦¸¦ ÅëÇØ °³³äÀ» ÀÌÇØÇϵµ·Ï Á¢±ÙÇÏ¿´°í, °¢ ±¸¼º ºÎºÐ¿¡ ³»¿ëÀÇ È帧ÀÌ À̾îÁöµµ·Ï ÇÏ¿© µ¶ÀÚµéÀÌ ´Ü°èº°·Î ÀÌÇØÇÏ¿© Á¢±ÙÇÒ ¼ö ÀÖµµ·Ï ±¸¼ºµÇ¾î ÀÖ½À´Ï´Ù.
¿À¶óŬ 10gÀÇ ÀÀ¿ë »ç·Ê¿¡¼´Â ÀÎ»ç °ü¸®¿Í ÁÖ¹® °ü¸®¶ó´Â ¾÷¹« Àû¿ë »ç·Ê¸¦ ÅëÇØ ¾÷¹« ÀûÀÀ·ÂÀ» ³ôÀÌ°í »õ·Î¿î ±â¼úµéÀÌ Àû¿ëµÇ´Â »ç·Êµµ ³»¿ë¿¡ Ãß°¡ÇÏ¿´½À´Ï´Ù.
°³¹ß ½Ã °í·ÁÇØ¾ß ÇÒ º¸¾ÈÀ̳ª À¯Æ¿¸®Æ¼ÀÇ ³»¿ëÀ» ´Ù·ç¾ú½À´Ï´Ù.
µ¥ÀÌÅͺ£À̽º ½ºÅ°¸¶(Schema)¸¦ »ý¼ºÇϱâ À§ÇÑ µ¥ÀÌÅÍ ¸ðµ¨¸µ ºÎºÐÀ» ´Ù·ç¾ú½À´Ï´Ù.
¡á ÀÌ Ã¥Àº ´©±¸¸¦ À§ÇÑ °ÍÀΰ¡
¿À¶óŬ 10g·Î ¿À¶óŬ¿¡ ÀÔ¹®ÇÏ·Á´Â ºÐ
Àû¿ë »ç·Ê¸¦ ÅëÇØ ¾÷¹« ÀûÀÀ·ÂÀ» ³ôÀÌ°íÀÚ ÇϽô ºÐ
¿À¶óŬ 10g °³³äÀ» ºü¸¥ ½Ã°£ ³» ÀÌÇØÇÏ°íÀÚ ÇϽô ºÐ
°³¹ß ½Ã µ¥ÀÌÅͺ£À̽º º¸¾ÈÀ̳ª ¿À¶óŬÀÌ Á¦°øÇÏ´Â À¯Æ¿¸®Æ¼¸¦ Àû¿ëÇÏ°íÀÚ ÇϽô ºÐ
¸ñÂ÷
1. µ¥ÀÌÅͺ£À̽º¸¦ ¸¸µé´Ù
1.1 Oracle Database 10g ¼³Ä¡
1.2 Oracle Database 10g Á¦°Å
1.3 ´ÙÀ½ ÇнÀÀ» À§ÇÑ Áغñ
2. µ¥ÀÌÅÍ ¾ò±â ù°ÉÀ½À» ³»µó´Ù - SQL(Structured Query Language)
2.1 ³» ¸¾´ë·Î µ¥ÀÌÅÍ ¾ò±â - SELECT
2.2 WHERE Àý
2.3 ORDER BY
2.4 GROUP BY
2.5 HAVING
3. SQL ÇÔ¼ö¸¦ ÅëÇØ ¸ÚÁø ÁúÀǹ® ¸¸µé±â - SQL Functions
3.1 ´ÜÀÏ Çà ÇÔ¼ö(Single-Row Functions)
3.2 ÁýÇÕ ÇÔ¼ö(Aggregate Functions)
3.3 ºÐ¼® ÇÔ¼ö(Analytical Functions)
3.4 Á¤±Ô Ç¥Çö½Ä(Regular Expression)
4. µ¥ÀÌÅÍ ¾ò±â ÇÑ °ÉÀ½ ´õ ³»µó´Ù
4.1 Á¶ÀÎ(JOIN)
4.2 ÇÏÀ§ ÁúÀÇ(Subquery)
4.3 GROUP BY ÀýÀÇ È®Àå
4.4 °èÃþÀû ÁúÀÇ
5. µ¥ÀÌÅÍ Á¶ÀÛÀÇ Àå¾Ö¸¦ Á¦°ÅÇ϶ó - DML
5.1 TRANSACTION Á¡·ÉÇϱâ
5.2 Á¦¾à Á¶°Ç(Constraints) ÆÄÇìÄ¡±â
5.3 µ¥ÀÌÅÍ »çÀü (Data Dictionary)
6. µ¥ÀÌÅ͸¦ ´ãÀ» ±×¸©À» ¸¸µéÀÚ - µ¥ÀÌÅͺ£À̽º °´Ã¼(Database Object)
6.1 µ¥ÀÌÅ͸¦ ´ã´Â ±×¸© - Å×À̺í(Table)
6.2 À妽º(Index)
6.3 ºä (View)
6.4 ½ÃÄö½º (Sequence)
7. SQLÀÇ ÇѰ踦 ³Ñ¾î - PL/SQL
7.1 PL/SQL ù°ÉÀ½
7.2 Stored Procedure
7.3 Ä¿¼(Cursor)ÀÇ È°¿ë
7.4 ¿¹¿Ü ó¸®
8. PL/SQL·Î ¿«¾î³»´Â À̾߱â.
8.1 »ç¿ëÀÚ Á¤ÀÇ ÇÔ¼ö(Stored Function)
8.2 ÆÐÅ°Áö(Package)
8.3 Æ®¸®°Å(Trigger)
9. Oracle ÀÀ¿ë ¿¹Á¦¸¦ ÅëÇÑ ½Ç·Â Å°¿ì±â
9.1 ÀÎ»ç °ü¸®(Human Resource)
9.2 ÁÖ¹® °ü¸®(Order Entry)
10. Oracle Server ³»ºÎ·ÎÀÇ ¿©Çà - Server Architecture
10.1 Oracle Instance(¿À¶óŬ ÀνºÅϽº)
10.2 µ¥ÀÌÅͺ£À̽º
11. ¿ø°Ý µ¥ÀÌÅͺ£À̽º·Î °¡ÀÚ - Application Architecture
11.1 Client / Server Architecture
11.2 Multitier Architecture
11.3 Oracle Net Service
12. ¹®¼ÀÇ µ¥ÀÌÅ͸¦ ¿Å°Ü º¼±î? - Oracle Utility
12.1 Oracle Data Pump
12.2 SQL*Loader
13. µ¥ÀÌÅÍÀÇ ¾ÈÀüÀ» ³» ¼ÕÀ¸·Î - Database Security
13.1 µ¥ÀÌÅͺ£À̽º º¸¾È °³¿ä
13.2 ÀÎÁõ
13.3 Virtual Private Database (VPD)
14. µ¥ÀÌÅÍ ¸ðµ¨¸µÀÇ ¼¼°è·Î - Data Modeling
14.1 ¾÷¹« ºÐ¼®
14.2 ³í¸®Àû µ¥ÀÌÅÍ ¼³°è
14.3 ¹°¸®Àû µ¥ÀÌÅÍ ¸ðµ¨¸µ
14.4 ERwin Data Modeler ¼³Ä¡ ¹× È°¿ë
ÀÛ°¡¼Ò°³
±èűÙ
»õ·Î¿î °Í¿¡ ´ëÇÑ °ü½É ±×¸®°í, ¾Æ´Â °Í¿¡ ´ëÇØ ±íÀ̸¦ ´õÇÏ´Â Áñ°Å¿òÀ» ½ÇõÇÏ°í ÀÖ´Ù. Oracle µ¥ÀÌÅͺ£À̽º¸¦ ÀÌ¿ëÇÏ¿© À¥ °³¹ßÀ» ÇßÀ¸¸ç, Çѱ¹Á¤º¸±â¼ú¿¬±¸¿ø(KITRI)¿¡¼ µ¥ÀÌÅͺ£À̽º(Oracle, SQL Server) °ÀǸ¦ Çß´Ù. ÇöÀç ÇÁ¸®·£¼·Î OCP-DBA 9i, 10g ÀÚ°Ý °úÁ¤ °ÀǸ¦ ÇÏ°í ÀÖ´Ù.