Programming Data-Driven Web Applications with ASP.NET

Chapter 4. Basic ANSI-SQL

IN THIS CHAPTER

• Setting Up Your Workspace

• Getting Data from a Database

• The WHERE Clause

• The SubQuery

• SQL Joins

• Sorting Data

• Updating Existing Data

• Inserting New Data

• Deleting Existing Data

• Summary

This chapter will go over Structured Query Language, or SQL, which can be pronounced either “ess-cue-ell” or “sequel.” Some people insist that it must be called one or the other. I prefer “sequel” because it's one less syllable to say.

SQL was invented by IBM in 1970 and became an ANSI standard in 1986. It's an English-like, nonprocedural language that aids in the definition, manipulation, and administration of data in a relational database management system (RDMS). I'll be going over today's most commonly used statements and clauses ...