|
Getting Started |
|
|
- °úÁ¤ °³¿ä
- Structured Query Language ¼Ò°³
- ºñÁî´Ï½º ½Ã³ª¸®¿À ¼Ò°³
|
|
Basic Queries |
|
|
- SQL procedure °³¿ä
- columns ¼±ÅÃ
- rows ¼±ÅÃ
|
|
Displaying Query Results |
|
|
- data Á¤·Ä ¹× ±âŸ
- data ¿ä¾à
|
|
Subqueries |
|
|
- ºñ»óÈ£°ü·Ãsubqueries
- »óÈ£°ü·Ãsubqueries (self-study)
|
|
SQL Joins |
|
|
- SQL joins ¼Ò°³
- complex SQL joins
|
|
Set Operators |
|
|
- set ¿¬»êÀÚµé ¼Ò°³
- EXCEPT operator
- INTERSECT operator
- UNION operator
- OUTER UNION operator
|
|
Tables °ú Views »ý¼º |
|
|
- Proc SQL·Î views »ý¼º
- Proc SQL·Î table »ý¼º (self-study)
- ¹«°á¼º Á¦¾àÁ¶°Ç(self-study)
- UNION operator
- OUTER UNION operator
|
|
±âŸ SQL Procedure ±â´É |
|
|
- SQL procedure ¿É¼Ç ¼³Á¤
- dictionary tables °ú views
- macro¾ð¾î¿ÍPROC SQL ÀÎÅÍÆäÀ̽º
- program testing ¹×performance
|
|
Managing Tables |
|
|
- indexes ¼Ò°³
- indexes »ý¼º (self-study)
- ±âŸ SQL ¹®Àåµé
|
|
Accessing Relational Databases (Self-Study) |
|
|
- LIBNAME ÀÌ¿ëÇÑDBMS data Á¢±Ù
- SQL Pass-Through ±â´ÉÀ» »ç¿ëÇÏ¿© ÇØ´ç DBMSÀÇ SQL
|
|