Microsoft Visual InterDev 6.0: Active Server Pages and Data Access

Course Code NGE72577

Contents

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Screenshot

Description

This is the third course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. At the completion of this course, students will learn to identify the features of Active Server Pages (ASP); create a server script and debug the server-side script; set permissions for a Web application; add a Data Source Name (DSN), a data connection and a data command to a project; and identify the advantages of using script objects.

Audience

This course series is designed for site developers who perform architectural planning, technology selection, or Web site programming tasks. This series will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. Participants should have completed the first two courses in the series.

Prerequisites

(Currently no course prerequisite information)

Objective

• Identify the features of Active Server Pages (ASP).
• Create a server script and debug the serverside script.
• Set permissions for a Web application.
• Add a Data Source Name (DSN), a data connection and a data command to a project.
• Identify the advantages of using script objects.

Topics Include

Unit 1: Active Server Pages (ASP)

• Identify the features of Active Server Pages (ASP).
• Identify the features of ASP applications.
• Set up ASP services on a Web server.
• Sequence the steps involved in the process of establishing an HTTP session.
• Match the ASP processing directives with their functions.
• Match the built-in objects provided by ASP with their function.
• Create a server script by using the Script Outline window.
• Debug a server script by using the Project Explorer window.
• Add an error handler to handle the run-time errors in server scripts.

Unit 2: Implementing ASP

• Match the header fields of an HTTP request message with their purposes.
• Identify the syntax of an HTTP request method line in a given scenario.
• Match the collections of the Request object with their functions.
• Write the code to extract information from the header of an HTTP Request message in a given scenario by using the QueryString collection.
• Write the code to read form data in a given scenario by using the Form collection.
• Match the header fields of an HTTP response message with their purposes.
• Identify the properties of Response object.
• Identify the methods of the Response object.
• Write the code to redirect the user to another URL by using the Redirect method of the Response object.
• Validate the user input by using the server script.
• Write the code to prevent concurrent access to the Application object by using the methods of an Application object.
• Write a script to store information by using the Session object.
• Add a script to the event procedure of the object maintaining the state data.
• Set the value of a cookie by using the Cookies collection of the Response object.
• Write the syntax to create an instance of a component.
• Match the built-in ActiveX components used to create ASP with their functions.
• Set the properties of Browser Capabilities component in the Browscap.ini file.
• Write to a text file by using the TextStream object.
• Create a page object by using the PageObject design-time control.
• Define a method for a page object by using the PageObject design-time control.
• Define a property for a page object by using the PageObject design-time control.
• Call a method on a page object from another page object.
• Set unique permissions for a Web application by using the Project Explorer window.
• Set the access permissions on a virtual directory of a Web server by using Microsoft Management Console.
• Set up the account used for anonymous access.
• Prevent anonymous logon to a Web server.
• Set the access permissions for the files stored on an NTFS partition.

Unit 3: Accessing Data

• Sequence the steps to display data from a database in an ASP page.
• Identify the functions of the data environment.
• Identify the features of a data source name.
• Sequence the steps involved in the login authentication process for connecting to a SQL Server database.
• Add the connection information for connecting to a SQL Server database.
• Add a data connection to a project.
• Identify the features of a data command.
• Match the Query Designer panes with their functions.
• Add a data command to the data environment.
• Identify the data display and data manipulation controls.
• Identify the features of a Recordset control.
• Identify the Recordset control properties.
• Add a Recordset control to an ASP page.
• Add the RecordsetNavbar control to an ASP page.
• Add a Grid control to an ASP page.

Unit 4: Managing Data Access

• Identify the advantages of script object.
• Write an event handler script for the script objects in a given scenario.
• Create a form mode by using FormManager.
• Match the database integration features with their descriptions.
• Create a database project.
• Identify the purposes of database diagrams.
• Identify the features of stored procedures.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently, only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

CDROM