Textbook and References

Textbooks(recommended but not required)

Recommended Books

  1. Thomas Connolly and Carolyn Begg. Database Systems- A Practical Approach to Design, Implementation, and Management, 6th Edition. Pearson, 2015.
  2. Abraham Silberschatz, Henry F. Korth, and S. Sudarshan. Database System Concepts, 6th Edition. McGraw-Hill, 2011.
  3. Garcia-Molina, J. D. Ullman, and J. Widom. Database Systems: The Complete Book, 2nd Edition. Prentice Hall, 2008.
  4. Jeffrey D. Ullman and Jennifer Widom. A First Course in Database Systems, 3rd Edition. Prentice Hall, 2007.

SQL Language References

  1. Upom Malik,?Matt Goldwasser,?Benjamin Johnston. SQL for Data Analytics: Perform fast and efficient data analysis with the power of SQL. Packt Publishing, 2019.
  2. Andrew Johansen. SQL: The Ultimate Beginner's Guide!. CreateSpace Independent Publishing Platform, 2015.
  3. 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.
  4. Joe Celko. Joe Celko's SQL for Smarties, 5th Edition: Advanced SQL Programming. Morgan Kaufmann, 2014.
  5. Stephane Faroult. SQL Success ˇV Database Programming Proficiency. RoughSea Ltd, 2013.
  6. Steven Holzner. The Complete Idiotˇ¦s Guide to SQL: CIG to SQL. ALPHA, 2011.
  7. Ben Forta. Sams Teach Yourself SQL in 10 Minutes, 4th Edition. Sam Publishing, 2012.
  8. Mike McGrath. SQL in Easy Steps, 3rd Edition. In Easy Steps Ltd. 2012.
  9. Alan Beaulieu. Learning SQL, 2nd Edition. O'Reilly Media, Inc., 2009.
  10. James R. Groff, Paul N. Weinberg, Paul Weinberg, James Groff. SQL: The Complete Reference, 3rd Edition.. McGraw-Hill, 2009.
  11. Kevin Kline, Daniel Kline and Brand Hunt. SQL In A Nutshell, 3rd Edition. O'Reilly Media, Inc., 2008.
  12. Alex Kriegel and Boris M. Trukhnov. SQL Bible, 2nd Edition. Wiley, 2008.

PHP and MySQL References

  1. Robin Nixon. Learning PHP, MySQL & JavaScript, 5th Edition, O'Reilly Media, Inc., 2018.
  2. Luke Welling, Laura Thomson. PHP and MySQL Web Development, 5th Edition, Addison-Wesley Professional, 2016.
  3. W. J. Gilmore. Beginning PHP and MySQL: From Novice to Professional, 5th Edition, Apress, 2016.
  4. Mr Andrew Comeau and?Stephen Burge. MySQL Explained: Your Step By Step Guide, CreateSpace Independent Publishing Platform, 2015.
  5. Paul DuBois. MySQL, 5th Edition (Developer's Library). Addison-Wesley Professional, 2013.
  6. 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.
  7. Larry Ullman. PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide, 4th Edition, Peachpit Press, 2011.

Python Programming References

  1. Eric Matthes. Python Crash Course, 2nd Edition: A Hands-On, Project-Based Introduction to Programming, No Starch Press, 2019.
  2. Steve Holden, Anna Ravenscroft and Alex Martelli. Python in a Nutshell, 3rd Edition, O'Reilly Media, Inc. 2017.
  3. Wes McKinney. Python for Data Analysis: Data Wrangling with Pandas, NumPy, and Ipython,?2nd Edition, O'Reilly Media, 2017.
  4. Luciano Ramalho. Fluent Python. O'Reilly Media, 2015.
  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)

On-line SQL Resources

  1. Online SQL interpreter. (https://www.db-book.com/db7/university-lab-dir/sqljs.html) (for the DB Concepts book)
  2. SQLite online. (https://sqliteonline.com/)
  3. The Try-SQL Editor. (https://www.w3schools.com/sql/trysql.asp?filename=trysql_op_in)(w3schools)
  4. Execute SQL Online. (https://www.tutorialspoint.com/execute_sql_online.php)(tutorialspoint)