After completing CGI/Perl: Interacting with Databases, the user should be able to:
| Write a database validation script |
| Read and write to a database |
| Use the Structured Query Language (SQL) with relational databases |
|
Introduction to Databases
| Understanding databases |
| Interacting with databases from Web pages |
| Building database applications |
| Creating the HTML form |
Writing a Validation Script
| Creating a validation script to build a database application |
| Viewing the code |
Reading and Writing to the Database
| Creating a commit script to build a database application |
| Creating a script to read a database |
| Viewing the commit script code |
| Viewing code for istquests.cqi |
SQL: Introducing SELECT Statements
| Understanding relational databases |
| Using schema and keys |
| Using the SELECT statement in Structured Query Language (SQL) |
SQL: Learning More SQL Statements
| Using the LIKE comparison, joins, and DISTINCT |
| Sorting output using SELECT |
| Modifying Contents of Databases |
Accessing SQL Databases with Perl
| Using Open Database Connectivity |
| Understanding DBD/DBI |
|
This course is distributed with:
| Exercises, with sample files, that allow users to practice using CGI and Perl |
| A file containing the text of the exercises |
| A CGI/Perl glossary |
|