- Select a Page: Home Page Free Training & Courses Free Computer Books Free IT Training Tutorials Free Tutorials, Support & Help Learn IT & Development Free Computer Training Search Free Computer IT Training Blogs Free Office, Web Dev Training Blogs Free University Course Webs Best Free Online Courses Lower Fee Training Providers Higher Fee Learning Providers Link & Resource Sites Free Certification Study Guides Free IT Training Downloads Newsletter: New Free Training Sites Free Trade Publications IT Sites Worth Mentioning Free Site of the Month Best Course/Degree Locators Free Desktop & Office Tutorials Link To This Site --------------------------- Member Info & Sign Up Member Log In Search This Site Computer Open Directory IT Certification Counselor & List Financial Aid Resources Our IT Career Center Online IT Publications IT Assoc. & Orgs. Latest Tech News IT Stock Quotes & News Online Games Music and Movies Travel Reservations & Flights The Best of the Web Best Books at Amazon Support Our Training Mission --------------------------- Discussion Forum Chat Room Free Links Page Free Classified Ads Send a Greeting Card Cartoons and Jokes Free Email at ZapZone Take Our Survey Top 50 Computer Ed. Sites Rate this Site

"Learn New Skills & Increase Your Earning Power — With FREE Computer Training!" Subscribe to our Free Ezine to Get the Latest & Best FREE Computer IT Training!

Up 1 Level

 

Free Oracle Training and Tutorials

 

Search over 150,000 Free Computer Training and Tutorials at Edcomp.com:

Best New Free Computer IT Training and Tutorial Resources blog

Free Computer and IT Books blog

Free Web Development Training and Tutorials blog

Free Training blog for Photoshop, Flash, Dreamweaver, FrontPage, and Adobe Macromedia Apps

Free Microsoft Office Training and Tutorials blog

 

 

 

Find a Ton More Free Training & Tutorial Resources for Oracle on our Free Oracle Training Page

Tutorials and Code Samples
Each month, you'll find new samples and tutorials on OTN to help you get started with the latest in Oracle, Java, and other cutting-edge technologies. Here are some recent highlights (register here for free):

