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

Textbooks(recommended but not required)

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. Abraham Silberschatz, Henry F. Korth, and S. Sudarshan. Database System Concepts, 6th Edition. McGraw-Hill, 2011.
  6. Garcia-Molina, J. D. Ullman, and J. Widom. Database Systems: The Complete Book, 2nd Edition. Prentice Hall, 2008.
  7. 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. Mike McGrath. SQL in Easy Steps, 4th Edition. In Easy Steps Ltd. 2020.
  3. Anthony Molinaro and Robert de Graaf. SQL Cookbook: Query Solutions and Techniques for All SQL Users, 2nd Edition. O'Reilly Media, 2020.
  4. Kevin Kline, Daniel Kline and Brand Hunt. SQL in a Nutshell: A Desktop Quick Reference, 4th Edition. O'Reilly Media, Inc. 2020.
  5. Ben Forta.SQL in 10 Minutes a Day, Sams Teach Yourself, 5th Edition. Sams Publishing, 2019.
  6. Upom Malik, Matt Goldwasser, Benjamin Johnston. SQL for Data Analytics: Perform fast and efficient data analysis with the power of SQL. Packt Publishing, 2019.
  7. Andrew Johansen. SQL: The Ultimate Beginner's Guide!. CreateSpace Independent Publishing Platform, 2015.
  8. 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.
  9. Joe Celko. Joe Celko's SQL for Smarties, 5th Edition: Advanced SQL Programming. Morgan Kaufmann, 2014.
  10. Stephane Faroult. SQL Success – Database Programming Proficiency. RoughSea Ltd, 2013.
  11. Steven Holzner. The Complete Idiot’s Guide to SQL: CIG to SQL. ALPHA, 2011.
  12. Ben Forta. Sams Teach Yourself SQL in 10 Minutes, 4th Edition. Sam Publishing, 2012.
  13. Mike McGrath. SQL in Easy Steps, 3rd Edition. In Easy Steps Ltd. 2012.
  14. Alan Beaulieu. Learning SQL, 2nd Edition. O'Reilly Media, Inc., 2009.
  15. James R. Groff, Paul N. Weinberg, Paul Weinberg, James Groff. SQL: The Complete Reference, 3rd Edition.. McGraw-Hill, 2009.
  16. Kevin Kline, Daniel Kline and Brand Hunt. SQL In A Nutshell, 3rd Edition. O'Reilly Media, Inc., 2008.
  17. Alex Kriegel and Boris M. Trukhnov. SQL Bible, 2nd Edition. Wiley, 2008.

PHP and MySQL References

  1. Jon Ducket. PHP & MySQL: Server-side Web Development. Wiley, 2022.
  2. Robin Nixon. Learning PHP, MySQL & JavaScript, 6th Edition. O'Reilly Media, Inc., 2021.
  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.
  7. 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.
  8. Larry Ullman. PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, 4th Edition, Peachpit Press, 2011.

Python Programming References

  1. Luciano Ramalho. Fluent Python: Clear, Concise, and Effective Programming, 2nd Edition. O'Reilly Media, 2022.
  2. Eric Matthes. Python Crash Course, 2nd Edition: A Hands-On, Project-Based Introduction to Programming, No Starch Press, 2019.
  3. Steve Holden, Anna Ravenscroft and Alex Martelli. Python in a Nutshell, 3rd Edition, O'Reilly Media, Inc. 2017.
  4. Wes McKinney. Python for Data Analysis: Data Wrangling with Pandas, NumPy, and Ipython,?2nd Edition, O'Reilly Media, 2017.
  5. Mark Lutz. Learning Python, 5th Edition, O’Reilly Media, 2013.
  6. David Beazley and Brian K. Jones. Python Cookbook, 3rd edition, O'Reilly Media, 2013.

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)