Textbooks and Reference Resources(教科書與參考資源)
Textbooks(recommended but not required)
Recommended Books
- C. J. Date. Database Design and Relational Theory: Normal Forms and All That Jazz, 2nd Edition. PApress, 2019.
- Carlos Coronel and Steven Morris. Database Systems: Design, Implementation, and Management, 13th Edition. Cengage Learning, 2018.
- 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.
- Thomas Connolly and Carolyn Begg. Database Systems- A Practical Approach to Design, Implementation, and Management, 6th Edition. Pearson, 2015.
- Abraham Silberschatz, Henry F. Korth, and S. Sudarshan. Database System Concepts, 6th Edition. McGraw-Hill, 2011.
- Garcia-Molina, J. D. Ullman, and J. Widom. Database Systems: The Complete Book, 2nd Edition. Prentice Hall, 2008.
- Jeffrey D. Ullman and Jennifer Widom. A First Course in Database Systems, 3rd Edition. Prentice Hall, 2007.
SQL Language References
- Alan Beaulieu. Learning SQL: Generate, Manipulate, and Retrieve Data, 3rd Edition. O'Reilly Media, 2020.
- Mike McGrath. SQL in Easy Steps, 4th Edition. In Easy Steps Ltd. 2020.
- Anthony Molinaro and Robert de Graaf. SQL Cookbook: Query Solutions and Techniques for All SQL Users, 2nd Edition. O'Reilly Media, 2020.
- Kevin Kline, Daniel Kline and Brand Hunt. SQL in a Nutshell: A Desktop Quick Reference, 4th Edition. O'Reilly Media, Inc. 2020.
- Ben Forta.SQL in 10 Minutes a Day, Sams Teach Yourself, 5th Edition. Sams Publishing, 2019.
- Upom Malik, Matt Goldwasser, Benjamin Johnston. SQL for Data Analytics: Perform fast and efficient data analysis with the power of SQL. Packt Publishing, 2019.
- Andrew Johansen. SQL: The Ultimate Beginner's Guide!. CreateSpace Independent Publishing Platform, 2015.
- John Viescas and Michael J. Hernandez. SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (3rd Edition). Addison-Wesley Professional, 2014.
- Joe Celko. Joe Celko's SQL for Smarties, 5th Edition: Advanced SQL Programming. Morgan Kaufmann, 2014.
- Stephane Faroult. SQL Success – Database Programming Proficiency. RoughSea Ltd, 2013.
- Steven Holzner. The Complete Idiot’s Guide to SQL: CIG to SQL. ALPHA, 2011.
- Ben Forta. Sams Teach Yourself SQL in 10 Minutes, 4th Edition. Sam Publishing, 2012.
- Mike McGrath. SQL in Easy Steps, 3rd Edition. In Easy Steps Ltd. 2012.
- Alan Beaulieu. Learning SQL, 2nd Edition. O'Reilly Media, Inc., 2009.
- James R. Groff, Paul N. Weinberg, Paul Weinberg, James Groff. SQL: The Complete Reference, 3rd Edition.. McGraw-Hill, 2009.
- Kevin Kline, Daniel Kline and Brand Hunt. SQL In A Nutshell, 3rd Edition. O'Reilly Media, Inc., 2008.
- Alex Kriegel and Boris M. Trukhnov. SQL Bible, 2nd Edition. Wiley, 2008.
PHP and MySQL References
- Jon Ducket. PHP & MySQL: Server-side Web Development. Wiley, 2022.
- Robin Nixon. Learning PHP, MySQL & JavaScript, 6th Edition. O'Reilly Media, Inc., 2021.
- W. J. Gilmore. Beginning PHP and MySQL: From Novice to Professional, 5th Edition, Apress, 2018.
- Andrew Comeau and Stephen Burge. MySQL Explained: Your Step By Step Guide, 2nd Edition, CreateSpace Independent Publishing Platform, 2017.
- Luke Welling, Laura Thomson. PHP and MySQL Web Development, 5th Edition, Addison-Wesley Professional, 2016.
- Paul DuBois. MySQL, 5th Edition (Developer's Library). Addison-Wesley Professional, 2013.
- Alan Forbes. The Joy of PHP: A Beginner's Guide to Programming Interactive Web Applications with PHP and mySQL, 2nd Edition, Plum Island Publishing LLC, 2013.
- Larry Ullman. PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, 4th Edition, Peachpit Press, 2011.
Python Programming References
- Luciano Ramalho. Fluent Python: Clear, Concise, and Effective Programming, 2nd Edition. O'Reilly Media, 2022.
- Eric Matthes. Python Crash Course, 2nd Edition: A Hands-On, Project-Based Introduction to Programming, No Starch Press, 2019.
- Steve Holden, Anna Ravenscroft and Alex Martelli. Python in a Nutshell, 3rd Edition, O'Reilly Media, Inc. 2017.
- Wes McKinney. Python for Data Analysis: Data Wrangling with Pandas, NumPy, and Ipython,?2nd Edition, O'Reilly Media, 2017.
- Mark Lutz. Learning Python, 5th Edition, O’Reilly Media, 2013.
- David Beazley and Brian K. Jones. Python Cookbook, 3rd edition, O'Reilly Media, 2013.
On-line References
- Wikibooks. Structured Query Language (https://en.wikibooks.org/wiki/Structured_Query_Language) (SQL:2011)
- Wikibooks. MySQL (https://en.wikibooks.org/wiki/MySQL)
- Wikibooks. PostgreSQL (https://en.wikibooks.org/wiki/PostgreSQL)