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