Hour 19. How to Use the Structured Query Language
The Structured Query Language (SQL) is the lingua franca of the relational database world. Nearly all relational databases use SQL for data retrieval, data modification, and database administration. While the SQL dialect used by various databases differs, once you know the basics of SQL, you should be able to use most any relational database. In this lesson, I’m going to discuss the statements associated with SQL and demonstrate how they are used in CGI programs.
This lesson includes the following:
A brief overview of Structured Query Language (SQL)
What the Open Database Connectivity (ODBC) standard is
How to access relational databases from Perl programs using DBI and DBD
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.
