¸ðµç Á¶Á÷ÀÌ µ¿ÀÏÇÑ ¹æ½ÄÀ¸·Î ÀÛ¾÷·®À» ºÐ´ãÇÏÁö´Â ¸øÇÕ´Ï´Ù. Ç¥ 26¿¡´Â ±âŸ ¸î¸î °øÅëµÈ Á÷Ã¥, º¸Åë ÀÛ¾÷¿¡ ¼ö¹ÝµÇ´Â Ÿ½ºÅ©, ÀÌ·¯ÇÑ Å¸½ºÅ©¸¦ ¼öÇàÇÏ´Â µ¥ ÇÊ¿äÇÑ ±ÇÇÑ ¶Ç´Â Ư±ÇÀÌ ³ª¿µÇ¾î ÀÖ½À´Ï´Ù.
Ç¥ 26. °øÅë Á÷Ã¥, Ÿ½ºÅ© ¹× Çʼö ±ÇÇÑ ºÎ¿©
Á÷Ã¥ | Ÿ½ºÅ© | Çʼö ±ÇÇÑ ºÎ¿© |
---|---|---|
ºÎ¼ °ü¸®ÀÚ | ºÎ¼ ½Ã½ºÅÛ °¨µ¶, µ¥ÀÌÅͺ£À̽º ÀÛ¼º | SYSCTRL ±ÇÇÑ. ºÎ¼¿¡ ÀÚ½ÅÀÇ ÀνºÅϽº°¡ ÀÖÀ¸¸é SYSADM ±ÇÇÑ |
º¸¾È °ü¸®ÀÚ | ÀϺΠ¶Ç´Â ¸ðµç ±ÇÇÑ ¹× Ư±Ç¿¡ ´ëÇØ ´Ù¸¥ »ç¿ëÀÚ¿¡°Ô ±ÇÇÑ ºÎ¿© | SYSADM ¶Ç´Â DBADM ±ÇÇÑ |
µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ | Çϳª ÀÌ»óÀÇ µ¥ÀÌÅͺ£À̽º¸¦ ¼³°è, °³¹ß, Á¶ÀÛ, º¸È£ ¹× À¯Áöº¸¼ö | Çϳª ÀÌ»óÀÇ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ DBADM ¹× SYSMAINT ±ÇÇÑ. ¾î¶² °æ¿ì¿¡´Â SYSCTRL ±ÇÇÑ |
½Ã½ºÅÛ Á¶ÀÛ¿ø | µ¥ÀÌÅͺ£À̽º¸¦ ¸ð´ÏÅÍÇÏ°í ¹é¾÷ ±â´É ¼öÇàÇÔ | SYSMAINT ±ÇÇÑ |
ÀÀ¿ëÇÁ·Î±×·¥ ÇÁ·Î±×·¡¸Ó | µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ ÀÀ¿ëÇÁ·Î±×·¥ °³¹ß ¹× Å×½ºÆ®, Å×½ºÆ® µ¥ÀÌÅÍ Å×À̺í ÀÛ¼º | ±âÁ¸ ÆÐŰÁö¿¡ BINDADD ¹× BIND, Çϳª ÀÌ»óÀÇ µ¥ÀÌÅͺ£À̽º¿¡ CONNECT ¹× CREATETAB, ÀϺΠƯÁ¤ ½ºÅ°¸¶ ±ÇÇÑ, ÀϺΠÅ×ÀÌºí¿¡ ´ëÇÑ Æ¯±Ç ¸ñ·Ï |
»ç¿ëÀÚ ºÐ¼®°¡ | ½Ã½ºÅÛ Ä«Å»·Î±× ºä¸¦ °Ë»çÇÏ¿© ÀÀ¿ëÇÁ·Î±×·¥¿¡ ´ëÇÑ µ¥ÀÌÅÍ ¿ä±¸·® Á¤ÀÇ | īŻ·Î±× ºä¿¡ ´ëÇØ¼´Â SELECT, Çϳª ÀÌ»óÀÇ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ¼´Â CONNECT |
ÇÁ·Î±×·¥ ÀÏ¹Ý »ç¿ëÀÚ | ÀÀ¿ëÇÁ·Î±×·¥ ½ÇÇà | ÆÐŰÁö¿¡ ´ëÇØ¼´Â EXECUTE, Çϳª ÀÌ»óÀÇ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ¼´Â CONNECT. ÀÌ Å×ÀÌºí ´ÙÀ½ÀÇ ÁÖ ÂüÁ¶ |
Á¤º¸ ¼¾ÅÍ »ó´ã¿ø | Á¶È¸ »ç¿ëÀÚÀÇ µ¥ÀÌÅÍ ¿ä±¸»çÇ× Á¤ÀÇ, Å×ÀÌºí ¹× ºä¸¦ ÀÛ¼ºÇÏ°í µ¥ÀÌÅͺ£À̽º ¿ÀºêÁ§Æ®·Î ¾×¼¼½º ±ÇÇÑÀ» ºÎ¿©ÇÏ¿© µ¥ÀÌÅÍ Á¦°ø | Çϳª ÀÌ»óÀÇ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ DBADM ±ÇÇÑ |
Á¶È¸ »ç¿ëÀÚ | SQL¹®À» ¹ßÇàÇÏ¿© µ¥ÀÌÅÍ °Ë»ö, Ãß°¡, »èÁ¦ ¶Ç´Â º¯°æ, °á°ú¸¦ Å×À̺í·Î ÀúÀå | Çϳª ÀÌ»óÀÇ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ¼´Â CONNECT, ÀÛ¼ºÁßÀÎ Å×ÀÌºí ¹× ºäÀÇ ½ºÅ°¸¶¿¡ ´ëÇØ¼´Â CREATEIN, ±×¸®°í ÀϺΠÅ×ÀÌºí ¹× ºä¿¡ ´ëÇØ¼´Â SELECT, INSERT, UPDATE, DELETE |
ÀÀ¿ëÇÁ·Î±×·¥¿¡ µ¿Àû SQL¹®ÀÌ µé¾î ÀÖÀ¸¸é, ÇÁ·Î±×·¥ ÀÏ¹Ý »ç¿ëÀÚ°¡ EXECUTE ¹× CONNECT ÀÌ¿ÜÀÇ ´Ù¸¥ Ư±Ç(¿¹: SELECT, INSERT, DELETE ¹× UPDATE)ÀÌ ÇÊ¿äÇÒ ¼öµµ ÀÖ½À´Ï´Ù.