Intermediate ASP (P184)

Intermediate ASP is a 6 week course that will focus on the fundamentals of using Active Server Pages (ASP) with databases. ASP is used to create interactive web pages that can both receive and deliver dynamic content. One of the most common uses of ASP is to interact with a server-side database. These topics, and more, will be covered during the course. Although there are several scripting languages available, this course will utilize VBScript.

Outline

Week 1: The ASP Environment

Application Object
Global.asa File
Application Variables
Server Object
CreateObject Method
MapPath Object

Week 2: Connections

What is ADO?
Creating DSN Connections
Connection Object
Connection Properties
Creating a dynamic connection

Week 3: Recordsets

Recordset Object
Recordset Properties
Recordset Methods
Recordset Navigation
Displaying fields

Week 4: Data manipulation

Essential SQL
SQL techniques vs. ADO techniques
Retrieving data
Modifying data
Deleting data

Week 5: Integrating Forms and Databases

Creating a data entry form
Creating a data display form
Data validation
Translating data types from the database to the form
Translating data types from the form to the database

Week 6: Wrap-Up Project

An application using forms and databases
Data Entry
Redisplaying the Data
Saving the Data
Retrieving the data
Modifying the data
Cleaning up

Prerequisites

Working knowledge of HTML and basic web site design. Introduction to ASP is also required. A basic understanding of databases is also useful.

Requirements

In order to take full advantage of this course, students will need to have access to a web server capable of responding to ASP pages. Any web site design software can be used for the lessons.

Books:
Suggested Book:	ASP in a Nutshell, 2nd Edition
Additional information:
Your place in the course is confirmed by your payment. Introductory courses are intended for students with no experience in the subject matter and are seeking beginner level training. Refund Policy: Please read our Terms and Refund Policy before registering for this course. Additional Cost: Book and software might be required for the course. Read the Requirements and Book section for more information. Course fee does not include the book and software cost . How eClasses Work:Instructors post lectures (text-based, no video or audio), reading selections, and hands-on assignments once a week in the online classroom. Students can discuss the assignments with the instructor and amongst themselves in the classroom area. This format has no set meeting time, which allows students to attend class at a time most convenient to them, yet still provides logically organized communication between class participants. Students can apply for the completion certificate after finishing the class.

Price:

$270.00

Item No.:

P184

Instructor:

Open Position

CEUs:

Duration:

6 weeks

Open Courses: No other sessions are scheduled for this course. You can add to your wish list and you will be notified when other sessions are scheduled.

Instructor's Profile

We are looking for an instructor to teach this course. To apply please visit the Teach Online section for more information.

Before you register for this class, please read the Outline, Prerequisites, Requirements, Books, and Refund Policy sections carefully.

Send to friend

Testimonials

Rating

No testimonial available!