Don't forget to check out our
newest
Free Oracle Training & Tutorials.
http://technet.oracle.com/doc/products.htm
Oracle Product Documentation Library, free registration required
http://technet.oracle.com/doc/mainplat.htm
Oracle Platform Documentation Library, free registration is required.
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/products.htm
Oracle Documentation Library, Release 8.1.7.
Free registration is required.
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/index.htm
Documentation Library for Oracle 8.1.7 Server and SQL*Plus
This page contains the links to the online Oracle documentation available in HTML format on
Technet. Documents include the Administrator's Guide, Concepts Guide, Migration, and Utilities guides. The entries listed with *s are unchanged from the 8.1.6 versions - see the documentation addendum for the modifications to those books.
Free registration is required.
Oracle
Certified Professional (OCP) Program from Oracle.com/education/certification
OCP Certification
Information from Oracle
Technology Network (otn.oracle.com/training/certification)
DBDomain.com
- Get OCP Certification
Information
Oracle Open World
Presentation and Paper Search, free registration required
http://www.hot-oracle.com/
Hot-Oracle.com:
http://www.hot-oracle.com/showtutorial.html?cat=Oracle&sub_cat=dba1 - Oracle DBA Lessons
http://www.hot-oracle.com/showtutorial.html?cat=Oracle&sub_cat=plsql
- PL/SQL Lessons
http://www.hot-oracle.com/showtutorial.html?cat=Oracle&sub_cat=sqlplus - SQL Plus Lessons
http://www.hot-oracle.com/tips.html
- Oracle Tips
http://www.hot-oracle.com/showtutorial.html?cat=Oracle&sub_cat=exp -
Export
http://www.hot-oracle.com/showtutorial.html?cat=Oracle&sub_cat=imp
- Import
http://www.hot-oracle.com/showtutorial.html?cat=Oracle&sub_cat=sqlloader
- SQL Loader
http://www.freetechnicaltraining.com
Excellent, Free streaming Oracle training tutorials, need a login ID which
is free to obtain. You will need to have
Real Player installed to hear the audio portion.
http://www.oracle.com/education/oln/
You can take a free trial Oracle training course by clicking on the link that says 'Register for a Free Trial' on this
page.
http://education.oracle.com/
Oracle University Video Network
You won't believe
the amount of free streaming training you will find here! That's assuming
you can find it. The Video Network link is rather small and difficult to
locate but it's there trust me. You will need to register to get access to
the training but it is free. Once you're in you will find hours and hours
of free streaming training. It is going to work a lot better for you if
you have a high bandwidth connection but low bandwidth streams are available.
Nov, 16 2000 -
The Video Network has gotten a little difficult to locate but it can still be
found. Go to the link above and register for free then log in. Then
using the same browser come back to this page and click this link, http://education.oracle.com/studentunion/oevn.html.
http://education.oracle.com/index.html
Oracle University - Oracle Learning Network (OLN) - Learn Oracle Technology
Online. The OLN - Professional Subscription is a 100% online education
offering designed to help you, the Oracle IT professional, stay abreast of the
latest from Oracle.
http://www.animatedlearning.com/
Free introductory, online Oracle training courses. Try using username: 81902
and password: vKmWzg
http://www.oracle.com/ebusinessnetwork/elearning.html
Free Online Courses
http://www.dbdomain.com/
DBDomain.com - Unlimited OCP Training: $250 for 6 months, $550 for one year. CD
package is $2000.
Here is information about Oracle
User Groups from dbdomain.com.
http://openworld.oracle.com/oowdba-wwwprd-apps/plsql/oow_user.show_public?p_type=search
Oracle Open World presentation and paper search access screen Use this page to search for presentations and papers delivered at Oracle Open World 2000. Free registration required. Put this link into the Oracle CD.
http://education.oracle.com/certification/index.html
The Oracle Certified Professional Program home page
http://education.oracle.com/certification/
The OCP home page, including information about certifications and exams, plus access to self-assessment tests and study guides. Make this site your first stop for OCP information.
http://technet.oracle.com/training/index.htm
Oracle Technology Network Training Site (costs a lot of money)
Oracle
Discoverer Handbook, by Michael Armstrong-Smith, Darlene Armstrong-Smith, 3
free chapters
IBM WebSphere
and VisualAge for Java Database Integration with DB2, Oracle, and SQL Server,
by Ueli Wahli, IBM Redbook
(pdf)
Experiences
with Migrating Oracle to OS/390, by Kathryn Arrell, IBM Redbook
(pdf)
Special
Edition Using Oracle8 / 8i, by William Page, et al - To view this
book, please register, for free, with InformIT
Free Books at
InformIT.com - First register for free, then click on their 'Free Library' Link and look for
Oracle books that are freely available to read. Search for 'Oracle' on their
search form.
http://www.geocities.com/siliconvalley/vista/4520/oracle_tips.htm
Oracle Tips - SQL
http://www.dcs.napier.ac.uk/~andrew/sql/
A Gentle Introduction to SQL
http://sqlcourse.com/
SQL Tutorial and
Interpreter
http://www.ecst.csuchico.edu/~melody/installation.htm
Learn How To Install Oracle
http://www.orapub.com//cgi//genesis.cgi?p1=sub&p2=papers_main
OraPub's White Papers - free registration required
http://www.rocket99.com/oracle/
Oracle 101
http://technet.oracle.com/tech/linux/
Oracle on Linux
http://jordan.fortwayne.com/oracle/
Oracle on Linux
http://www.nyoug.org/download.htm
Download Selected Software: Award Winning DBA Scripts
http://www.dbatoolz.com/scripts_fr.htm
SQL Script Archive DBAToolz
http://www.hotsos.com/
Hotsos White Papers, free registration required
http://sameer-uae.8m.com/
Oracle Library (copied from other sites)
Good results with this search
http://oug-ottawa.org:8080/OOUG/OOUG.home
OUG, presentations and tips
http://www.kevinloney.com/freebies.htm
Free Articles, Presentations, and Answers
http://www.michaelabbey.com/
Michael Abbey's Oracle Presentations
http://ourworld.compuserve.com/homepages/Peter_Koletzke
Peter Koletzke's Oracle Stuff
http://www.tusc.com/oracle/download/full.html
TUSC Full Listing of Downloads - Presentations
http://www.idevelopment.info
Jeff Hunter Oracle Resources
http://www.jlcomp.demon.co.uk/
JL Computer Consultancy - An expert view on the Oracle database engine.
http://www.wintercorp.com/whitepapers/
Oracle White Papers from Wintercorp.com
http://www.uaex.edu/srea/default.htm
Stephen_Rea_Oracle_Tips_and_Scripts
http://www.oracleguru.com/
OracleGuru.com
http://www.akadia.com
Akadia.com
http://home.earthlink.net/~bmehta/Oracle1.html
Atul Mehta's Oracle World - good link site
http://www.ozemail.com.au/~gpiper/
Oracle Tips
http://www.atr.net/faq/software/FRONT_END/faqlink.htm
Oracle WWW Links - Oracle Sites to Visit
http://oracle.ittoolbox.com/
Oracle IT Toolbox
http://www.oracle-home.com/
http://downloads.oracle-home.com/
http://links.oracle-home.com/
Oracle-Home.Com - Oracle Database Books, Resources, Reviews, and Links
http://www.oraclezone.com/
Oraclezone.com
http://www.dbazine.com/ch_oracle.html
DBAzine.com
http://www.certguide.com/oracle.htm
Oracle Links
http://www.cs.uwindsor.ca/meta-index/courses/95F/60-315/temp/oracleguide.html
Online Oracle Guide - SQL Plus and SQL Forms
http://nova.bsuvc.bsu.edu/ucspub/ho/vax/sqlforms.html
SQL*Forms in Oracle
http://www.uwp.edu/academic/mis/baldwin/oraddl.htm
Oracle Data Definition
http://www.atr.net/faq/software/FRONT_END/faqplus.htm
SQL-Plus FAQ
Oracle Forms 4.5 FAQ
SQL FAQ
DBA FAQ
SQL-Net FAQ
Oracle
FAQ
http://www.dbasupport.com/
DBASupport.com
http://www.dbasupport.com/oracle/scripts/
Oracle Scripts from DBASupport.com
http://forums.dbasupport.com/forums/
Oracle Support and Certification Forums from DBASupport.com
http://www.xephon.com/oracleupdate.html
Free Oracle Articles from Xephon.com
http://searchdatabase.techtarget.com/search/1,293876,sid13,00.html?h=true&query=Oracle+Tutorials+Tips
Best Database Web Links:
Oracle Tutorials & Tips
http://www.softcert.com/freedemo.html
SoftCert has created a demo of our Web Based Boot Camp for each of the available
exams. Simply fill out the information below for access to our demo.
http://eval.veritas.com/webfiles/docs/RAIDirectorWP.pdf
RAID Technology Explained in Detail
and description
http://burtleburtle.net/bob/other/sql.html
Oracle SQL Tricks
http://www.stewartmc.com/oracle/tips.html
Rhubarb's Oracle Tips
http://home1.gte.net/rkupcuna/html/oracle_scripts.htm
Ricks Oracle Scripts
Oracle /
Developer 2000 Tutorial- This screen cam based tutorial teaches you how to build applications using Oracle and Oracle
Developer 2000. (2.56 mb)
of tutorial. Password for this tutorial is "silicon".
SQL
PlusPlus is a PL/SQL code generator and SQL Plus enhancer. It adds more
then 120 productivity commands to the command line of SQL Plus. It also
generates high quality production-ready PL/SQL code for Designer/2000 like APIs
and PL/SQL Web Toolkit.
of this tool (952kb). Here is the manual
in pdf format. Password for SQL PlusPlus is "munshi".
http://www.deepakchebbi.com/menujs.html
Oracle and other Resources
http://www.teamdba.com/index2.htm
TeamDBA, free registration required
http://www.laoug.org/presentation.htm
LAOUG Speaker Presentations - The following files have been graciously provided by our speakers for use and reference by the LAOUG membership.
http://www.dbspecialists.com/4dbas/index.html
DBA Resources from DBSpecialists.com
http://www.angelfire.com/biz4/oraclealley/
Oracle Alley SQL Scripts site - The Oracle Alley is a collection of scripts primarily for DBAs (index rebuilds, datafile listings, extent maps) but also for developers (query tuning, string searches, and source code spooling.
http://www.arsdigita.com/asj/data-warehousing
Data Warehousing for Cavemen
http://web.archive.org/web/20011218000629/http://www.arsdigita.com/books/sql/
SQL for Web Nerds
http://www.geocities.com/bpolarsk/
Smenu toolset - A collection of hundreds Unix Shell Scripts, sorted by category and assembled in a related set of hierarchical menus. You may launch directly or in delayed mode, each script, without connecting to the DB, as Smenu does it for you. It acts as a repository of knowledge, developed by Oracle DBAs for themselves, and made public for the other
DBAs. Careful attention as been paid to the user interface as well to the classification of the different duties performed by
DBAs.
http://www.voug.org/
VOUG - Virginia Oracle Users Group
http://www.teseractinc.com/
Teseract Consulting
http://128.121.241.221/Pipelines/DBA/
Oracle DBA Pipeline - Tip of the Month Archives and Article Archives
http://www.geocities.com/SiliconValley/Peaks/4535/ora_htm/oracle_nf.htm
Bijus Oracle DBA Page - A collection of scripts written and tested by Biju for Database adminstration on Unix.
http://www.cs.concordia.ca/teaching/ugrad/comp353/oracle/browser.html
Oracle Browser Tutorial
http://d0db.fnal.gov/d0db/oracle8tutorial/
Oracle 8 Tutorial
http://spsa93.virtualave.net/mesa/orcl-tutorial/t1/oracle.html
A Simple Guide to Oracle SQLPlus
http://www.oracle.com/oramag/magazines.html
Oracle Publishing - Oracle Magazine
http://www.oracle.com/oramag/code/index.html
Oracle Magazine - Oracle Tips 2000, plus previous years
http://www.oracle.com/oramag/webcolumns/index.html
Oracle Publishing - Technical Articles Online
http://osi.oracle.com/wa/ask/owa/ask_tom_pkg.main
Oracle Magazine - Ask Tom - Oracle Q&As
http://www.evdbt.com/library.htm
Evergreen Database Technologies, Inc. Downloadable Library
http://www.cast.uark.edu/~scoving/
Using SQL in the Oracle Database Environment
http://www.bhtech.com/dload.htm
Blue Hills Technology Corporation - Oracle White Papers and Tools
http://bpaosf.bpa.arizona.edu/~fcurrim/mis331/project/oracle.html
Tutorial on Oracle
http://misdb.bpa.arizona.edu/~mis696g/Reports/Oracle8/oracle8.htm
Tutorial for Oracle 8
http://misdb.bpa.arizona.edu/~mis696g/Reports/OracleDW2/index.htm
Oracle Data Warehousing - CD
Powerpoint Link
http://misdb.bpa.arizona.edu/~mis696g/Reports/Projects/DBTuning/DatabaseTuning.html
Database Tuning Project
http://members.aol.com/_ht_a/tucano32/oracle/tutorial.htm
Introduction to Oracle PL/SQL Programming
http://kachina.kennesaw.edu/~jwarren/contents.html
Oracle SQL Tutorial
http://www.spnc.demon.co.uk/index/oracle.htm
SQL Reference and Tutorial
PL/SQL Reference
& Tutorial
Other SQL Stuff
http://cimic.rutgers.edu/~holowcza/oracle/
Oracle / Access / PowerPoint Tutorial and Help Pages (free registration
required)
http://www.db.cs.ucdavis.edu/teaching/sqltutorial/
Oracle/SQL Tutorial
Whitepapers:
- Database Applications based on XML
(pdf)
- Oracle8i for
DBAs,
Release 2 and 3 Improvements (doc)
- Oracle9i New Features Summary
(pdf)
------------------------------------------------------------
Free Oracle9i AS Training :
(Need Real Player )
http://streaming.oracle.com/ramgen/eclass/ias/092600_ias_r102_newfeat/start.smi
Oracle9 AS New Features Overview
http://streaming.oracle.com/ramgen/eclass/ias/11200_9ias_tech_overview/start.smi
Oracle9 AS Technical Overview
http://streaming.oracle.com/ramgen/eclass/ias/101200_portal_framework/start.smi
Oracle9 AS - Portal Framework Services
http://streaming.oracle.com/ramgen/eclass/ias/111300_o9ias_migration/start.smi
Migrating from OAS to Oracle9
http://streaming.oracle.com/ramgen/eclass/ias/ias_8icache_tech_7-25-00/start.smi
Oracle9 AS Cache Technical Overview
http://streaming.oracle.com/ramgen/eclass/ias/092800_ias_db_cache/start.smi
Oracle9 AS - Database Cache Update
http://streaming.oracle.com/ramgen/eclass/ias/103100_wireless_edtn/start.smi
Oracle9 AS Wireless Technical Overview
-------------------------------------------------------------
http://desktop.msfc.nasa.gov/oracle815doc/products.htm
Excellent Oracle 8i documentation available on this site:
- Oracle8i Server, Release 8.1.5
- Oracle8i Server Networking and Security, Release 8.1.5
- Oracle8i Java Products, Release 8.1.5
- Oracle8i interMedia, Spatial, Time Series, and Visual Information Retrieval Options, Release 8.1.5
http://oradoc.photo.net/ora81/DOC/
Oracle Documentation Library rel. 8.15
http://oradoc.photo.net/ora816/products.htm
Oracle Documentation available on this site:
- Oracle8i Generic Documentation Master Index, Release 8.1.6
- Oracle8i Server and Data Warehousing, Release 8.1.6
- Oracle8i Server Application Development, Release 8.1.6
- Oracle8i Server Networking and Security, Release 8.1.6
- Oracle8i Parallel Server, Release 8.1.6
- SQL*Plus, Release 8.1.6
- Oracle8i interMedia, Spatial, Time Series, and Visual Information Retrieval Options, Release 8.1.6
- Oracle8i Java Developer's Documentation, Release 8.1.6
- Oracle WebDB, Release 2.2
- On-Line Generic Documentation Installation and Usage Notes, Release 8.1.6
http://oradoc.photo.net/ora8doc/DOC/index.htm
Oracle8 Product Documentation Library
http://oradoc.photo.net/wf/doc/US/wf/wftop.htm
Oracle Workflow
http://www.contemporary-technologies.com/oracle-training/free-training-tutorial.htm
Oracle Training Guides - These Cram Guides are for studying for the OCP certification exam. They are in Microsoft Word format.
- Oracle 8i Performance and Tuning
- Oracle 8i Network Administration
- Oracle 8i Database Administration and Architecture
- Oracle 8i Backup and Recovery
http://www.freetechnicaltraining.com/oracle/free_ocp/index.htm
Dec 6, 2000, The FreeOCP Project is the first collaborative attempt to build a complete body of study materials for the Oracle OCP exams. FreeOCP is a collaborative project to compile a complete repository of free training content for the Oracle OCP examinations.
http://www.multimediastream.com/orac8inst.html
Video Installation of Oracle8i - needs Realplayer 7
http://www.orafans.com/
Orafans.com: The Oracle User Forum and Fan Club
http://www.oriolecorp.com/library1.html
Oracle Case Studies and Papers Library
http://www.oriolecorp.com/firststeps.html
First Steps in Oracle
http://www.vijaymukhi.com/oracled.doc
Undocumented Oracle - What They Didn't Teach You At Oracle
http://www.orafaq.org/faq2.htm
Underground Oracle FAQ
http://www.revealnet.com/downloads/downloads.htm
30 day Free Trial of Knowledge Base for Oracle Administration and Knowledge Base for Active PL/SQL
http://www.quest-pipelines.com
Grab your boards and surf the RevealNet Pipelines for dynamic interaction with Oracle authors and
professionals.
http://www.xephon.com/updates/Oracleu.html
http://www.xephon.com/updates/Oracle.pdf - Sample Issue
Oracle Update, Xephon's monthly journal for Oracle professionals
http://www.xephon.com/updates/oraclel.html
Oracle Links to Explore
http://www.pinnaclepublishing.com/OP/OPmain.nsf/links!openform
Oracle Professional Links
http://www.pinnaclepublishing.com/OP/OPmag.nsf/FreeTipsIndex!openform
Free Articles from Oracle Professional
http://nav.webring.yahoo.com/hub?ring=oracleweb&list
Oracle Web ring
http://www.webring.org/cgi-bin/webring?index;ring=oracleweb
Another Oracle Web Ring
http://www.computer-mentors.co.uk/oralinks.html
Oracle Links
http://education.oracle.com/membership/member.html
Join our online community, the Oracle University Student Union, and you'll have access to Online Forums, Mini-Lessons, the OU Video Network and our monthly newsletter.
http://www.oracleassist.com
Oracle Assist - Online service supporting Oracle customers and professionals through forums, jobs, links and news
http://www.tek-tips.com/gthreadminder.cfm/lev2/4/lev3/27/pid/186
Oracle 8 Technical Help Forum at Tek-Tips
http://www.tek-tips.com/gthreadminder.cfm/lev2/4/lev3/27/pid/185
Oracle 5/6/7 Technical Help Forum at Tek-Tips
http://www.tek-tips.com/gthreadminder.cfm/lev2/78/lev3/80/pid/391
Oracle ERP Solutions Techinical Help Forum at Tek-Tips - Oracle ERP Solutions technical support forums and mutual help
system for computer professionals.
http://www.oraclefans.com
Oracle Fan Club - Exchange ideas with other oracle users in the world.
http://www.allexperts.com/getExpert.asp?Category=1451
Ask any question! Allexperts.com is the oldest & largest free Q&A service on the Internet. Free answers to your questions - Category: Oracle. Put this link into the Oracle CD
http://www1.askme.com/showcategory.asp?cid=3037
Oracle Help from Experts at Askme.com. Put this link into the Oracle CD
http://www.experts-exchange.com/jsp/qList.jsp?ta=oracle
The #1 IT Professional Collaboration Network
http://www.universalthread.com/
Real-time technical support forum, includes threaded discussions, chat, daily news, FAQ archive, file downloads, articles, job postings, and website links.
---------------------------------------------------
From Narahari:
http://www.webtechniques.com/archives/1999/11/data/
http://www.sys-con.com/java/archives/0510/Mensah/
http://www.oracle.com/oramag/ (Oracle magazines)
http://www.sun.it/javaconf/ppt_javac/oracle/sld011.html
http://www.oracle.co.uk/info/news/javaclientdb.html
http://www.oracle.co.uk/info/news/jan99java.html
http://www.dbasupport.com/forums/forumdisplay.php?forumid=11
(Java/oracle complete example)
http://www.macromedia.com/support/generator/ts/documents/oracle_jdbc.htm
http://www.nasitinc.com/ec203.html
http://www.akadia.com/html/apache_jserv.html (explained in
graphically)
http://www.dbasupport.com/
http://www.archesis.it/white/orajdbw.htm
-----------------------------------------------------------
These 12 Excellent Oracle are available from Amazon.com:
Certification Success Exam Cram: MCSE, MCSD, CNE, CNA, A+, Cisco Oracle, Sun/Java,
by Ed Tittel -- Book and CD-ROM
High Performance Oracle8 Object-Oriented Design:
Your Complete Guide to Creating Fast, Efficient Database Systems
by David A. Anstey -- Book and CD-ROM
High Performance Oracle8 SQL Programming and Tuning:
The Oracle Professional's Guide to Tuning Oracle8 SQL Statements
by Pete Cassidy -- Book and CD-ROM
High Performance Oracle Database Applications,
by Donald Burleson -- Book and CD-ROM
High Performance Oracle Data Warehousing,
by Donald Burleson -- Book and CD-ROM
Learn Personal Oracle8.0 and Power Objects 2.0,
by Jose Ramalho -- Paperback
Oracle8 Server Unleashed,
by Joe Greene -- Book and CD-ROM
Oracle Database Construction Kit,
by John A. Palinski -- Book and CD-ROM
Oracle Data Warehousing Unleashed,
by Bonnie K. O'Neil (Editor), et al. -- Paperback
Oracle Programming with Visual Basic,
by Nick Snowdon -- Paperback
Special Edition Using Oracle Web Application Server 3,
by Rick Greenwald, et al. -- Book and CD-ROM
Working with Oracle Cartridges,
by Steve Shiflett, Joe Duer -- Paperback
To Page 1 of Oracle Training & Tutorials