ASP Scripting VTC Training 2 CDs
ASP Scripting VTC Training 2 CDs
Publisher: Virtual Training Co | 2005 | ISBN-10: 1932808450 | ISBN-13: 978 1932808452 | English | EXE | Duration: 8.5 hrs | 819.83 Mb
Publisher: Virtual Training Co | 2005 | ISBN-10: 1932808450 | ISBN-13: 978 1932808452 | English | EXE | Duration: 8.5 hrs | 819.83 Mb
ASP is a server-side technology that uses a scripting language to generate dynamic Web pages. As a server side scripting language, ASP uses both built-in and external objects to generate web pages from a web server onto a client machine, generating HTML code to be viewed in a browser over the Internet. ASP also makes heavy use of a scripting/programming language called VBScript. VBScript is syntactically equivalent to the popular Microsoft SDK Visual Basic. VTC author, Gavin Powell, takes you from the basics of creating your first ASP page, through to the complexities of database access and beyond.
We have made some of the video tutorials for ASP Scripting freely available to help you evaluate our training.
Work files incl. 171 tutorials
Welcome
Welcome (02:03)
Prerequisites for this Course (00:50)
About this Course (04:35)
Where to Find Documentation (04:36)
What is ASP?
Active Server Pages (ASP) (03:53)
Extending ASP (02:22)
Client Based Scripting - VBScript (05:10)
Client Based Scripting - JavaScript (01:03)
Server Based Scripting (04:43)
Why is Server Based Scripting Necessary? (03:23)
Alternatives to ASP (04:07)
Pros and Cons of Using ASP (04:21)
Tools for ASP Development
What is IIS? (Internet Information Server) (02:39)
Installing IIS (02:23)
Getting IIS Up and Running pt. 1 (03:16)
Getting IIS Up and Running pt. 2 (03:11)
Using PWS (Personal Web Server) (01:51)
Creating a Simple ASP Scripting Example (04:23)
Using Visual Interdev (03:06)
Using the Microsoft Script Debugger (01:34)
Using VBScript
VBScript in Web Pages (01:51)
Procedures and Functions (05:01)
The Basics - Datatypes (01:21)
The Basics - Variables (02:15)
The Basics - Constants (01:10)
The Basics - Operators (02:00)
The Basics - Other Stuff (04:33)
Programming Control Structures (05:50)
Objects/Properties and Methods (05:32)
A Quick Look at JScript (01:43)
The Basics of ASP Scripting
From ASP to HTML (01:07)
HTML Tags in ASP (02:59)
Referring to Existing HTML Elements (04:40)
Header Stuff (01:56)
The GLOBAL.ASA File (04:42)
Application and Session Objects (04:30)
A Hit Counter Page (02:09)
The Default Start Page (04:05)
Text Files and Concurrency (05:29)
Client Persistence and Cookies (02:27)
Send and Retrieve (01:17)
Including Objects in ASP (02:38)
Exclude Business Logic from ASP (03:18)
Including Scripts for Reuse pt. 1 (01:58)
Including Scripts for Reuse pt. 2 (03:44)
What’s New in ASP3? (02:37)
Introducing Built In ASP Objects
What are the Built In ASP Objects? (02:05)
The Response Object (01:09)
The Request Object (00:50)
The Application Object (00:44)
The Session Object (00:27)
The Server Object (00:26)
The Error Object (00:43)
The File System (00:34)
The Dictionary Object (01:17)
Simple Built In ASP Objects
The Application Object pt. 1 (02:46)
The Application Object pt. 2 (03:22)
The Application Object pt. 3 (03:40)
The Application Object pt. 4 (04:45)
The Error Object (02:23)
The Dictionary Object (03:53)
The Server Object pt. 1 (03:22)
The Server Object pt. 2 (03:43)
The Server Object pt. 3 (03:41)
The Response Object
The Response Object (02:29)
Writing Text to the Client (00:59)
Redirecting to a New URL (01:44)
Controlling Response with the Buffer (02:25)
Ending and Expiring Pages (01:26)
Client and Page Status (05:02)
Content Type and Character Set (01:33)
Obscure Properties and Methods (00:50)
The Request Object
The Request Object (02:14)
Server Variables (03:21)
QueryString URL Parameters (03:19)
QueryString Multiple URL Parameters (05:27)
QueryString FORM METHOD=GET (01:41)
Request.Form (03:33)
Obscure Properties and Methods (00:40)
The Session Object
What is a Session? (03:37)
The Session Object (01:20)
Session Start and End Events (02:36)
The Contents Collection pt. 1 (03:36)
The Contents Collection pt. 2 (02:25)
Connecting and Disconnecting (02:44)
Obscure Session Properties (02:42)
Data Persistence on the Client
What is Persistence? (02:46)
What is a Cookie? (01:35)
Cookies in ASP (01:51)
Multiple Valued Cookies pt. 1 (02:44)
Multiple Valued Cookies pt. 2 (03:08)
Session Cookies (00:46)
Are Cookies Enabled on the Client? (05:53)
Persistence and the File System
ASP Objects and the File System (01:22)
The FileSystem Object (02:40)
Using the FileSystem Object pt. 1 (03:34)
Using the FileSystem Object pt. 2 (03:02)
The TextStream Object (02:18)
Using the TextStream Object (03:21)
The Drive Object (01:26)
The File Object (01:21)
The Folder Object (01:41)
Database Persistence and ADO
Database Drivers (00:47)
Configuring ODBC and OLEDB (01:30)
Reading an Oracle Database (04:53)
Reading an Access Database (03:41)
What is ADO? (03:49)
ADO Object Hierarchy (01:56)
ADO Objects Function and Purpose (04:26)
ADO Object Attributes pt. 1 (03:45)
ADO Object Attributes pt. 2 (03:16)
ADO/ASP/ SQL
The Most Significant ADO Objects (03:50)
Recordset Transparent SQL (02:09)
What is SQL? The SELECT Statement (03:00)
INSERT/UPDATE/DELETE (02:20)
SELECT Statement Syntax (04:34)
SELECT Statement Syntax WHERE Clause (03:09)
SELECT Statement Syntax: GROUP BY (02:34)
SELECT Statement Syntax: ORDER BY (01:31)
INSERT Statement Syntax (01:21)
UPDATE Statement Syntax (03:17)
DELETE Statement Syntax (02:17)
What is a Transaction? (04:16)
Retrieving Data From a Database
What is a Recordset? (02:04)
Recordset Fields and Values (03:27)
Opening a Recordset (04:26)
Closing and Emptying Objects (00:53)
Advanced Recordset Options pt. 1 (04:25)
Advanced Recordset Options pt. 2 (03:24)
Paging Partial Recordsets (03:18)
Disconnected Recordsets pt. 1 (03:56)
Disconnected Recordsets pt. 2 (01:48)
Changing Data in a Database
Adding Rows (00:51)
The SQL INSERT Statement pt. 1 (03:18)
The SQL INSERT Statement pt. 2 (02:43)
Recordset.Addnew pt. 1 (03:22)
Recordset.Addnew pt. 2 (03:09)
Changing Rows (00:32)
The SQL UPDATE Statement pt. 1 (03:53)
The SQL UPDATE Statement pt. 2 (03:26)
Recordset.Update (03:17)
Batch Updates pt. 1 (03:17)
Batch Updates pt. 2 (03:42)
Batch Updates pt. 3 (03:40)
Deleting Rows (02:22)
The SQL DELETE Statement (05:07)
Recordset.Delete (03:17)
Using Stored Procedures
Stored Procedures and Functions (04:02)
Executing a Stored Procedure (03:37)
Using Input Parameters (02:07)
Input and Output Parameters (03:00)
Input / Output Parameters (01:37)
Using Functions (02:41)
Components
Instantiating Components (02:58)
IIS Resource Kit Components (01:17)
E-Mail (02:15)
Windows Scripting Components (01:20)
Charting (01:23)
Where Can Components be Found? (01:56)
XML in ASP
What is XML? (03:13)
What is XSL? (02:49)
The XML Dynamic Object Model in ASP (04:04)
Rendering XML Using XSL in ASP (02:30)
Generating XML Manually from a Database (03:52)
Wrapping it Up
Debugging ASP (04:42)
Tuning ASP pt. 1 (04:35)
Tuning ASP pt. 2 (03:34)
Security ASP and IIS (03:15)
The Future: ASP.NET (00:57)
What You Have Learned (01:16)
Credits
About the Author (02:04)
Welcome (02:03)
Prerequisites for this Course (00:50)
About this Course (04:35)
Where to Find Documentation (04:36)
What is ASP?
Active Server Pages (ASP) (03:53)
Extending ASP (02:22)
Client Based Scripting - VBScript (05:10)
Client Based Scripting - JavaScript (01:03)
Server Based Scripting (04:43)
Why is Server Based Scripting Necessary? (03:23)
Alternatives to ASP (04:07)
Pros and Cons of Using ASP (04:21)
Tools for ASP Development
What is IIS? (Internet Information Server) (02:39)
Installing IIS (02:23)
Getting IIS Up and Running pt. 1 (03:16)
Getting IIS Up and Running pt. 2 (03:11)
Using PWS (Personal Web Server) (01:51)
Creating a Simple ASP Scripting Example (04:23)
Using Visual Interdev (03:06)
Using the Microsoft Script Debugger (01:34)
Using VBScript
VBScript in Web Pages (01:51)
Procedures and Functions (05:01)
The Basics - Datatypes (01:21)
The Basics - Variables (02:15)
The Basics - Constants (01:10)
The Basics - Operators (02:00)
The Basics - Other Stuff (04:33)
Programming Control Structures (05:50)
Objects/Properties and Methods (05:32)
A Quick Look at JScript (01:43)
The Basics of ASP Scripting
From ASP to HTML (01:07)
HTML Tags in ASP (02:59)
Referring to Existing HTML Elements (04:40)
Header Stuff (01:56)
The GLOBAL.ASA File (04:42)
Application and Session Objects (04:30)
A Hit Counter Page (02:09)
The Default Start Page (04:05)
Text Files and Concurrency (05:29)
Client Persistence and Cookies (02:27)
Send and Retrieve (01:17)
Including Objects in ASP (02:38)
Exclude Business Logic from ASP (03:18)
Including Scripts for Reuse pt. 1 (01:58)
Including Scripts for Reuse pt. 2 (03:44)
What’s New in ASP3? (02:37)
Introducing Built In ASP Objects
What are the Built In ASP Objects? (02:05)
The Response Object (01:09)
The Request Object (00:50)
The Application Object (00:44)
The Session Object (00:27)
The Server Object (00:26)
The Error Object (00:43)
The File System (00:34)
The Dictionary Object (01:17)
Simple Built In ASP Objects
The Application Object pt. 1 (02:46)
The Application Object pt. 2 (03:22)
The Application Object pt. 3 (03:40)
The Application Object pt. 4 (04:45)
The Error Object (02:23)
The Dictionary Object (03:53)
The Server Object pt. 1 (03:22)
The Server Object pt. 2 (03:43)
The Server Object pt. 3 (03:41)
The Response Object
The Response Object (02:29)
Writing Text to the Client (00:59)
Redirecting to a New URL (01:44)
Controlling Response with the Buffer (02:25)
Ending and Expiring Pages (01:26)
Client and Page Status (05:02)
Content Type and Character Set (01:33)
Obscure Properties and Methods (00:50)
The Request Object
The Request Object (02:14)
Server Variables (03:21)
QueryString URL Parameters (03:19)
QueryString Multiple URL Parameters (05:27)
QueryString FORM METHOD=GET (01:41)
Request.Form (03:33)
Obscure Properties and Methods (00:40)
The Session Object
What is a Session? (03:37)
The Session Object (01:20)
Session Start and End Events (02:36)
The Contents Collection pt. 1 (03:36)
The Contents Collection pt. 2 (02:25)
Connecting and Disconnecting (02:44)
Obscure Session Properties (02:42)
Data Persistence on the Client
What is Persistence? (02:46)
What is a Cookie? (01:35)
Cookies in ASP (01:51)
Multiple Valued Cookies pt. 1 (02:44)
Multiple Valued Cookies pt. 2 (03:08)
Session Cookies (00:46)
Are Cookies Enabled on the Client? (05:53)
Persistence and the File System
ASP Objects and the File System (01:22)
The FileSystem Object (02:40)
Using the FileSystem Object pt. 1 (03:34)
Using the FileSystem Object pt. 2 (03:02)
The TextStream Object (02:18)
Using the TextStream Object (03:21)
The Drive Object (01:26)
The File Object (01:21)
The Folder Object (01:41)
Database Persistence and ADO
Database Drivers (00:47)
Configuring ODBC and OLEDB (01:30)
Reading an Oracle Database (04:53)
Reading an Access Database (03:41)
What is ADO? (03:49)
ADO Object Hierarchy (01:56)
ADO Objects Function and Purpose (04:26)
ADO Object Attributes pt. 1 (03:45)
ADO Object Attributes pt. 2 (03:16)
ADO/ASP/ SQL
The Most Significant ADO Objects (03:50)
Recordset Transparent SQL (02:09)
What is SQL? The SELECT Statement (03:00)
INSERT/UPDATE/DELETE (02:20)
SELECT Statement Syntax (04:34)
SELECT Statement Syntax WHERE Clause (03:09)
SELECT Statement Syntax: GROUP BY (02:34)
SELECT Statement Syntax: ORDER BY (01:31)
INSERT Statement Syntax (01:21)
UPDATE Statement Syntax (03:17)
DELETE Statement Syntax (02:17)
What is a Transaction? (04:16)
Retrieving Data From a Database
What is a Recordset? (02:04)
Recordset Fields and Values (03:27)
Opening a Recordset (04:26)
Closing and Emptying Objects (00:53)
Advanced Recordset Options pt. 1 (04:25)
Advanced Recordset Options pt. 2 (03:24)
Paging Partial Recordsets (03:18)
Disconnected Recordsets pt. 1 (03:56)
Disconnected Recordsets pt. 2 (01:48)
Changing Data in a Database
Adding Rows (00:51)
The SQL INSERT Statement pt. 1 (03:18)
The SQL INSERT Statement pt. 2 (02:43)
Recordset.Addnew pt. 1 (03:22)
Recordset.Addnew pt. 2 (03:09)
Changing Rows (00:32)
The SQL UPDATE Statement pt. 1 (03:53)
The SQL UPDATE Statement pt. 2 (03:26)
Recordset.Update (03:17)
Batch Updates pt. 1 (03:17)
Batch Updates pt. 2 (03:42)
Batch Updates pt. 3 (03:40)
Deleting Rows (02:22)
The SQL DELETE Statement (05:07)
Recordset.Delete (03:17)
Using Stored Procedures
Stored Procedures and Functions (04:02)
Executing a Stored Procedure (03:37)
Using Input Parameters (02:07)
Input and Output Parameters (03:00)
Input / Output Parameters (01:37)
Using Functions (02:41)
Components
Instantiating Components (02:58)
IIS Resource Kit Components (01:17)
E-Mail (02:15)
Windows Scripting Components (01:20)
Charting (01:23)
Where Can Components be Found? (01:56)
XML in ASP
What is XML? (03:13)
What is XSL? (02:49)
The XML Dynamic Object Model in ASP (04:04)
Rendering XML Using XSL in ASP (02:30)
Generating XML Manually from a Database (03:52)
Wrapping it Up
Debugging ASP (04:42)
Tuning ASP pt. 1 (04:35)
Tuning ASP pt. 2 (03:34)
Security ASP and IIS (03:15)
The Future: ASP.NET (00:57)
What You Have Learned (01:16)
Credits
About the Author (02:04)
ASP Scripting VTC Training 2 CDs
ASP Scripting VTC Training 2 CDs
ASP Scripting VTC Training 2 CDs
ASP Scripting VTC Training 2 CDs
ASP Scripting VTC Training 2 CDs
