Elstree Film Studios - Training Courses - ASP & SQL Training Courses
Please note that this course has now been incorporated into our Database Training Course. If there are dates listed at the bottom of this page, they will relate to the new course.Active Server Pages (ASP) allows the web developer to write programs that will run on the server.
With ASP the developer can respond to user input in a form, send customised pages to users based on preferences, and design web pages driven from a database.
Although these tasks can be achieved using PERL and other CGI scripts, the use of ASP makes the process much easier, and allows the developer to use the popular Visual Basic language.
Duration: 1 day.
Location: 21st Century New Media Ltd, Elstree Film Studios, Shenley Road, Borehamwood, Hertfordshire, WD6 1JG. [
Click here for a map]
Times: 10.00am to 4.30pm. For security reasons, further details are only provided upon booking.
Software Versions: All of our Adobe courses include lessons generic to CS3, CS4 and CS5 versions of the Adobe suite: whichever version you use is covered in detail. Our Apple training courses utilise Final Cut Studio HD (also known of as version 3 or FCS 2009).
Equipment: Our fully featured training room includes six top-of-the-range iMac computers configured to work in both Macintosh (OSX) and PC (Windows) modes, ensuring you the maximum familiarity with your chosen operating system.
Accommodation: Details of local accomodation can be found
here.
Further assistance: Our
FAQ help page contains the answers to many popular questions. Alternatively please call
0844 844 2428 to arrange to speak to our training manager.
COURSE CONTENT
Introduction to the RDBMS environment
- Service manager
- Enterprise manager
- Query Analyser
Create a Database and Tables via Enterprise manager
- Table Property types, constraints and identities
Using the SQL SELECT statement via Query Designer
Building Simple and Relational Tables
- Create a relationship entity diagrams
Using the Query analyser
- Queries vs Views Attendees
Create a Database and Tables via Query analyser
- Using the Query Analyser & Query window
- Writing Scripts to create and drop objects
- Writing Scripts to achieve normal data manipulation tasks.
Stored Procedures
- The advantages of stored procedures
- Creating stored procedures and practice them
Using Data Transformation Services (DTS)
- Import a table using DTS - Access, Excel & Text files
Connecting SQL server to Access via an ODBC interface
Setting up a Data Source Name (DSN)
- Creating Access Forms and Reports
Practical Workshop
- Building a Corporate RDBMS complete with DAB administration and Programming
Fundamentals of CGI (Common Gateway Interface)
- What is CGI?
- CGI basics
- HTML forms
- Environment Variables
- CGI Issues
Introducing Server Side Scripting
- Situations in which Server Side scripting is more appropriate
- Situations in which Client Side scripting is more appropriate
- Active Server Pages Overview
ASP Objects
- Intrinsic Objects on the Server
- Request Collections
- Response Objects
- Session and Application state
- Creating Server Components
Writing ASP
- Retrieving Information From The User
- Sending Customised Pages
- Keeping Values Across User Sessions And The Server Application
- Using Cookies with ASP
- Using Components included with IIS
- Server Side Includes
Using ADO
- Active Data Objects Overview
- SQL overview
- Retrieving and Displaying Records
- Navigating Records
- Modifying Data
- Executing a Command
- Scaling ADO
Overview of Microsoft Visual InterDev 6.0
- Visual InterDev Architecture
- Creating a Web Project
- Creating a connection to a database
- Editing Pages in Design View and Source View
- Working in the Data Environment
- Using Design Time Controls
