|
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 |
- º¸¾È |