CS 311 - Database Systems - Resources

Other Resources

Software Tools

• MySQLWorkbench - an open source database tool designed to work with MySQL
• Sequel Pro - Mac-only SQL database browser
• Relational Algebra Interpreter
• SQFiddle
• SQLPro iOS application that serves as an SQL reference document.
• XAMPP - Tool to install Apache, PHP, MySQL, and Perl as one package. Versions are available for all major platforms.

LaTeX

• LaTeX Beginner's Guide - Electronic resource from the Oberlin Library
• LaTeX Download - Software for different platforms
• LyX - LaTeX GUI editor
• Texmaker - Another LaTeX GUI editor

Books

• Learning PHP and MySQL Available as an electronic resource from the Oberlin Library. Very good introduction to creating websites with PHP and a MySQL backend.

Documentation

• MySQL 5.5 Documentation
• MySQL Connection API has general documentation for the connection APIs, and documentation on specific APIs
• PHP Function Documentation
• TutorialsPoint Python DB Tutorial
• W3 Schools HTML Tutorial
• W3 Schools Javascript Tutorial
• W3 Schools SQL Tutorial

Other Courses

• Stanford's Self-paced Databases MOOC