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

Programming and General Resources:
xHTML, CSS and Unix || EXCEL AND VBA || Access || open office base || MySQL|| PHP & MySQL || Python & sqlite

Python and SQLite

• SQLite http://www.sqlite.org/
• Most widely deployed SQL database - http://www.sqlite.org/mostdeployed.html
• Using SQLite at the command line http://www.sqlite.org/sqlite.html (Important - Note the "dot commands" under Special commands part-way down the page to work with the configuration of your SQLite )
• SQL syntax for SQLite http://www.sqlite.org/lang.html
• SQL functions for SQLite- core functions, aggregate functions, and date & time functions; SQlite operators
• Python documentation for work with SQLite: http://docs.python.org/release/3.0.1/library/sqlite3.html
• Firefox Add-on - SQLite Database Manager - https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/

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

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)
• MySQL functions: http://dev.mysql.com/doc/refman/5.1/en/functions.html
  • Date formats - Note that MySQL stores dates and timestamps in one format only: YYYY-MM-DD hh:mm:ss; use the DATE_FORMAT() function within the query to modify the result: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format
• SQL tutorial

For your reference (not required for this class) - Additional installations (Please note however that all assignments must be submitted for use on i5.nyu.edu.)

• MAMP - Mac, Apache, MySQL, PHP - development environment - http://www.mamp.info/en/index.html
• XAMPP - Apache web server, MySQL, PHP, Perl, a FTP server and phpMyAdmin - http://sourceforge.net/projects/xampp/
• WAMP - Web development platform on Windows - http://www.wampserver.com/en/

Class discussion on database / query optimization

• see http://en.wikipedia.org/wiki/Query_optimization and http://www.sql-performance-tuning.com/oracle-sql-performance-tuning/

Additional sites of interest:

• a database of large datasets - www.factual.com
• a list of JOINs in Oracle - http://docs.oracle.com/cd/B28359_01/server.111/b28286/queries006.htm
• using subqueries (or "nested queries") in Oracle - http://docs.oracle.com/cd/B28359_01/server.111/b28286/queries007.htm#i2067858

Open Office / Base:

• Open Office Base Tutorial - http://www.tutorialsforopenoffice.org/category_index/base.html
• Open Office Resources -http://www.openoffice.org/dba/
• Open Office notes on SELECT queries - http://openoffice.blogs.com/openoffice/2010/06/combining-and-summing-fields-in-openofficeorg-database-queries.html

MS-Access:

• MS-Access Help Center
• Microsoft Access Help 2007 and Microsoft Access 2010 Help

Database Design

• MIT Open Courseware: Database, Internet, and Systems Integration Technologies http://ocw.mit.edu/courses/civil-and-environmental-engineering/1-264j-database-internet-and-systems-integration-technologies-fall-2006/
• MIT Open Courseware: Database Systems http://ocw.mit.edu/courses/electrical-engineering-and-computer-science/6-830-database-systems-fall-2010/

Excel and VBA:

VBA:

• Macros in Excel http://office.microsoft.com/en-us/excel-help/about-macros-in-excel-HP005201201.aspx
• Creating custom functions in Excel http://office.microsoft.com/en-us/excel-help/create-custom-functions-in-excel-2007-HA010218996.aspx
• Office 2011 and VBA http://www.macworld.com/article/154785/2010/10/welcomebackvisualbasic.html

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:

Note: There are many rich data sources available to you on-line through the Bobst Library; please do not hesitate to consult with any of the Special Librarians for assistance (http://library.nyu.edu/research/lib_arc.html)

• The U.S. Senate Website: an example of sorts & filters
• World Population Statistics data table for examples of ranking at http://www.census.gov/population/international/data/countryrank/rank.php
• 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.425003058010.13.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

JavaScript

• Learn jQuery in 30 Days - http://learnjquery.tutsplus.com/

• Notes on using Unix
• 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/