À¥ °³¹ß¼. ÀÌ Ã¥Àº Query¿Í PL/SQLÀº ¿¹Á¦¸¦ ÅëÇØ °³³äÀ» ÀÌÇØÇÒ ¼ö ÀÖµµ·Ï ±¸¼ºÇÑ °ÍÀ¸·Î ¿À¶óŬ µ¥ÀÌÅÍ º£À̽º ¼³Ä¡¿¡¼ºÎÅÍ SQL ÇÔ¼ö¸¦ ÀÌ¿ëÇÏ´Â ¹æ¹ý, PL/SQL ·Î ¿«¾î³»´Â À̾߱â¿Í ¿À¶óŬ ¼¹ö µîÀÇ ³»¿ëÀ» ¼³¸íÇÑ´Ù.
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 ¼³Ä¡ ¹× È°¿ë