Web Skills Work

{ beta }

CHAPTERS

• 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

An Introduction to SQL

Almost every website nowadays, it seems, uses a database. Your objective, as a web developer, is to be able to design or build websites that use a database. To do this, you must acquire an understanding of and the ability to use Structured Query Language (SQL), the language used to communicate with databases.

We'll start by introducing the SQL language and the major SQL statements that you'll encounter as a web developer.

Topics include the following:

• SQL Statement Overview
• Data Definition Language
• Data Manipulation Language
• Standard SQL
• Wrapping Up: an Introduction to SQL

 

RELATED FILES

Visit Website

Code Archive

Sample Applications & Examples

Publisher: SitePoint

Author: Rudy Limeback

Year: 2008