Topic-Level Outline
Days: 5
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.
Unit 1: Web Database Processing
Topic A:0 Understanding the basics of the Web
A-1: Understanding Web Basics
A-2: Understanding communication protocols and Web addresses
A-3: Understanding listener processes
Topic B:0 Understanding the basics of databases
B-1: Understanding databases
B-2: Understanding client/server databases
Topic C:0 Understanding Web pages
C-1: Creating dynamic Web pages using client-side processing
C-2: Creating dynamic Web pages using server-side processing
Unit 2: Relational database concepts and introduction to Microsoft Access
Topic A:0 Introduction to relational databases
A-1: Understanding relational databases
A-2: Understanding the Clearwater Traders Sales Order database
Topic B:0 Creating database tables and inserting data
B-1: Creating a database table
B-2: Importing tables into a database
B-3: Enforcing referential integrity
B-4: Inserting data
B-5: Updating and deleting data
Unit 3: Structured Query Language (SQL)
Topic A:0 Using SQL to create database queries
A-1: Writing a query to retrieve all data rows from a single table
A-2: Creating a query that retrieves specific records
A-3: Using AND or OR operators to retrieve specific records
A-4: Using IS NULL and IS NOT NULL operators
A-5: Sorting query results
A-6: Calculating the difference between integer values
A-7: Calculating the difference between two date values
A-8: Using the GROUP BY clause in a query
A-9: Using the COUNT function
Topic B:0 Using SQL to perform queries on multiple tables
B-1: Joining data in multiple related tables
B-2: Using the UNION query
Topic C:0 Using SQL to insert, update or delete data
C-1: Inserting records into a table
C-2: Entering specific values into a table
C-3: Updating a record in a table
C-4: Updating multiple records in a table
C-5: Updating all the records in a table
C-6: Deleting a record from a table
C-7: Deleting records from related tables
Unit 4: Introduction to HTML
Topic A:0 Using basic HTML tags to create Web pages
A-1: Creating a Web page
A-2: Formatting text
A-3: Adding graphics and rules to a Web page
Topic B:0 Tables in Web pages
B-1: Creating a table
B-2: Changing the table size and alignment
B-3: Working with columns
B-4: Applying table borders and cell spacing
B-5: Aligning table objects
Topic C:0 Using Hyperlinks
C-1: Creating hyperlinks to a point within a Web page
C-2: Creating a hyperlink to another Web page
C-3: Creating a hyperlink to an e-mail address
Unit 5: Web Servers
Topic A:0 Introducing the Personal Web Server
A-1: Using the Personal Web Server
A-2: Observing the root document directory and the default document
A-3: Browsing directories
A-4: Creating and managing virtual directories
A-5: Examining the Web site activity log
A-6: Monitoring Web site performance
Topic B:0 Referencing files on a Web server
B-1: Using absolute URL addresses
B-2: Using relative URL addresses
Topic C:0 Comparing Personal Web Server with Internet Information Server
C-1: Comparing Personal Web Server and Internet Information Server
Unit 6: Using Visual Basic 6.0 to create Web-based database applications
Topic A:0 Discussing the Visual Basic 6.0 interface
Topic B:0 Using Visual Basic to create an application
B-1: Examining a Visual Basic project
Topic C:0 Using Visual Basic to create a database application
C-1: Creating a Visual Basic database application
C-2: Creating the ADO data connection object
C-3: Processing SQL queries
C-4: Using code to modify form control properties
C-5: Creating code to insert, update and delete records
C-6: Using a DataGrid control
Topic D:0 Using the Packaging and Deployment Wizard
D-1: Creating an ActiveX document
D-2: Creating an installation package for your ActiveX document
D-3: Displaying an ActiveX document using a hyperlink
Unit 7: Client-side scripts
Topic A:0 Relating HTML forms and scripting
A-1: Creating a Web form
A-2: Using a scripting language
Topic B:0 Creating client-side scripts using VBScript
B-1: Referencing form fields and button click events
B-2: Discussing VBScript variables and their scope
B-3: Understanding Functions
Topic C:0 Using advanced VBScript
C-1: Validating HTML form inputs
C-2: Debugging client-side scripts
C-3: Creating temporary cookies
C-4: Creating persistent cookies
Topic D:0 Displaying Web pages and sharing cookie values
D-1: Displaying a Web page in a new browser window
D-2: Displaying a new Web page in the same browser window
D-3: Retrieving the values of individual cookie variables
Unit 8: Server-side scripts
Topic A:0 Introduction to Active Server Pages
A-1: Creating a directory on the Web server for ASP files
A-2: Writing an ASP script
A-3: Creating a hyperlink with a dynamic URL
A-4: Retrieving input parameters into an ASP
A-5: Debugging ASP scripts
Topic B:0 Creating a Web page application
B-1: Sharing data values between multiple ASPs
B-2: Verifying and summarizing data
B-3: Creating and retrieving cookies using client-side scripts
B-4: Using client-side scripts to navigate to ASPs
B-5: Inserting data into a database
B-6: Processing and updating databases
B-7: Creating cookies
B-8: Suppressing form parameter values in URLs
Unit 9: Compiled Web Server programs
Topic A:0 Introduction to the Common Gateway Interface
A-1: Writing a CGI Program using Visual Basic 6.0
A-2: Displaying a Web page
A-3: Retrieving records from a database
A-4: Debugging a program using Visual Basic
A-5: Retrieving input variables
A-6: Sharing data values with other CGI programs
A-7: Advantages and disadvantages of a CGI program
Topic B:0 Using ActiveX DLL’s for server-side Web processing
B-1: Comparing CGI Programs with ActiveX DLLs
B-2: Creating an ActiveX DLL using Visual Basic
B-3: Retrieving database data in an ActiveX DLL
B-4: Passing form input parameters to an ActiveX DLL