Go BackCGI/Perl: Interacting with Databases

Synopsis
CGI/Perl: Interacting with Databases helps students learn about using CGI and Perl to write data between Web pages and databases.

Audience
This course is for anyone who wants to create interactive Web pages using CGI and Perl.

Time
4 hours

Product Code: CGPC04
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


 

Go Back