Home || Syllabus || Assignments || Readings || Resources

Programming and General Resources: General || HTML & CSS || Excel || MS-Access || MySQL || PhP, HTML/CSS and MySQL ||

PHP, HTML, xHTML, CSS, and Php/MySQL:

• Tutorial on HTML forms: http://www.w3schools.com/html/html_forms.asp
• Reference site on PHP
• Tutorials on PhP: http://www.thescripts.com/serversidescripting/php/

MySQL:

• The "official" MySQL site: http://www.mysql.com/ and its documentation: http://www.mysql.com/documentation/ ... Complete manual; Chapter 3- Tutorial; Chapter 10 - DataTypes; Chapter 11 - Functions & Operators and Chapter 12 - SQL Statement Syntax and for Version 5, see http://dev.mysql.com/doc/refman/5.1/en/index.html (Note: We are using Version 5.1.42 on i5.nyu.edu)
• SQL tutorial

MS-Access:

• MS-Access Help Center
• Microsoft Access Home page

Excel:

• The U.S. Senate Website: an example of sorts & filters
• World Population Statistics data table for examples of ranking

Financial data on the web for class and student exercises:

• New York Federal Reserve http://www.newyorkfed.org/research/banking_research/datasets.html
• St Louis Federal Reserve http://research.stlouisfed.org/fred2/
• University of Michigan - Government statistics: http://www.lib.umich.edu/govdocs/stats.html
• Bloomberg Market data: http://www.bloomberg.com/markets/stocks/movers_index_spx.html
• Bloomberg: Exchange data http://www.bloomberg.com/markets/stocks/movers_index_spx.html

Sample sources of data available in "flat file" database format available on the internet:

• Consumer Price Index: http://www.bls.gov/news.release/cpi.toc.htm
• US Agricultural Data: http://www.ers.usda.gov/Data/
• US Department of Agriculture Economic research Service: http://www.ers.usda.gov/data/FATUS/
• US National Center for health statistics
• Baseball statistics

CSS

• CSS Tutorial
• CSS Examples from Zen Garden

HTML tutorials and information

Here are a few tutorials for those who wish to review HTML. There are many tutorials and books available on HTML.

• HTML Tutorial
• http://www.htmlgoodies.com

General

• Class discussion on database careers