Admin Info Svcs - Oracle/SQL Help

SQL: References and User Guides
SQL for Web Nerds http://philip.greenspun.com/sql/
SQL Basics http://databases.about.com/od/sql/
SQL Fundamentals http://databases.about.com/od/sql/a/sqlfundamentals.htm
SQL coding, tutorials, articles, etc. Helpful SQL links & pages on this Planet-Source-Code site: http://www.planet-source-code.com/vb/default.asp?lngWId=5
SQL Reference Page: (see "SQL syntax information") http://www.contrib.andrew.cmu.edu/~shadow/sql.html
SQL Standards http://www.jcc.com/SQLPages/jccs_sql.htm
Code Central - Free SQL Code: http://abstractvb.com/code.asp?F=142
SQL: Forums, Links, Training,Tutorials, etc.
TOAD (Quest Software) - Tool for Oracle Application Development http://www.quest.com/toad/ FREE TRIAL (full version!) available--- DOWNLOAD TOAD now!
A Gentle Introduction to SQL http://sqlzoo.net/
SQL Tutorial to teach beginners the building blocks of SQL http://www.1keydata.com/sql/sql1.html
SQL Tutorial w/live practice database & interpreter http://www.sqlcourse.com/
SQL Frequently Asked Questions: This FAQ page covers the basics of SQL, including a few How-To's. http://epoch.cs.berkeley.edu:8000/sequoia/dba/montage/FAQ/SQL_TOC.html
Hundreds of SQL Technical Resources, Websites & Links http://searchDatabase.techtarget.com/bestWebLinks/0,,sid13_tax281606,00.html
ASK A PRO (online!) http://www.1sqlstreet.com/
ASK The EXPERT: SQL - Rudy Limeback...Pose your SQL questions here! http://searchdatabase.techtarget.com/ateAnswers/0,289620,sid13_cid376817_tax285649,00.html (Visit this Whatis.com site "GUIDE to the EXPERTS" for a comprehensive list of experts:) http://whatis.techtarget.com/content/0,290959,sid9_gci800556,00.html
Ask Tom forum: Find answers to your most difficult questions in this full-text searchable ORACLE forum http://asktom.oracle.com/
YAHOO! - About 256 SQL clubs listed here! http://dir.clubs.yahoo.com/Computers___Internet/Programming_Languages/SQL/
TRAINING - Oracle Classes/Tracks offered at USF Educational Outreach: Professional & Workforce Development Program. Oracle Application Developer Oracle Database Administrator Oracle Foundation Track
ORACLE-Related WEB SITES
The Oracle FAQ Website http://www.orafaq.com/
Hot Oracle! FAQs,Tips,Tutorials http://www.hot-oracle.com/
Oracle Cram Sessions (OCP): http://studyguides.cramsession.com/
ORACLE Unleashed! A Comprehensive Indexed Guide: (see Part II for SQL, SQL*Plus, SQL Loader, etc), database administration, tool options, etc. (1996 by Sams Publishing) http://docs.rinet.ru:8080/Krikun/
Oracle Error Messages: Search for Error Messages by number or text! http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/nav/error_search.htm
Oracle DBA/Developer Training - USF Educational Outreach's Pgm for Professional Development https://registration.outreach.usf.edu/....

SQL: References and User Guides

SQL for Web Nerds
http://philip.greenspun.com/sql/

SQL Basics
http://databases.about.com/od/sql/

SQL Fundamentals
http://databases.about.com/od/sql/a/sqlfundamentals.htm

SQL coding, tutorials, articles, etc.
Helpful SQL links & pages on this Planet-Source-Code site:
http://www.planet-source-code.com/vb/default.asp?lngWId=5

SQL Reference Page: (see "SQL syntax information")
http://www.contrib.andrew.cmu.edu/~shadow/sql.html

SQL Standards
http://www.jcc.com/SQLPages/jccs_sql.htm

Code Central - Free SQL Code:
http://abstractvb.com/code.asp?F=142

SQL: Forums, Links, Training,Tutorials, etc.

TOAD (Quest Software) - Tool for Oracle Application Development http://www.quest.com/toad/
FREE TRIAL (full version!) available--- DOWNLOAD TOAD now!

A Gentle Introduction to SQL
http://sqlzoo.net/

SQL Tutorial to teach beginners the building blocks of SQL
http://www.1keydata.com/sql/sql1.html

SQL Tutorial w/live practice database & interpreter
http://www.sqlcourse.com/

SQL Frequently Asked Questions: This FAQ page covers the basics of SQL, including a few How-To's.
http://epoch.cs.berkeley.edu:8000/sequoia/dba/montage/FAQ/SQL_TOC.html

Hundreds of SQL Technical Resources, Websites & Links
http://searchDatabase.techtarget.com/bestWebLinks/0,,sid13_tax281606,00.html

ASK A PRO (online!)
http://www.1sqlstreet.com/

ASK The EXPERT: SQL - Rudy Limeback...Pose your SQL questions here!
        http://searchdatabase.techtarget.com/ateAnswers/0,289620,sid13_cid376817_tax285649,00.html
           (Visit this Whatis.com site "GUIDE to the EXPERTS" for a comprehensive list of experts:)
           http://whatis.techtarget.com/content/0,290959,sid9_gci800556,00.html