• The Card Payment Gateway Application shows you how to use Oracle9i XML DB's structured XMLType and other features by simulating a credit-card processing application that manages customer, card, and transaction details.
• The new ODP.Net Samples demonstrate advanced features, including distributed transactions, savepoints, globalization, safe type-mapping, and transparent application failover.
• The XML Dynamic News sample is a complete J2EE 1.3-based application that uses a news portal site to demonstrates the power of Java and Oracle XML DB.
• Calling external Web service from a Java Stored Procedure sample illustrates calling a Web Service from within an Oracle9i Database using a basic purchasing module implementation.
• Turning external Web Services into SQL data source using table functions is a sample application that implements a weather-reporting system that provides a report on temperature of some US cities. This sample demonstrates using pipelined table functions.
• The XML powered OTN Survey application, based on Oracle9i XML DB, shows how to create dynamic surveys, capture responses, and analyse the results.
• The J2EE Integration (JInt) sample demonstrates the High Availability architecture of Oracle9iAS, J2EE design patterns, and the new features of the EJB2.0 specification.
• The Metadata sample demonstrates the many capabilities of the Oracle9i XML Metadata API. The sample creates a sample schema, with tables, indexes, triggers, grants and views, and the Metadata API is used to extract the metadata (as XML, DDL, and HTML) from these objects.
• The TransX Utility sample demonstrates the use of the TransX utility Java API, which is supplied with the Oracle XDK for Java. This sample provides interface for unloading data from one database table into XML and load it into another table in the same or a different database, after applying translation attributes.
• The EJB 2.0 Sample for Oracle9i JDeveloper version 9.0.3 highlights new EJB 2.0 features in Oracle9i JDeveloper release 9.0.3, including Local interfaces, EJB-QL, CMR using EJB Modeler. and the EJB Module Editor. Instructions show how to build various clients (Command line, and JSP) to access the EJB through remote or local interfaces.
• The Financial Brokerage Service (FBS): EJB 2.0 and J2EE Tutorial Series demonstrates programming techniques that take advantage of key features defined in the J2EE and EJB 2.0 specification. The sample series also implements commonly accepted J2EE Design Patterns, and supports both browser and mobile clients.
• The Database Controlled Web Publishing Sample showcases a new, portable design pattern for publishing non-frequently changing database content while automatically reflecting changes to the data, regardless of the origin of changes. Integrates standard J2EE presentation logic in Oracle9iAS (JavaServer Pages, and upcoming Temporary Java Cache (JSR 107) with Java-based data logic in the Oracle9i Database in the form of Java Stored Procedures. This
• Web Cache Clustering Sample uses a personalized portal scenario to illustrate how to set up various Web Cache instances in a cluster, and then setup the application on a cluster, ensuring high availability and fast response time. The
• Integrated Security Sample demonstrates end-to-end security using Oracle9iAS Single sign-on (SSO) and LDAP provider with Web Services security.
• Oracle9i Application Server Technical Papers
  • Firewall and Load Balancer Architectures
  • Improved Availability with Hardware Clusters
  • Installation of Oracle9iAS Infrastructure
  • Oracle9iAS Integration Overview
  • Oracle9iAS Integration Workflow Overview
  • Oracle9iAS Integration Adapter Overview
  • Logging and Debugging with Oracle9iAS Containers for J2EE Technical Note
  • Oracle9iAS JAAS Provider Technical White Paper
  • Oracle9iAS Security
  • Oracle9iAS Security FAQ

http://download-west.oracle.com/otndoc/oracle9i/901_doc/
Free Oracle 9i Books, Manuals and Documentation

http://www.newagetraining.com/lessons/nat_lesson_sql_01.htm
Free Oracle Pl/SQL Introduction Course

http://www.oreilly.com/catalog/oracle2/chapter/ch10.html
Oracle Diagnostic and Tuning Tools

http://www.cba.nau.edu/morgan-j/class/classsch.htm
Excellent course training notes and lectures on Oracle, SQL, and databases

http://www.ixora.com.au/
Free scripts, tips and advanced performance tuning information (suggested)

Oracle Developer Lecture Slides:

Week2 Week 3  Week 3 Code Examples Week 4  Week 4 Code Examples

Week 5 Week 5 Code Examples

http://www.oreilly.com/catalog/oraclep2/chapter/ch03.html
Effective Coding Style (Oracle PL/SQL Programming)

http://www.oreilly.com/catalog/advoracle/chapter/ch02.html
Best Practices for Packages (Advanced Oracle PL/SQL Programming with Packages)

http://www.oreilly.com/catalog/oracledes/excerpt/ch01.html
Oracle Design - Introduction

http://www.oreilly.com/catalog/oracledes/excerpt/ch01.html
Oracle 8 Design Tips

http://www.oreilly.com/catalog/oraclebip/chapter/ch06.html
Generating Output from PL/SQL Programs

http://www.oreilly.com/catalog/oraclescrp/chapter/ch01.html
Oracle Scripts - Introduction

http://www.oreilly.com/catalog/orasec/chapter/ch07.html
Developing a Database Security Plan

http://www.interealm.com/technotes/index.html
This page is the branch-off point for reaching  favorite technical articles, tips, and technical notes written about the world's greatest RDBMS.

http://otn.oracle.com/library/content.html
Oracle Technology Network > Library (You may use user:htuttle password:mAb6RmR6 or register yourself)

http://technet.oracle.com/doc/server.804/a58225/toc.htm
Oracle8 SQL Reference Release 8.0 (You may use user:htuttle password:mAb6RmR6 or register yourself)

http://www.oracletuning.com/
Oracle Tuning - Many good tutorial articles covering more than just scripts.

http://www.devx.com/gethelp/gethelp.asp?Area=Oracle
Get Oracle Help - Ask your questions and get answers

http://oraclepower.com
Oracle Power: a portal of tutorials, applications, dba scripts, tools and articles for the novice and professional.

http://128.121.241.221/Pipelines/PLSQL/index.htm
PL/SQL Pipeline, a free community for Oracle developers worldwide. Use this forum to sharpen your development skills, share ideas with others, and stay on top of Oracle technology. Visit the "Archives" to download technical papers and free trial software.

http://www.meetit.com/skilltest/OracleTest.html
Free Oracle Skill Test

http://www.oreview.com/
Oracle View Archives

http://palslib.com/Oracle/Application_Development.html
Oracle Application Development Learning Resources Links
http://palslib.com/Oracle/Java.html
Oracle - Java Learning Resource Links
http://palslib.com/Oracle/Web.html
Oracle - Web Learning Resource Links

http://www.qarbon.com/viewletlibrary/teachlist.jsp?action=go_apps&app=Oracle:Designer&language=English
Oracle Designer Video Viewlet Tutorials

http://www.qarbon.com/viewletlibrary/teachlist.jsp?action=go_apps&app=Oracle8i&language=English
Oracle8i Video Viewlet Tutorials

http://www.qarbon.com/viewletlibrary/teachlist.jsp?action=go_apps&app=Oracle:Forms:6i&language=English
Oracle Forms 6i Video Viewlet Tutorials

http://www.orafaq.net/faqlink.htm
Great Oracle Sites to Visit

http://www.wtainc.com/whitepap
Oracle White Papers

http://.../www.books.mcgraw-hill.com/betabooks/july01/vandivier/ch01.htm
http://.../www.books.mcgraw-hill.com/betabooks/july01/vandivier/ch02.htm
Oracle9i Application Server Portal Handbook, 2 free chapters

http://.../www.books.mcgraw-hill.com/betabooks/july01/theriault/ch03.htm
Oracle Security Handbook, 1 free chapter

http://.../www.books.mcgraw-hill.com/betabooks/apr01/vaidyanatha/chap01.html
http://.../www.books.mcgraw-hill.com/betabooks/apr01/vaidyanatha/chap02.html
Oracle Performance Tuning 101, 2 free chapters

http://.../www.books.mcgraw-hill.com/betabooks/may01/vesterli/ch3.htm
Oracle Web Architecture, 1 free chapter

http://web.archive.org/web/20010802212353/www.books.mcgraw-hill.com/betabooks/may01/vesterli/ch12.htm
The Web Application Toolkit

http://www.cert21.com/default.php?action=guide
4 Free Oracle Certification Study Guides ( Register free here)

 

Overview of the ORACLE database management system (12 pages)	html
Using Oracle on isis	html
Practical introduction to SQLPlus (22 pages)	pdf  Word
Practical introduction to SQLForms version 3 on Unix (27 pages)	pdf  Word

Newsgroups and Mailing Lists:
comp.databases.oracle 
comp.databases.oracle.server 
comp.databases.oracle.tools 
comp.databases.oracle.misc 
comp.databases.oracle.marketplace 
Oracle Mailing Lists 

Oracle User Groups:
IOUG,- International Oracle Applications  
ODTUG, Oracle Development Tools  
COUG,  Chicago  
DOUG - Dallas  
HKOUG -  Hong Kong  
MAOUG -  Mid Atlantic
NCOUG -  North Carolina  
NWOUG -  NorthWest  
OUGF - Finland  
PPOUG - Pikes Peak  
RMOUG - Rocky Mountains
SCOUG - South Central
SEOUG - Southeast  
SFOUG - South Florida  
TOUG - Toronto