RE: study/school plan to develop with Oracle (denver)

Also, take a look at O'Reilly's PL/SQL Programming, by Steven = Feuerstein.

For SQL tuning, try Prentice Hall, High Performance SQL Tuning by Guy Harrison.

ITO (introduction to Oracle) will comprehensively cover Oracle SQL for = you,
and PL/SQL Programming Units will teach you how to create procedures, functions, packages - but if you know another version of SQL already = and the
Oracle course price is too steep, you can probably learn on your own, = with
time.

HTH Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO


	-----Original Message-----
	From:	dgoulet_at_vicr.com [SMTP:dgoulet_at_vicr.com]
	Sent:	Monday, August 21, 2000 11:55 AM
	To:	Multiple recipients of list ORACLE-L
	Subject:	Re:study/school plan to develop with Oracle (denver)

	Peter,

	    My suggestion to you would be to take the Introduction to Oracle
course from
	Oracle.  It works wonders with the co-op's we get.

	____________________Reply Separator____________________
	Author: "Peter J. Schoenster" <webmaster_at_rede.com>
	Date:       8/19/00 5:54 PM

	Hi,

	I was recently presented with developing on a website with=20
	Oracle as rdbms. Previously I've always used mysql/postgresql.

	I got a guy to install/configure Oracle 8i and I can take a=20
	Perl/DBI/DBD script that works with mysql and just change the=20
	driver string and it works on Oracle.  The Oracle response even=20
	for the most basic table setup (no optimizing at all) has been=20
	quite impressive.

	I am seeking suggestions and sources of info on how to best=20
	create tables/indexes, when and if to use PL/SQL or just plain=20
	old SQL, how to use Oracle to help me improve performance for=20
	the SQL queries (inserts/updates only occur at off-peak times),=20
	when to use views, ... all sorts of things related to what I=20
	would call developing databases as opposed to maintaining them=20
	and Oracle which I would consider the work of a DBA.

	I live in Englewood, CO and there is an Amerinfo school nearby=20


	(Aurora) that has an introduction to Oracle for US$500 ... I=20

	wonder if that will just give me from the few Oracle books I=20
	currently own and am reading/perusing/studying:

	ORA - Oracle Design (Ensor & Stevenson, 1997)
	Oracle Press - Oracle 8i A Beginner's Guide
	Oracle Press - DBA Certification Exam Guide (Couchman, 1998)

	All suggestions readily appreciated: schools, courses, books,=20
	urls ..  I am member of technet and I joined the oracle online=20
	edu yesterday.

	Peter



	---------------------------
	"Reality is that which, when you stop believing in it, doesn't go
	away".
	                -- Philip K. Dick
	--=20
	Author: Peter J. Schoenster
	  INET: webmaster_at_rede.com

	Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
	San Diego, California        -- Public Internet access / Mailing
Lists
	--------------------------------------------------------------------
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
	the message BODY, include a line containing: UNSUB ORACLE-L


	(or the name of mailing list you want to be removed from).  You may

	also send the HELP command for other information (like subscribing).
	--=20
	Author:=20
	  INET: dgoulet_at_vicr.com

	Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
	San Diego, California        -- Public Internet access / Mailing
Lists
	--------------------------------------------------------------------
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
	the message BODY, include a line containing: UNSUB ORACLE-L


	(or the name of mailing list you want to be removed from).  You may