SQL Reference Page
The authors of this page have not examined many of the tools and resources listed here, and do not make any guarantees as to their usefulness. If you discover that a link is out of date, or would like to see something appear here that is missing
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
