Textbooks and Reference Resources(教科書與參考資源)

Textbooks(recommended but not required)

• Avi Silberschatz, Henry F. Korth and S. Sudarshan. Database System Concepts, 7th Edition, McGraw-Hill, 2019.
• Ramez Elmasri and Shamkant B. Navathe. Fundamentals of Database Systems, 7th Edition, Pearson, 2016.

Recommended Books

1. C. J. Date. Database Design and Relational Theory: Normal Forms and All That Jazz, 2nd Edition. PApress, 2019.
2. Carlos Coronel and Steven Morris. Database Systems: Design, Implementation, and Management, 13th Edition. Cengage Learning, 2018.
3. Wilfried Lemahieu, Bart Baesens and Seppe vanden Broucke. Principles of Database Management: The Practical Guide to Storing, Managing and Analyzing Big and Small Data. Cambridge University Press, 2018.
4. Thomas Connolly and Carolyn Begg. Database Systems- A Practical Approach to Design, Implementation, and Management, 6th Edition. Pearson, 2015.
5. Garcia-Molina, J. D. Ullman, and J. Widom. Database Systems: The Complete Book, 2nd Edition. Prentice Hall, 2008.
6. Jeffrey D. Ullman and Jennifer Widom. A First Course in Database Systems, 3rd Edition. Prentice Hall, 2007.

SQL Language References

1. Alan Beaulieu. Learning SQL: Generate, Manipulate, and Retrieve Data, 3rd Edition. O'Reilly Media, 2020.
2. Anthony Molinaro and Robert de Graaf. SQL Cookbook: Query Solutions and Techniques for All SQL Users, 2nd Edition. O'Reilly Media, 2020.
3. Upom Malik, Matt Goldwasser, Benjamin Johnston. SQL for Data Analytics: Perform fast and efficient data analysis with the power of SQL, 3rd Edition. Packt Publishing, 2022.
4. Bobby Iliev. Introduction to SQL. MIT License, 2020.
5. GoalKicker.com. SQL Notes for Professionals. (good desktop reference)
6. Mike McGrath. SQL in Easy Steps, 4th Edition. In Easy Steps Ltd. 2020.
7. Kevin Kline, Daniel Kline and Brand Hunt. SQL in a Nutshell: A Desktop Quick Reference, 4th Edition. O'Reilly Media, Inc. 2020.
8. Ben Forta.SQL in 10 Minutes a Day, Sams Teach Yourself, 5th Edition. Sams Publishing, 2019.
9. James R. Groff, Paul N. Weinberg, Paul Weinberg, James Groff. SQL: The Complete Reference, 3rd Edition.. McGraw-Hill, 2009.

PHP and MySQL References

1. Robin Nixon. Learning PHP, MySQL & JavaScript, 7th Edition. O'Reilly Media, Inc., 2024.
2. Jon Ducket. PHP & MySQL: Server-side Web Development. Wiley, 2022.
3. W. J. Gilmore. Beginning PHP and MySQL: From Novice to Professional, 5th Edition, Apress, 2018.
4. Andrew Comeau and Stephen Burge. MySQL Explained: Your Step By Step Guide, 2nd Edition, CreateSpace Independent Publishing Platform, 2017.
5. Luke Welling, Laura Thomson. PHP and MySQL Web Development, 5th Edition, Addison-Wesley Professional, 2016.
6. Paul DuBois. MySQL, 5th Edition (Developer's Library). Addison-Wesley Professional, 2013.

Python Programming References

1. Eric Matthes. Python Crash Course: A Hands-On, Project-Based Introduction to Programming, 3rd Edition, No Starch Press, 2023.
2. Steve Holden, Anna Ravenscroft and Alex Martelli. Python in a Nutshell, 4td Edition, O'Reilly Media, Inc. 2023.
3. Johannes Ernesti and Peter Kaiser. Python 3: The Comprehensive Guide to Hands-On Python Programming, Rheinwerk Computing, 2022.
4. Brett Slatkin. Effective Python: 135 Specific Ways to Write Better Python, 3rd Edition. Addison-Wesley Professional, 2024.
5. Luciano Ramalho. Fluent Python: Clear, Concise, and Effective Programming, 2nd Edition. O'Reilly Media, 2022.
6. Wes McKinney. Python for Data Analysis: Data Wrangling with Pandas, NumPy, and Ipython, 3rd Edition, O'Reilly Media, 2022.

On-line References

1. Wikibooks. Structured Query Language (https://en.wikibooks.org/wiki/Structured_Query_Language) (SQL:2011)
2. Wikibooks. MySQL (https://en.wikibooks.org/wiki/MySQL)
3. Wikibooks. PostgreSQL (https://en.wikibooks.org/wiki/PostgreSQL)