¸ê®Æ®w¨t²Î·§½× (Introduction to Database Systems) |
---|
Spring, 2016
|
½Ò¸¹ | EE320152/A
Instructor
| ³sÄ£«n (Yao-Nan Lien)
| ®É¶¡
| Monday 1,2,9 (8:10am-10am, 5:10PM-6:00PM)
| ¦aÂI
| I310
| Office
| I626
| Phone
| 1811
| E-mail
| yaonanlien@asia.edu.tw, lien@cherry.cs.nccu.edu.tw
| Home Page
| www.cs.nccu.edu.tw/~lien
| Office Hours
| Mon 10-12am, 1-4PM, Tue 10-12am, 1-4pm or By appointment or By Email
| Textbook
| 1. 1. ¸ê®Æ®w¨t²Î²z½×»P¶}µo¹ê°È, ³¯·|¦w, ºX¼Ð
| 2. Fundamentals of Database Systems, By Elmasri and Navathe, Addison Wesley. |
---|
±Â½Ò«ÂI
|
1. SQL (Structed Query Language) ¡@¡@ | 2. ¸ê®Æ®wºÞ²z¨t²ÎªººÞ²z»PºûÅ@
| | 3. ¨t²Î¤ÀªR·§©À
| | |
---|
References:
|
½Òµ{¶i«×
|
1 | 2016/2/22 | ¸ê®Æ®w²¤¶
2
| 2016/2/29
| ¸É°²
| 3
| 2016/3/7
| ¸ê®Æ®w¨t²Î | Database Systems 4
| 2016/3/14
| ÃöÁp¦¡¸ê®Æ®w¼Ò«¬ | Relational Database Model 5
| 2016/3/21
| ÃöÁp¦¡¸ê®Æ®w¼Ò«¬»PSQL | Relational Database Model and SQL 6
| 2016/3/28
| ¸ê®Æ®w³]p»P¹êÅéÃöÁp¼Ò«¬
| Database Design and Entity-Relationship Model 7
| 2016/4/4
| ²M©ú¸`
| 8
| 2016/4/11
| ¸ê®Æ®w¥¿³W¤Æ and SQL
| Database Normalization and SQL 9
| 2016/4/18
| ´Á¤¤¦Ò
| 10
| 2016/4/25
| ¬d¸ß³B²z
| Query Processing 11
| 2016/5/2
| SQL Server or MySQL
| 12
| 2016/5/9
| ¥æ©ö¨t²Î | Transaction Systems 13
| 2016/5/16
| °ª¥i¾a«×¥æ©ö¨t²Î
| High Available Transaction Systems 14
| 2016/5/23
| ¸ê®Æ®w¨t²Î®Ä¯à½Õ®Õ
Performance Tuning | Performance Tuning 15
| 2016/5/30
| ¸ê®Æ±´°É»P¤j¼Æ¾Ú
| Data Mining and Big Data 16
| 2016/6/6
| ´Á¥½±M®×³ø§i
| Project Report 17
| 2016/6/13
| ´Á¥½±M®×³ø§i
| Project Report 18
| 2016/6/20
| ´Á¥½±M®×³ø§i
| Project Report |
---|
Grading:
|
Midterm | 30%
Final
| 30%
| ±M®×³ø§i
| 40%
| |
---|
±M®×
|
¥H3-4¦ì¦P¾Ç²Õ¦¨¤@ӹζ¤, ¬°¤ä´©¤j³W¼Ò¦ÛµM¨a®`³]p¤@ӱϨa¸ê®Æ®w
|
¨Ò¦p: ¦a¾_¨a°Ï¤§±Ï¨a
|
±M®×³ø§i¤º®e
|
±M®×³ø§i®æ¦¡
|