Active Server Pages 2.0: Level 1

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: To ensure your success, we recommend you first take the following   Software Training courses:

            HTML Programming Level 1

            HTML Programming Level 2,

            Programming Introduction, JavaScript (Level 1) or

            VBScript (Level 1),

            SQL Fundamentals of Querying; or have extensive 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 2.0: Level 2, the second course in this series, uses the concepts and techniques students learned in this course, Active Server Pages 2.0: 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.

 

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