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

Programming and General Resources:
xHTML, CSS and Unix || Excel || MS-Access || MySQL || PHP

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/

PHP and MySQL Together:

• MySQL functions in PHP (reference) http://php.net/manual/en/ref.mysql.php
• Tutorial on PHP and MySQL :http://www.w3schools.com/PHP/php_mysql_intro.asp
• MySQL and Facebook: http://www.readwriteweb.com/hack/2010/11/facebook-mysql-scale.php
• PHP and MySQL - http://devzone.zend.com/node/view/id/641

MySQL:

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

MS-Access:

• MS-Access Help Center
• Microsoft Access Help 2007

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
• Historical finance data on Yahoo http://finance.yahoo.com/q/hp?s=SPY+Historical+Prices

Additional Data Sources:

• 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
• Weather Statistics - http://www.giss.nasa.gov/ ... (New York City / Central Park Temperature Readings ... Surface Temperatures at http://data.giss.nasa.gov/work/gistemp/STATIONS//tmp.425725030010.2.1/station.txt)

CSS and xHTML / HTML

On-line resources and Tutorials:

• CSS Tutorial ... List of CSS Properties and Values
• HTML tutorial
• xHTML Tutorial
• Adobe's Dreamweaver CSS Tutorial
• W3C CSS 2.1 Specification and Properties
• CSS Examples from Zen Garden
• CSS Colors supported by major browsers and border styles

Text Editors and Debugging Tools:

• BBEdit -http://www.barebones.com/products/bbedit/ (approximately $50 at the academic price)
• Text Wrangler - http://www.barebones.com/products/textwrangler/
• Notepad ++ for Windows - http://sourceforge.net/projects/notepad-plus/
• Firebug (to use with Firefox) - http://getfirebug.com/
• CSS Validator
• xHTML Validator

• i5.nyu.edu home page
• Unix chmod command - explanation and notes; and reading a Unix file listing
• Unix systems Administration: http://www.washington.edu/R870/
• Unix Tutorial: http://www.ee.surrey.ac.uk/Teaching/Unix/