COURSE NAME: ASP - Fundamentals (4065)

Unit 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.

Unit 1: Introduction to ASP

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

Unit 2: Server-side Includes

• Using Server-side Includes
• Using Dynamic Server-side Includes

Unit 3: The Response Object

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

Unit 4: The Request Object

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

Unit 5: Cookies

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

Unit 6: ASP Components, Part 1

• What are ASP Components?
• The Server Object
• The AdRotator Component

Unit 7: ASP Components, Part 2

• The Browser Capabilities Component
• The Content Linking Component

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

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

Unit 9: The Built-in Scripting

• Objects
• The FileSystemObject Object
• The TextStream Object

Unit 10: ASP and the ADO Model

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

Unit 11: Viewing Database Records

• Working with Recordsets
• Creating Combo Boxes and Option Groups
• Filtering Records

Unit 12: Adding, Updating, and Deleting Records

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

Unit 13: Stored Procedures and Parameters

• Using Stored Procedures
• The Command Object
• Parameter Queries

Unit 14: Advanced Recordset Techniques

• Editing Records with a Data Browser
• Paging Through a Recordset