Steve Litt's SQL Troubleshooting Page
SQL is hard to troubleshoot because it's relatively monolithic, unlike modern modular OOP languages. Thus it's often hard to divide a SQL statement into sections. I don't claim to be an SQL guru, but here are some tips that have helped me in the past. Note that many SQL problems fall into one of these categories
JCC's SQL Standard Page
This page is designed to be a central source of information about the SQL standards process and its current state. It also contains pointers to other sources of information about the SQL standard. The information available here is:
Oracle/SQL Tutorial
This Oracle/SQL tutorial provides a detailed introduction to the SQL query language and the Oracle Relational Database Management System. Further information about Oracle and SQL can be found under www.db.cs.ucdavis.edu/dbs. References to other SQL Tutorials and Oracle related material can be found here
Oracle: SQL Plus Tutorial
Logging On/Off : In windows, find the Oracle group and click on SQL Plus. You will be prompted for your UserID, password, hoststring. Enter the information indicated in class. If successful, you will see the SQL> prompt. In windows, find the Oracle group and click on SQL Plus. You will be prompted for your UserID, password, hoststring. Enter the information indicated in class. If successful, you will see the SQL> prompt.
MySQL Tutorial
High Performance MySQL is a wonderful reference for database administrators migrating to the MySQL platform, particularly in enterprise deployments.
MySQL Documentations
The MySQL Reference Manual covers most of the areas of MySQL use. This manual is for both MySQL Community Edition and MySQL Network. If you cannot find the answer(s) from the manual, you can get support by purchasing MySQL Network, which provides comprehensive support and services. MySQL Network also provides a comprehensive knowledge base library that includes
MySQL Presentations
You may use the presentations on this page within your organization or for personal use, however if you wish to display them publically or incorporate them in whole or in part into your own presentations, please contact MySQL AB for permission by writing to
PostgreSQL Notes
These are the PostgreSQL Notes - pretty much everything you find here is in the HTML documentation, Bruce's book or on the mailing lists. You might find this an easy access-point to the above documentation though.
Practical PostgreSQL
This book is for anyone interested in utilizing the PostgreSQL object-relational database-management system (ORDBMS). The reader should be familiar with Linux- and UNIX-based systems, but is not expected to be a database guru. Although the test operating system for this book is Red Hat Linux, the tasks in this book that apply to Linux should apply to most UNIX variants without much modification.
