|
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
|
| IWA-HWG Price: |
$170.00
|
| Course No.: |
P184 |
| Instructor: |
Open Position |
| Co-instructor/TA: |
|
| CEUs: |
3 |
| Duration: |
6 weeks |
|
Open Courses: Sorry, no other session is scheduled for this course. You can add this course to your wish list and we will notify you 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. |
| |
|
|
|
