Simply SQL

 23 Reviews Add a review
Simply SQL

Published December 2008

The fun and easy way to learn best-practice SQL.

SQL is the language used by all major database systems today. SQL has been around for about 30 years, but is enjoying a real renaissance in the 21st century, thanks to the tremendous success of database-driven web sites. Whether your web site is written in PHP, ASP, Perl, ColdFusion, or any other programming language, and no matter which database system you want to use—MySQL, PostgreSQL, SQL Server, DB2, Oracle, or any of the others—one fact is almost certain: if you want to have database-driven content, you’ll need to use SQL. SQL is a simple, high-level language with tremendous power. You can perform tasks with a few lines of SQL that would take pages and pages of intricate coding to accomplish in a programming language.

Oh yeah, and the whole SitePoint library! Learn More.

What you'll learn

  • How to use SQL to store and retrieve database data
  • Using the SELECT statement and its clauses
  • How to design databases effectively, considering data types, table relationships, and primary and foreign keys
  • PDF, EPUB, MOBI 300 pg
Meet your author
Rudy Limeback

Rudy Limeback is an SQL Consultant living in Toronto, Canada. His SQL experience spans 20+ years, and includes working with DB2, SQL Server, Access, Oracle, and MySQL.


  1. An Introduction to SQL
  2. An Overview of the SELECT Statement
  3. The FROM Clause
  4. The WHERE Clause
  5. The GROUP BY Clause
  6. The HAVING Clause
  7. The SELECT Clause
  8. The ORDER BY Clause
  9. SQL Data Types
  10. Relational Integrity
  11. Special Structures

Leave a Review