SQL

Since SQL is used by MySQL and other databases, you can find an endless supply of resources for this language. While generic SQL references will not necessarily show you how to get the most out of a MySQL database, they should remind you of the fundamentals. A few online SQL references include

• SQL Course, www.sqlcourse.com

• W3Schools.com, www.w3schools.com/sql/default.asp (Figure C.4)

  Figure C.4. The W3Schools site includes tutorials on lots of subjects, including SQL.

  [View full size image]
  

• A Gentle Introduction to SQL, www.sqlzoo.net (Figure C.5)

  Figure C.5. Andrew Cumming's A Gentle Introduction to SQL is a user-friendly discussion of the language.

  [View full size image]
  

• SQL Course 2, www.sqlcourse2.com

Many bookstores stock texts dedicated to the language. You may find, however, that an entire book on SQL is more knowledge than all but the advanced database developer requires. Further, you'll see that MySQL does not support a number of features that would be discussed in an all-purpose SQL text. And, MySQL has its own extensions that you may not find in a general SQL book.