Post by parun on Jul 26, 2008 3:19:48 GMT 7
Ãкº¡ÒèѴ¡Òðҹ¢éÍÁÙÅ
Data Base Management
ÊѧࢻÇÔªÒ
¤ÇÒÁÃÙéà¡ÕèÂǡѺ°Ò¹¢éÍÁÙÅ ª¹Ô´¢Í§°Ò¹¢éÍÁÙÅ Ãкº°Ò¹¢éÍÁÙÅàªÔ§ÍÍ»à¨ç¤ Entity Relationship model ¡Ò÷ӢéÍÁÙÅãËéà»ç¹ºÃ÷Ѵ°Ò¹ (Normalization) ÀÒÉÒÊͺ¶ÒÁ¢éÍÁÙÅã¹Ãкº°Ò¹¢éÍÁÙÅàªÔ§ÊÑÁ¾Ñ¹¸ì (SQL: Structured Query Language) ¡ÒèѴ¡Òðҹ¢éÍÁÙÅ ÃкºÃÑ¡ÉÒ¤ÇÒÁ»ÅÍ´ÀÑ¢ͧ¢éÍÁÙÅ ¤ÇÒÁ¤§ÊÀÒ¾¢Í§°Ò¹¢éÍÁÙÅ ½Ö¡»¯ÔºÑµÔ¡ÒÃÊÃéÒ§°Ò¹¢éÍÁÙÅÊÓËÃѺ§Ò¹¸ØáԨâ´Âãªé«Í¿µìáÇÃìà¾×èÍ¡ÒèѴ¡Òðҹ¢éÍÁÙÅ
á¼¹¡ÒÃÊ͹
¤ÃÑ駷Õè à¹×éÍËÒ
1 º··Õè 1 Introduction to Database Management
• ºÍ¡¤ÇÒÁËÁÒ¢ͧ¢éÍÁÙÅ Ãкº°Ò¹¢éÍÁÙÅáÅÐÃкº¡ÒèѴ¡Òðҹ¢éÍÁÙÅä´é
• ÊÒÁÒö͸ԺÒ»ÃÐ⪹ì¢Í§Ãкº¡ÒèѴ¡Òðҹ¢éÍÁÙÅ
• ÊÒÁÒöºÍ¡ÅѡɳÐâ¤Ã§ÊÃéÒ§¢éÍ´Õ áÅТéÍàÊÕ¢ͧ°Ò¹¢éÍÁÙÅẺµèÒ§ æ
2 º··Õè 2 Data Models
• ÊÒÁÒö͸ԺÒÂÅѡɳТͧÃдѺªÑé¹¢éÍÁÙÅÃдѺµèÒ§ æ ä´é
• à¢éÒ㨶֧¤ÇÒÁÊÓ¤ÑáÅлÃÐ⪹ì¢Í§Ê¶Ò»ÑµÂ¡ÃÃÁ¢Í§Ãкº°Ò¹¢éÍÁÙÅ
• ÊÒÁÒöÃкØÀÒÉÒËÅÑ¡¢Í§Ãкº¨Ñ´¡Òðҹ¢éÍÁÙÅä´é
3 º··Õè 3 The Relational Database Model
• à¢éÒã¨á¹Ç¤ÇÒÁ¤Ô´¢Í§ÃٻẺ°Ò¹¢éÍÁÙÅàªÔ§ÊÑÁ¾Ñ¹¸ì
• à¢éÒ㨤ÇÒÁËÁÒ¢ͧ Keys µèÒ§ æ ·Õèà¡ÕèÂÇ¢éͧ¡ÑºÃٻẺ°Ò¹¢éÍÁÙÅàªÔ§ÊÑÁ¾Ñ¹¸ì
• à¢éÒ㨡®¡ÒäǺ¤ØÁ¤ÇÒÁ¤§ÊÀÒ¾¢Í§¢éÍÁÙÅ
• ÊÒÁÒö͸ԺÒ¶֧¤ÇÒÁÊÑÁ¾Ñ¹¸ì¢Í§¡ÒèѴà¡çº¢éÍÁÙÅẺµèÒ§ æ ä´é
4 º··Õè 4 Entity Relationship (ER) Modeling
• ͸ԺÒÂá¹Ç¤Ô´à¡ÕèÂǡѺẺ¨ÓÅͧ¤ÇÒÁÊÑÁ¾Ñ¹¸ìÃÐËÇèÒ§¢éÍÁÙÅ (Entity Relationship (ER) Model) ä´é
• ͸ԺÒ¤ÇÒÁÊÑÁ¾Ñ¹¸ìÃÐËÇèÒ§ÍÕ-ÍÒÃìâÁà´ÅáÅаҹ¢éÍÁÙÅàªÔ§ÊÑÁ¾Ñ¹¸ìä´é
• à¢éÒã¨áÅÐ͸ԺÒ¶֧¢Ñ鹵͹¡ÒÃá·¹¤ÇÒÁÊÑÁ¾Ñ¹¸ì¢Í§¢éÍÁÙÅ´éÇ ER Diagram ä´é
• à¢éÒã¨áÅÐ͸ԺÒ¢Ñ鹵͹¡ÒÃá»Å§ ER à»ç¹ Relation ä´é
5 º··Õè 5 Normalization of Database Tables
• à¢éÒ㨤ÇÒÁËÁÒ¢ͧ¿Ñ§¡ìªÑ¹¡ÒâÖé¹µè͡ѹ (Functional Dependency)
• à¢éÒã¨ÃٻẺ·Õèà»ç¹ºÃ÷Ѵ°Ò¹ (Normalization) ã¹áµèÅТÑé¹ä´é
• ºÍ¡¢éͤÇäӹ֧㹡Ò÷ÓãËéà»ç¹ÃٻẺ·Õèà»ç¹ºÃ÷Ѵ°Ò¹ä´é
6 º··Õè 6 Introduction to Structured Query Language (SQL)
• ͸ԺÒÂÅѡɳÐÀÒÉÒÊÓËÃѺ¡Ó˹´â¤Ã§ÊÃéÒ§ä´é
• à¢éÒã¨áÅÐ͸ԺÒÂÅѡɳÐÀÒÉÒÊÓËÃѺ¡ÒèѴ¡Òðҹ¢éÍÁÙÅä´é
7 º··Õè 7 Database Design
• à¢éÒã¨áÅÐ͸ԺÒ¢Ñ鹵͹¢Í§Ç§¨ÃªÕÇÔµ¢Í§¡ÒþѲ¹ÒÃкº°Ò¹¢éÍÁÙÅ(DBLC)
• à¢éÒã¨áÅÐ͸ԺÒ¢鹵͹¡ÒÃÍ͡Ẻ°Ò¹¢éÍÁÙÅàªÔ§ÊÑÁ¾Ñ¹¸ìä´é
8 º··Õè 8 Data Security
• à¢éÒã¨á¹Ç·Ò§¢Í§¡ÒÃÃÑ¡ÉÒ¤ÇÒÁ»ÅÍ´ÀÑ¢ͧ°Ò¹¢éÍÁÙÅ
• à¢éÒ㨡ÒÃãªé¤ÓÊÑè§ÀÒÉÒ SQL 㹡ÒáÓ˹´ÊÔ·¸Ô¡ÒÃà¢éÒ㨰ҹ¢éÍÁÙÅ áÅСÒáàÅÔ¡ÊÔ·¸Ôä´é
9 º··Õè 9 Transaction Management and Concurrency Control
• à¢éÒ㨤ÇÒÁËÁÒÂáÅФسÊÁºÑµÔ¢Í§·Ãҹ૤ªÑ¹ (Transaction) ·Õèãªéã¹Ãкº°Ò¹¢éÍÁÙÅ
• àÃÕ¹ÃÙé¶Ö§ËÅÑ¡¡Òâͧ·Ãҹ᫤ªÑ¹
• ÈÖ¡ÉÒàÃ×èͧ¡ÒäǺ¤ØÁ¡Ò÷ӧҹ¾ÃéÍÁ¡Ñ¹ (Concurrency Control)
• ÈÖ¡ÉÒÁҵáÒÃ㹡ÒáÙé¤×¹¢éÍÁÙÅ (Data Recovery) à¾×èͤÇÒÁ¤§ÊÀÒ¾¢Í§Ãкº°Ò¹¢éÍÁÙÅ
Data Base Management
ÊѧࢻÇÔªÒ
¤ÇÒÁÃÙéà¡ÕèÂǡѺ°Ò¹¢éÍÁÙÅ ª¹Ô´¢Í§°Ò¹¢éÍÁÙÅ Ãкº°Ò¹¢éÍÁÙÅàªÔ§ÍÍ»à¨ç¤ Entity Relationship model ¡Ò÷ӢéÍÁÙÅãËéà»ç¹ºÃ÷Ѵ°Ò¹ (Normalization) ÀÒÉÒÊͺ¶ÒÁ¢éÍÁÙÅã¹Ãкº°Ò¹¢éÍÁÙÅàªÔ§ÊÑÁ¾Ñ¹¸ì (SQL: Structured Query Language) ¡ÒèѴ¡Òðҹ¢éÍÁÙÅ ÃкºÃÑ¡ÉÒ¤ÇÒÁ»ÅÍ´ÀÑ¢ͧ¢éÍÁÙÅ ¤ÇÒÁ¤§ÊÀÒ¾¢Í§°Ò¹¢éÍÁÙÅ ½Ö¡»¯ÔºÑµÔ¡ÒÃÊÃéÒ§°Ò¹¢éÍÁÙÅÊÓËÃѺ§Ò¹¸ØáԨâ´Âãªé«Í¿µìáÇÃìà¾×èÍ¡ÒèѴ¡Òðҹ¢éÍÁÙÅ
á¼¹¡ÒÃÊ͹
¤ÃÑ駷Õè à¹×éÍËÒ
1 º··Õè 1 Introduction to Database Management
• ºÍ¡¤ÇÒÁËÁÒ¢ͧ¢éÍÁÙÅ Ãкº°Ò¹¢éÍÁÙÅáÅÐÃкº¡ÒèѴ¡Òðҹ¢éÍÁÙÅä´é
• ÊÒÁÒö͸ԺÒ»ÃÐ⪹ì¢Í§Ãкº¡ÒèѴ¡Òðҹ¢éÍÁÙÅ
• ÊÒÁÒöºÍ¡ÅѡɳÐâ¤Ã§ÊÃéÒ§¢éÍ´Õ áÅТéÍàÊÕ¢ͧ°Ò¹¢éÍÁÙÅẺµèÒ§ æ
2 º··Õè 2 Data Models
• ÊÒÁÒö͸ԺÒÂÅѡɳТͧÃдѺªÑé¹¢éÍÁÙÅÃдѺµèÒ§ æ ä´é
• à¢éÒ㨶֧¤ÇÒÁÊÓ¤ÑáÅлÃÐ⪹ì¢Í§Ê¶Ò»ÑµÂ¡ÃÃÁ¢Í§Ãкº°Ò¹¢éÍÁÙÅ
• ÊÒÁÒöÃкØÀÒÉÒËÅÑ¡¢Í§Ãкº¨Ñ´¡Òðҹ¢éÍÁÙÅä´é
3 º··Õè 3 The Relational Database Model
• à¢éÒã¨á¹Ç¤ÇÒÁ¤Ô´¢Í§ÃٻẺ°Ò¹¢éÍÁÙÅàªÔ§ÊÑÁ¾Ñ¹¸ì
• à¢éÒ㨤ÇÒÁËÁÒ¢ͧ Keys µèÒ§ æ ·Õèà¡ÕèÂÇ¢éͧ¡ÑºÃٻẺ°Ò¹¢éÍÁÙÅàªÔ§ÊÑÁ¾Ñ¹¸ì
• à¢éÒ㨡®¡ÒäǺ¤ØÁ¤ÇÒÁ¤§ÊÀÒ¾¢Í§¢éÍÁÙÅ
• ÊÒÁÒö͸ԺÒ¶֧¤ÇÒÁÊÑÁ¾Ñ¹¸ì¢Í§¡ÒèѴà¡çº¢éÍÁÙÅẺµèÒ§ æ ä´é
4 º··Õè 4 Entity Relationship (ER) Modeling
• ͸ԺÒÂá¹Ç¤Ô´à¡ÕèÂǡѺẺ¨ÓÅͧ¤ÇÒÁÊÑÁ¾Ñ¹¸ìÃÐËÇèÒ§¢éÍÁÙÅ (Entity Relationship (ER) Model) ä´é
• ͸ԺÒ¤ÇÒÁÊÑÁ¾Ñ¹¸ìÃÐËÇèÒ§ÍÕ-ÍÒÃìâÁà´ÅáÅаҹ¢éÍÁÙÅàªÔ§ÊÑÁ¾Ñ¹¸ìä´é
• à¢éÒã¨áÅÐ͸ԺÒ¶֧¢Ñ鹵͹¡ÒÃá·¹¤ÇÒÁÊÑÁ¾Ñ¹¸ì¢Í§¢éÍÁÙÅ´éÇ ER Diagram ä´é
• à¢éÒã¨áÅÐ͸ԺÒ¢Ñ鹵͹¡ÒÃá»Å§ ER à»ç¹ Relation ä´é
5 º··Õè 5 Normalization of Database Tables
• à¢éÒ㨤ÇÒÁËÁÒ¢ͧ¿Ñ§¡ìªÑ¹¡ÒâÖé¹µè͡ѹ (Functional Dependency)
• à¢éÒã¨ÃٻẺ·Õèà»ç¹ºÃ÷Ѵ°Ò¹ (Normalization) ã¹áµèÅТÑé¹ä´é
• ºÍ¡¢éͤÇäӹ֧㹡Ò÷ÓãËéà»ç¹ÃٻẺ·Õèà»ç¹ºÃ÷Ѵ°Ò¹ä´é
6 º··Õè 6 Introduction to Structured Query Language (SQL)
• ͸ԺÒÂÅѡɳÐÀÒÉÒÊÓËÃѺ¡Ó˹´â¤Ã§ÊÃéÒ§ä´é
• à¢éÒã¨áÅÐ͸ԺÒÂÅѡɳÐÀÒÉÒÊÓËÃѺ¡ÒèѴ¡Òðҹ¢éÍÁÙÅä´é
7 º··Õè 7 Database Design
• à¢éÒã¨áÅÐ͸ԺÒ¢Ñ鹵͹¢Í§Ç§¨ÃªÕÇÔµ¢Í§¡ÒþѲ¹ÒÃкº°Ò¹¢éÍÁÙÅ(DBLC)
• à¢éÒã¨áÅÐ͸ԺÒ¢鹵͹¡ÒÃÍ͡Ẻ°Ò¹¢éÍÁÙÅàªÔ§ÊÑÁ¾Ñ¹¸ìä´é
8 º··Õè 8 Data Security
• à¢éÒã¨á¹Ç·Ò§¢Í§¡ÒÃÃÑ¡ÉÒ¤ÇÒÁ»ÅÍ´ÀÑ¢ͧ°Ò¹¢éÍÁÙÅ
• à¢éÒ㨡ÒÃãªé¤ÓÊÑè§ÀÒÉÒ SQL 㹡ÒáÓ˹´ÊÔ·¸Ô¡ÒÃà¢éÒ㨰ҹ¢éÍÁÙÅ áÅСÒáàÅÔ¡ÊÔ·¸Ôä´é
9 º··Õè 9 Transaction Management and Concurrency Control
• à¢éÒ㨤ÇÒÁËÁÒÂáÅФسÊÁºÑµÔ¢Í§·Ãҹ૤ªÑ¹ (Transaction) ·Õèãªéã¹Ãкº°Ò¹¢éÍÁÙÅ
• àÃÕ¹ÃÙé¶Ö§ËÅÑ¡¡Òâͧ·Ãҹ᫤ªÑ¹
• ÈÖ¡ÉÒàÃ×èͧ¡ÒäǺ¤ØÁ¡Ò÷ӧҹ¾ÃéÍÁ¡Ñ¹ (Concurrency Control)
• ÈÖ¡ÉÒÁҵáÒÃ㹡ÒáÙé¤×¹¢éÍÁÙÅ (Data Recovery) à¾×èͤÇÒÁ¤§ÊÀÒ¾¢Í§Ãкº°Ò¹¢éÍÁÙÅ