¢º
Oracle 10g °ÀÇ Áøµµ ¹× »ó¼¼ ³»¿ë
|
|
°ú
Á¤ |
¿À¶óŬ °úÁ¤ |
|
±³À°¸ñÀû |
1.
¿À¶óŬ¸¦ ¿ø¸® Áß½ÉÀ¸·Î °øºÎÇϰíÀÚ ÇÏ´Â
»ç¶÷
2. ¿À¶óŬ¸¦ ÀÌ¿ëÇÏ¿© SQL ÇÁ·Î±×·¡¹ÖÀ»
ÇϰíÀÚ ÇÏ´Â »ç¶÷
3. ¿À¶óŬ¸¦ ÀÌ¿ëÇÏ¿© DB¸¦ °³¹ßÇϰíÀÚ
ÇÏ´Â »ç¶÷
4 ¿À¶óŬÀÇ ¿ø¸®¸¦ ÀÌÇØÇϰí
¼³¸íÇÒ ¼ö ÀÖ´Ù.
5 ¿À¶óŬ¸¦ ÀÌ¿ëÇÏ¿© DB¸¦
¼³°èÇÏ°í ±¸ÇöÇÒ ¼ö ÀÖ´Ù.
6 ¿À¶óŬÀÇ ³»ºÎ±¸Á¶¸¦ ÀÌÇØÇϰí
¼³¸íÇÒ ¼ö ÀÖ´Ù. |
|
±³À°´ë»ó |
1. Ãë¾÷ÀÌ ¸ñÀûÀÎ °æ¿ì
2. »ç³»¿¡¼ ´ã´ç¾÷¹«¸¦ Ã¥ÀÓÁ®¾ßÇÒ °æ¿ì
3. À¥»çÀÌÆ® °³³äÀ» ÆÄ¾ÇÇÏ·Á°íÇÒ °æ¿ì
4. Çб³¼ö¾÷À» º¸ÃæÇϱâÀ§ÇÑ °æ¿ì
5. ±âÃʺÎÅÍ È°¿ë±îÁö ½ÀµæÀ» ¿øÇϴ°æ¿ì
6. Á»´õ Àü¹®ÀûÀÌ°í °í³À̵µÀÇ »çÀÌÆ®
Á¦ÀÛÀ» ¿øÇÏ´Â °æ¿ì |
|
|
| ÁÖÂ÷ |
¼¼ºÎ°úÁ¤ |
|
|
1/2
ÁÖÂ÷
1ZO-047 |
- [1Z0-047] Oracle Database 10g: Introduction
to 10g SQL
Oracle Database 10g µ¥ÀÌÅͺ£À̽º ±â¼úÀ»
¼Ò°³
°ü°èÇü
µ¥ÀÌÅͺ£À̽ºÀÇ °³³ä°ú °·ÂÇÑ SQL ÇÁ·Î±×·¡¹Ö ¾ð¾î
.
query ÀÛ¼º, Å×ÀÌºí µ¥ÀÌÅÍ Á¶ÀÛ, µ¥ÀÌÅͺ£À̽º
°´Ã¼
»ý¼º ¹× ¸ÞŸ µ¥ÀÌÅÍ query ÀÛ¾÷
- Search data using advanced
sub queries
- Retrieve row and column data
from tables with the SELECT
statement
- Employ SQL functions to generate
and retrieve customized data
- Run data manipulation statements
(DML) to update data in the
Oracle Database 10g
- Control user access and manage
schema objects
|
|
|
|
- [1Z0-042 ] Oracle Database 10g:
Administration Workshop I
¿À¶óŬ µ¥ÀÌÅͺ£À̽ºÀÇ
¼³Ä¡ ¹× À¯Áö °ü¸® ,
¿À¶óŬ µ¥ÀÌÅͺ£À̽º ±¸Á¶ ÇØ´ç ±¸¼º ¿ä¼ÒÀÇ »óÈ£ ÀÛ¿ë
- Oracle Net ¼ºñ½º ±¸¼º- À¯Àú °èÁ¤ »ý¼º
¹× °ü¸®
- Oracle Database 10g ¼³Ä¡ ¹× µ¥ÀÌÅͺ£À̽º
±¸¼º
- µ¥ÀÌÅͺ£À̽º ÀúÀå ¿µ¿ª ±¸Á¶ °ü¸®
- Oracle Instance °ü¸®
- µ¥ÀÌÅͺ£À̽º ¸ð´ÏÅÍ, ¹®Á¦ ÇØ°á ¹× À¯Áö °ü¸®
- µ¥ÀÌÅͺ£À̽º ¹× ÆÄÀÏ °£ µ¥ÀÌÅÍ À̵¿
- µ¥ÀÌÅͺ£À̽º ¹é¾÷ ¹× Recovery ¼öÇà |
|
|
|
- [1Z0-043 ] Oracle Database 10g:
Administration Workshop II
µ¥ÀÌÅͺ£À̽º °ü¸®
ºÐ¾ß¿¡¼ ¿À¶óŬ Àü¹®°¡·Î¼ ¼º°øÇÒ ¼ö ÀÖµµ·Ï,¿À¶óŬ µ¥ÀÌÅͺ£À̽º
¸¦ ´Ù±¹¾î ÀÀ¿ë ÇÁ·Î±×·¥¿ëÀ¸·Î ±¸¼ºÇÏ´Â ¹æ¹ýÀ» ¹è¿ó´Ï´Ù.
-
VLDB °ü¸®Resource Manager¸¦ »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º
¸®¼Ò½º »ç¿ë·® Á¦¾î
- µ¥ÀÌÅͺ£À̽º ¹× °³º° ¼¼¼Ç¿¡ ´ëÇÑ ¾ð¾î Á¾¼Ó µ¿ÀÛ Ä¿½ºÅ͸¶ÀÌÁî
- ºí·Ï ¼Õ»óÀ» °¨ÁöÇÏ°í ¹®Á¦ ÇØ°áÀ» À§ÇÑ ÀûÀýÇÑ Á¶Ä¡¼öÇà
- º¸¾È µ¥ÀÌÅͺ£À̽º ±¸Çö ÀÌÀü ½ÃÁ¡À¸·Î µ¥ÀÌÅͺ£À̽º Recovery
- Áø´Ü¿ë µ¥ÀÌÅͺ£À̽º ·Î±×ÆÄÀÏ °ËÅä Scheduler¸¦
»ç¿ëÇÏ¿© °ü¸®¾÷¹« °£¼ÒÈ
- Ç÷§Æû °£ µ¥ÀÌÅÍ À̵¿
- Oracle Secure BackupÀ» »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º
¹é¾÷¹× Recovery
- Oracle Flashback ±â¼úÀ» »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º
Recovery
- RMANÀ» »ç¿ëÇÏ¿© ¹é¾÷ ¼Â°úImage Copy »ý¼º
¹× °ü¸®
- ´Ù¾çÇÑ µ¥ÀÌÅͺ£À̽º Advisor ¹× ºä¸¦»ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º
¼º´É ¸ð´ÏÅÍ ¹× Çâ»ó |
|
|
|
-
[1Z0-147 ]
Oracle Database 10g: PL/SQL 1
´ÙÁß Form, º¸°í¼,µ¥ÀÌÅÍ °ü¸®
ÀÀ¿ë ÇÁ·Î±×·¥¿¡¼ °øÀ¯ÇÒ ¼ö ÀÖ´Â ÀÀ¿ë ÇÁ·Î±×·¥ ÄÚµåÀÇPL/SQL
ºí·ÏÀ» »ý¼º ,À͸í PL/SQL ºí·Ï »ý¼º, ³»Àå ÇÁ·Î½ÃÀú
¹× ÇÔ¼ö,º¯¼ö ¼±¾ð
- Design PL/SQL anonymous blocks
that execute efficiently
- Write PL/SQL code to interface
with the database
- Describe the features and syntax
of PL/SQL
- Use PL/SQL programming constructs
and conditionally control code flow
- Handle runtime errors - Create
simple procedures and functions
- Design PL/SQL packages to group
and contain related constructs
- Schedule PL/SQL jobs to run independently
- Write dynamic SQL for more coding
flexibility
- Create triggers to solve business
challenges
- Manage dependencies between PL/SQL
subprograms |
|