CS304: Resources and References

If you find some good online resource that you think should be added to this, please let me know!

Course Information¶

• About WMDB

Infrastructure Reference¶

How to get things done in this course.

• VSC: Visual Studio Code and Visual Studio Code and catchup.
• Scott's Emacs Intro (PDF)
• Scott's Unix Intro (PDF)

Web Development¶

My favorite site for all things related to web development (HTML, CSS, and JavaScript) is the Mozilla Developer site. Mozilla is the organization that implements Firefox, among other projects.

HTML and CSS¶

You'll need to know some HTML and CSS for this course. Here are some resources:

• I've learned a lot from W3 Schools over the years:
  • HTML tutorial
  • HTML tag reference
  • CSS tutorial
  • CSS reference
• The Mozilla Developer's Network (MDN) covers JavaScript better than anyone.
• The people at W3fools.com claim that W3Schools is out of date and should allow community comments and updates. They may have a point. They suggest the following resources:
  • WebPlatform.org
  • SitePoint is a pretty good reference for HTML, CSS and JavaScript.
• This site has a nice table of HTML elements with quick reminders: HTML Periodical Table.

SQL and MySQL¶

• MySQL site
• MySQL website's Tutorial
• W3School's SQL Tutorial
• MySQL Reference Manual (online)
• CREATE USER
• GRANT and REVOKE
• SET PASSWORD
• CREATE TABLE
• primary key optimization
• integer types
• using AUTO_INCREMENT
• date and time types
• SELECT
• date and time functions
• GROUP BY functions
• INSERT
• UPDATE
• DELETE
• JOINs
• CREATE VIEW
• START TRANSACTION, COMMIT, and ROLLBACK
• Pronouncing SQL

Python¶

• Python Tutorials — there are lots of tutorials at that site, so choose the one that is right for you.
• Python Database API Specification v2.0
• Writing MySQL Scripts with Python DB-API. This is a very nice tutorial.