SitePoint
  • Premium
  • Library
  • Community
  • Jobs
  • Blog
LoginStart Free Trial

The home for developers

Track your course progress, manage projects, and find your dream job - all in one place.

Start Your Free Trial

7 Day Free Trial. Cancel Anytime.

SitePoint Premium

  • Access to 700+ courses
  • Publish articles on SitePoint
  • Daily curated jobs
  • Learning Paths
  • Discounts to dev tools
  • Library/
  • Text courses/
  • Simply SQL
Simply SQL

Simply SQL

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


Course details

4.5∙25 Ratings10 reviews

Published
December 2008
Publisher
SitePoint
Chapters
13

About the course

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.

The files are available here: Github

Author

Rudy Limeback

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.

Course Outline

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

Reviews
4.5

25 total

14
11
0
0
0

Course details

4.5∙25 Ratings10 reviews

Published
December 2008
Publisher
SitePoint
Chapters
13

SitePoint

Stuff we do

  • Premium
  • Newsletters
  • Learning paths
  • Library
  • Forums

Contact

  • Contact us
  • FAQ
  • Publish your book
  • Write an article
  • Advertise

About

  • Our Story
  • Corporate Memberships
  • Start free trial
  • Login

Connect

  • RSS
  • Facebook
  • Twitter (X)
  • Instagram

Subscribe to our newsletter

Get the freshest news and resources for developers, designers and digital creators in your inbox each week

© 2000 – 2025 SitePoint Pty. Ltd.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Terms of usePrivacy policy