Ask Tom forum: Find answers to your most difficult questions in this full-text searchable ORACLE forum
http://asktom.oracle.com/

YAHOO! - About 256 SQL clubs listed here!
http://dir.clubs.yahoo.com/Computers___Internet/Programming_Languages/SQL/

TRAINING - Oracle Classes/Tracks offered at USF Educational Outreach: Professional & Workforce Development Program.
           Oracle Application Developer
           Oracle Database Administrator
           Oracle Foundation Track

ORACLE-Related WEB SITES

The Oracle FAQ Website
http://www.orafaq.com/

Hot Oracle! FAQs,Tips,Tutorials
http://www.hot-oracle.com/

Oracle Cram Sessions (OCP):
http://studyguides.cramsession.com/

ORACLE Unleashed!
A Comprehensive Indexed Guide: (see Part II for SQL, SQL*Plus, SQL Loader, etc), database administration, tool options, etc. (1996 by Sams Publishing)
http://docs.rinet.ru:8080/Krikun/

Oracle Error Messages:
Search for Error Messages by number or text!
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/nav/error_search.htm

Oracle DBA/Developer Training - USF Educational Outreach's Pgm for Professional Development
https://registration.outreach.usf.edu/....

BOOKS / PUBLICATIONS:
A Great On-Line Source for Computer Books: www.computerbooksdirect.com
Oracle: A Beginner's Guide by Michael Corey, Michael Abby (Oracle Press)
Oracle8: The Complete Reference by Kevin Loney, George K Koch (Oracle Press)
Oracle Developer's Guide by David McClanahan (Oracle Press)
Oracle PL/SQL Programming by Steve Feuerstein, Bill Pribyl, Debby Russell (O'Reilly & Associates) See White Paper compliments of Quest Software
PL/SQL Best Practices by Steve Feuerstein (O'Reilly & Associates)
The Practical Sql Handbook : Using Structured Query Language by Judith S. Bowman, et al. (Oct 1996) - covers all the basics (but out of print)
The SQL Standard by C.I. Date, Hugh Darwin
Modern Database Management by Fred R. McFadden, Mary B. Prescott, Jeffrey Hoffer, 6th Ed. (Addison Wesley Longman, Inc.)
OCP Training Guide: Oracle DBA by William Baird (New Riders Publishing, Jan 1999) - with CD-Rom
Instant SQL Programming by Joe Celko (Wrox Press, 1999)
SQL Puzzles & Answers by Joe Celko
SQL for Smarties: Advanced SQL Programming by Joe Celko
SQL WEEKEND CRASH COURSE by Allen G. Taylor Pub. Price: $ 24.99 For first-time database programmers, this book grounds you in fundamental SQL programming concepts and techniques, with 30 half-hour lessons in the basics. Includes CD-ROM w/self-assessment software based on the book's lessons, as well as a complete sample database presented in various formats. 450pp. Pub: 1/02.
SQL FUNDAMENTALS, 2/E by John J. Patrick Pub.Price: $ 44.99 How to retrieve and manipulate data—with sample applications ranging from basic reports to sophisticated data warehouses. Highlights practical concepts and examples from the latest versions of both leading SQL implementations w/detailed solutions for using Access 2000 on the desktop and Oracle9 in enterprise environments. CD-ROM. 450pp. Pub: 5/02.

BOOKS / PUBLICATIONS:

A Great On-Line Source for Computer Books: www.computerbooksdirect.com

Oracle: A Beginner's Guide by Michael Corey, Michael Abby (Oracle Press)

Oracle8: The Complete Reference by Kevin Loney, George K Koch (Oracle Press)

Oracle Developer's Guide by David McClanahan (Oracle Press)

Oracle PL/SQL Programming by Steve Feuerstein, Bill Pribyl, Debby Russell (O'Reilly & Associates)
See White Paper

compliments of Quest Software

PL/SQL Best Practices by Steve Feuerstein (O'Reilly & Associates)

The Practical Sql Handbook : Using Structured Query Language by Judith S. Bowman, et al. (Oct 1996) - covers all the basics (but out of print)

The SQL Standard by C.I. Date, Hugh Darwin

Modern Database Management by Fred R. McFadden, Mary B. Prescott, Jeffrey Hoffer, 6th Ed. (Addison Wesley Longman, Inc.)

OCP Training Guide: Oracle DBA by William Baird (New Riders Publishing, Jan 1999) - with CD-Rom

Instant SQL Programming by Joe Celko (Wrox Press, 1999)

SQL Puzzles & Answers by Joe Celko

SQL for Smarties: Advanced SQL Programming by Joe Celko

SQL WEEKEND CRASH COURSE by Allen G. Taylor Pub. Price: $ 24.99

For first-time database programmers, this book grounds you in fundamental SQL programming concepts and techniques, with 30 half-hour lessons in the basics. Includes CD-ROM w/self-assessment software based on the book's lessons, as well as a complete sample database presented in various formats. 450pp. Pub: 1/02.

SQL FUNDAMENTALS, 2/E by John J. Patrick Pub.Price: $ 44.99

How to retrieve and manipulate data—with sample applications ranging from basic reports to sophisticated data warehouses. Highlights practical concepts and examples from the latest versions of both leading SQL implementations w/detailed solutions for using Access 2000 on the desktop and Oracle9 in enterprise environments. CD-ROM. 450pp. Pub: 5/02.

University of South Florida