¡¡ |
 |
¡¡ |
|
¡¡ |
 |
¡¡ |
¡è¹öưŬ¸¯
soldesk@nate.com
|
|
¡¡ |
|
¡¡ |
 |
¡¡ |
Á¶È¸¼ö
|
6220
|
±³À°°úÁ¤
|
[IBM / DB2 °ü¸®ÀÚ] IBM ¼¹ö DB2 °ü¸®ÀÚ, ¿À¶óŬÀÚ°ÝÁõ, ±¹ºñ ³»ÀϹè¿òÄ«µå, OCP, OCA, OCM, 10gDBA, 11gDBA, WDP/OAEC¿À¶óŬ °øÀα³À°±â°ü, ITÃë¾÷/ÀÚ°ÝÁõ Àü¹® ¼Öµ¥½ºÅ©Çпø ÄÄÇ»Åͱ³À°Çпø
|
|
|
|
|
|
|
IBMÀÇ µ¥ÀÌÅͺ£À̽º Á¦Ç°ÀÎ DB2ÀÇ ±âÃÊ °³³ä ¹× ±âº» ¾ÆÅ°ÅØÃĸ¦ ÀÌÇØÇÏ°í ±âº» °ü¸® ¹æ¹ýÀ» ½ÀµæÇÏ¿© ÇØ´ç ÀÚ°ÝÁõÀ» ÃëµæÇÑ´Ù. |
| | |
|
|
|
- µ¥ÀÌÅͺ£À̽º¿¡ °ü½ÉÀÌ Àְųª µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ ¹× °ü·Ã ¾÷Á¾ÀÇ Ãë¾÷À» ÁغñÇÏ´Â ´ëÇлý |
| | |
|
|
|
 |
[ÆòÀÏ] ÀÏÀÏ 3½Ã°£¾¿ ÁÖ 5ÀÏ 19:30~22:30 [ÁÖ¸»] (Åä) 14:00~20:00 / (ÀÏ) 10:00~18:00 [¼ö°»ýµéÀÇ µ¿Àǽà Á¶Á¤ °¡´É] |
 |
 |
10:00~13:00 |
 |
14:00~17:00 |
 |
19:30~22:30 |
 |
Åä : 14:00~20:00 ÀÏ : (10:00~18:00) |
 |
- IBM °øÀα³À°(AIX,DB2) °³¹ßÀÚ °úÁ¤ ½Ç½Ã - 15~20 ¸íÀÇ ¼Ò¼öÁ¤¿øÁ¦µµ - Çö ÀÎÆ®¶ó³Ý ÃÖ°í ½Ç¹«ÁøÀÇ ½Ç¹«±³À° - ±³À° °»çÆò°¡Á¦ ½Ç½Ã - ¿Â¶óÀΰú ¿ÀÇÁ¶óÀÎÀÇ ÀÌÁß±³À°À¸·Î ±³À°È¿°ú ±Ø´ëÈ |
 |
IBM °øÀα³Àç |
 |
±³À°¼¾ÅͼҰ³ Âü°í | |
| | |
|
|
|
|
Understanding a Table |
- Å×À̺íÀÇ ÀÌÇØ |
Data Modeling and Database Design |
- µ¥ÀÌÅ͸𵨸µ°ú µ¥ÀÌÅͺ£À̽º ¼³°è |
RDBMS¿Í SQL ¼Ò°³ |
- µ¥À̹öº£À̽º ¹× SQL °³³ä ÀÌÇØ |
Simple SQL Queries |
- ´Ü¼ø Á¶È¸ |
Retrieving Data from Multiple Tables |
- JOINÀ» ÀÌ¿ëÇÑ Á¶È¸ |
Scalar Functions and Arithmetic |
- ½ºÄ®¶ó ÇÔ¼ö ¹× ¿¬»ê |
Column Functions |
- Ä÷³ ÇÔ¼ö |
Union |
- À¯´Ï¿ÂÀ» ÀÌ¿ëÇÑ Á¶È¸ |
Using Subquery |
- ¼ºêÄõ¸®¸¦ ÀÌ¿ëÇÑ Á¶È¸ |
Maintaining Data |
- »ðÀÔ/º¯°æ/»èÁ¦ |
Overview of DB2 |
- DB2 ¼Ò°³ |
CLP and GUI |
- CLP ¹× GUI Tool ¼Ò°³ |
DB2 environment |
- ÀνºÅϽº |
Creating Database and Data Placemant |
- µ¥À̹öº£À̽º ¹× Å×ÀÌºí½ºÆäÀ̽º |
Creating Database Object |
- µ¥ÀÌÅͺ£À̽º ¿ÀºêÁ§Æ® |
Moving Data |
- ÆÄÀÏ, Å×ÀÌºí°£ µ¥ÀÌÅÍ À̵¿ |
Backup and Recovery |
- °¡¼Óµµ ¼¾¼(±¸½½ ±¼¸®±â ÇÁ·Î±×·¥) |
Locking and Concurrency |
- Àá±Ý ¹× µ¿½Ã»ç¿ë¼º |
Problem Determination |
- ¹®Á¦ ÇØ°á |
Application Issue and Performance |
- ÀÀ¿ëÇÁ·Î±×·¥ |
Security |
- º¸¾È | | | |
| |
|
| | |
 |
|
 | | |
|
|
|
|
|
|
|
 |
¡¡ |
|
|
|
|
|
|
|