Web Development:Database Driven Web Sites

Catalogue

IT & Certification

Web Design & Development

Axzo Press

303 pages

Purchase Price

1-9 manuals: $275 per manual
10+ manuals: $245 per manual

Trainer Material: Instructor's Edition $300 each

Code: CT23-300

Series: IT & Certification

Format: A4

Duration: 5 day(s)

Format:		Qty:

Download Data Files

Printer friendly version of this outline

Outline

Introduction to Web-Database Processing
Introduction to the World Wide Web
Introduction to databases
Introduction to dynamic Web pages

Introduction to Microsoft Access
Introduction to relational databases
Creating tables and inserting data

Introduction to Structured Query Language (SQL)
Creating database queries
Performing queries on multiple tables
Using SQL to work with data

Introduction to HTML
Using basic HTML tags
Using tables in Web pages
Using hyperlinks

Web servers
Introducing the Personal Web Server
Referencing files on a Web server
Comparing Personal Web Server with Internet Information Server

Using Visual Basic 6.0
to create Web-based database applications
Discussing the Visual Basic 6.0 interface
Creating a Visual Basic database application
Using Visual Basic with a database
Displaying a Visual Basic program

Client-side scripts
Relating HTML forms and scripting
Creating client-side scripts using VBScript
Using advanced VBScript
Displaying Web pages and sharing cookie values

Server-side scripts
Introduction to Active Server Pages
Creating a Web page application using client-side and server-side scripts

Compiled Web Server programs
Introduction to the Common Gateway Interface
Using ActiveX DLL's for Server-side Web Processing

After completing this course, students will know how to:

Work with databases and dynamic Web pages.
Work with relational databases, and create and modify data.
Create SQL queries to insert, update and delete data.
Use basic HTML commands to create tables and hyperlinks in web pages, and insert tables in Web pages.
Use the Personal Web Server and differentiate between the PWS and the IIS.
Create a Visual Basic application that interacts with a database and create an ActiveX package.
Create client-side scripts using VBScript.
Create Active Server Pages.
Write a CGI program and create ActiveX DLL's for server-side Web processing.

Prerequisites

Students taking this course should be familiar with the Windows operating
system and with using Internet Explorer to view Web pages. Students should also
have experience programming with Visual Basic.