Active Server Pages

Active Server Pages: Level 1

Course specifications

Course number: 077 100

Software version number: 2.0

Course length: 2 days

Course description

Overview: Students will learn the benefits of using ASP technology to create dynamic, data-driven Web sites. The course introduces the ASP Object Model, several built-in ASP Components, Scripting Objects, and the ActiveX Data Objects (ADO) Model.

Prerequisites: HTML Programming Levels 1 & 2, Programming Introduction, JavaScript (Level 1) or VBScript (Level 1), SQL Fundamentals of Querying; or equivalent knowledge.

Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Benefits: Students will learn how to create dynamic, database-driven Web sites. Hands-on tasks follow programming concepts, so that students can immediately implement what they learn.

Target student: Students needing to transform their static HTML-only Web site into a dynamic, data-driven Web site that accesses databases, uses COM components, dynamically serves information from a variety of sources, and much more.

What's next: Active Server Pages: Level 2, the second course in this series, uses the concepts and techniques students learned in Activer Server Pages: Level 1 to create a diverse set of Web applications. Along the way students will learn advanced concepts and techniques in Active Server Page programming.

Active Server Pages: Level 1

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

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