Helpful Links

Take a look at the demos:
http://itchy.dsp.columbia.edu/pls/demo2/demo.bookmark

TNS Entry to Add

Here's the TNS names entry for Itchy (this is our main server for this class):

itchy=
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)
                               (HOST = itchy.dsp.columbia.edu )
                               (PORT = 1521) )    )
    (CONNECT_DATA =  (SID = d703)    ) )

Web Based iSQL Plus

	iSQL*Plus on Itchy use the following URL http://itchy.dsp.columbia.edu/isqlplus
	iSQLPlus on FRINK, you can access ITCHY http://frink.ce.columbia.edu/isqlplus*
	iSQL*Plus on Wiggum you can access ITCHY http://wiggum.ce.columbia.edu:7778/isqlplus

Other Columbia Web Sites

	Courseworks will log grades and emails for this course http://courseworks.columbia.edu
	Main DADD Web Page http://homer.dsp.columbia.edu/ctaprogram/dadd/
	Columbia CTA main page: http://www.ce.columbia.edu/cta/
	CTA Williams St info: http://www.ce.columbia.edu/info/williamstreet.shtml
	Get your Columbia email over the internet: https://cubmail.cc.columbia.edu/
	Configure your Columbia Email to forward to other addresses: http://www.columbia.edu/acis/email/delivery/forward.html [click on the button "forward my mail on the web"]
	CTA Handbook http://www.ce.columbia.edu/cta/handbook/index.html
	CTA Table and Column Descriptions
	CTA Table Relationship Diagram (ERD)
	Columbia Grades and Account Status https://www.ais.columbia.edu/cgi-bin/ssv/ssol
	Telnet directly to Columbia Unix email - can setup account here http://www.columbia.edu/acis/email/launch/
	How to Use Email in the Labs (by Martin Fellner) http://www.columbia.edu/cu/ssp/CTA/DADD/TipsTechniques/email.htm
	How to create your own Web page at Columbia http://www.columbia.edu/cu/help/create.html
	How to password protect your Web Pages at Columbia http://www.columbia.edu/acis/webdev/password-noncolumbia-reg.html
	IT Alumni at Columbia University http://www.ce.columbia.edu/italumni/

External Links

	216 Web Safe Colors Webreference.com Webmonkey.com Webdeveloper.com
	Oracle Documentation http://docs.oracle.com
	Oracle TechNet http://technet.oracle.com All Oracle Manuals online! This site is run by Oracle Corporation. It requires registration to use but it is free and useful. All students are expected to utilize this resource.
	Computer Bookclub Inc. http://www.booksonline.com/lcis Includes the DBA Certification Exam Guide by Jason S. Couchman ISBN 0-07-882549-0 normally $99.99 (1st Exam is only SQL & PL/SQL) Click here to order from Amazon.com at a discount
	Oracle Education Site http://education.oracle.com
	Oracle Certified Professional http://education.oracle.com/certification/
	SQL on-line Tutorial http://w3.one.net/~jhoffman/sqltut.htm
	Oracle7 Server SQL http://sellene.zcu.cz/doc/oracle/server/sql73/toc.html Reference
	Oracle Corporation http://www.oracle.com
	Oracle FAQ Home Page http://www.physics.ohio-state.edu/~qliao/oracle
	Oracle Freeware Page (Peter Koletzke) http://ourworld.compuserve.com/homepages/Peter_Koletzke/oraclesh.htm
	Oracle Government Website http://govt.us.oracle.com/
	Peter Koletzke's Oracle Links Page http://ourworld.compuserve.com/homepages/Peter_Koletzke/
	RevealNet http://www.revealnet.com/
	Underground Oracle FAQs http://www.onwe.co.za/frank/faq2.htm
	Browser Archive http://browsers.evolt.org/

Free (or trial) Development Tools

Download Rapid SQL from Embarcadero and follow the directions at
http://www.columbia.edu/~vw89/rapidsql.html

Web Alchemy Tool (converts HTML into PL/SQL)
http://www.users.bigpond.com/ahobbs/

Download the free version of Toad:

http://www.toadsoft.com/downld.html

PL/SQL Developer - Evaluation

http://www.allroundautomations.nl/plsqldev.html

http://www.quest.com/solutions/download.asp

Oracle Related User Groups

	IOUG-A: International Oracle User's Group http://www.ioug.org/
	NYOUG: New York Oracle User's Group http://www.nyoug.org/
	ODTUG: Oracle Development Tools User Group http://www.odtug.com/

Oracle Related Publications

	Oracle Magazine http://www.oramag.com/
	Oreview Magazine (formerly Oracle Technology Journal) http://www.oreview.com/

Job Sites on the Net

	Job Guide: The Riley Guide Free Resume Databases lists: site name/focus/public or private/how long resume kept/resume file format/notes http://www.dbm.com/jobguide/resfree.html
	Sites that search other sites which you specify http://findjob.internet.com/ http://www.careerbuilder.com/
	General Job Sites http://www.dice.com/ http://www.vault.com http://www.computerjobs.com http://www.developers.net/ http://www.softwarejobs.com/ http://www.brassring.com/ http://www.prgjobs.com/ http://www.net-temps.com/ http://www.techies.com http://www.freeagent.com http://jobs.cnet.com/ http://www.directstaff.com/ http://newyork.computerwork.com/ http://www.peoplestaff.com/
	Oracle jobs only http://www.oracjobs.com/ http://www.orasearch.com/ http://www.OracleProfessional.com/ http://www.JustOracleJobs.com/ http://www.siliconalleyjobs.com/
	NY Times Guide to Job Hunting on the Internet http://www.nytimes.com/yr/mo/day/jobmarket/jobnav.html
	Review of on-line job sites http://www.zdnet.com/products/content/reviews/199807/jobs.sites/index.html
	News story on finding jobs on the Net http://chkpt.zdnet.com/chkpt/pcwt981015003/www.zdnet.com/pcweek/stories/news/0,4153,357991,00.html
	http://www.headhunters.net/
	http://www.hotjobs.com/
	http://www.monster.com/
	http://www.developers.net/
	http://www.careerpath.com/
	http://www.careermag.com/
	http://www.dev.careercentral.com/