Structured Query Language

For every popular relational database system, the Structured Query Language (SQL) is used to insert, modify, and delete data, and is used for queries as well. The full SQL standard is more than 600 pages long, and no commercial relational database system fully conforms to the standard. This hour and the next cover the details of the language that are most commonly implemented in popular relational databases.

SQL is made up of three types of statements: statements that are used to manipulate data, statements for data definition, and statements for database administration. I’ll discuss some of the statements that are common to most relational databases.

Statements for Data Manipulation

Within the category of statements ...

Get Sams Teach Yourself CGI in 24 Hours, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.