16 Corporate Woods Boulevard | Albany, New York 12211 | Tel: 518.437.1600

Active Server Pages

Available Dates: Request Dates
Class Length: 2 day
Cost: $1,275

Class Outline:

Performance-based objectives:

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

Describe what ASP is, what platforms and applications support it, and the role of scripting languages, objects, and components in ASP programming.
Use Server-side Includes to improve Web programming efficiency through modularization.
Describe the role of the ASP Response object and use its Write, Redirect, and output control properties and methods.
Describe the role of the ASP Request object and use its Form, QueryString, and ServerVariables collections to obtain user-supplied information and environment details.
Determine the value of cookies in maintaining user state and use the Cookie collections of the Request and Response objects.
Describe what ASP components are and use the Server object to instantiate
ASP components.
Use the Ad Rotator, Browser Capabilities, and Content Linking components.
Describe the difference between ASP applications and sessions and use the
Global.asa file to launch application and session events.
Describe what Scripting Objects are and use the Dictionary, FileSystemObject, and TextStream objects to further enable your ASP Web sites.
Describe the relationship between ASP and ADO and create a database connection from a Web site.
Use the Recordset object to display database records, create on-the-fly combo boxes and option groups, and filter records based on user input.
Add, update, and delete records in a database using both ADO and SQL query methods.
Use stored procedures and parameter queries to improve database access on the Web.
Create a data browser that allows forward and backward recordset browsing and a paged recordset display system.

Day 1

Course content

Lesson 1: Introduction to ASP

What is ASP?
ASP Scripting Languages, Objects, and Components

Lesson 2: Server-side Includes

Using Server-side Includes
Using Dynamic Server-side Includes

Lesson 3: The Response Object

What is the Response Object?
The Write Method
The Redirect Method
Controlling Output

Lesson 4: The Request Object

What is the Request Object?
The Form Collection
The QueryString Collection
The ServerVariables Collection

Lesson 5: Cookies

What are Cookies?
The Response.Cookies Collection
The Request.Cookies Collection

Lesson 6: ASP Components, Part 1

What are ASP Components?
The Server Object
The AdRotator Component

Lesson 7: ASP Components, Part 2

The Browser Capabilities Component
The Content Linking Component
Day 2

Course content

Lesson 8: Applications, Sessions, and the Global.asa

What are ASP Applications and Sessions?
What is the Global.asa?

Lesson 9: Scripting Objects

The Built-in Scripting Objects
The FileSystemObject Object
The TextStream Object

Lesson 10: ASP and the ADO Model

ASP, Databases, and ADO
The Database Environment
Connecting to the Database

Lesson 11: Viewing Database Records

Working with Recordsets
Creating Combo Boxes and Option Groups
Filtering Records

Lesson 12: Adding, Updating, and Deleting Records

Adding Records to a Database
Updating Records in a Database
Deleting Records from a Database

Lesson 13: Stored Procedures and Parameters

Using Stored Procedures
The Command Object
Parameter Queries

Lesson 14: Advanced Recordset Techniques

Editing Records with a Data Browser
Paging Through a Recordset