Tel: 0844 844 2428

Clients

No joke ... but we have taught (in many cases, more than once) to all of these companies:

(Click here to see some testimonials as well)

* Accolade Publishing
* Ace4Training
* ACS-APT Computer Systems Ltd
* Active Silicon
* Active Solutions Europe Ltd
* Allied Manufacturing
* American Express Travel
* Arity Limited
* aura
* BCIM London South Bank University
* BE Aerospace UK Ltd
* Bechtel
* Bechtel Ltd
* Biggerfish Design
* Bio-Rad Laboratories Ltd
* Boltblue
* Bond Hotel
* Bourne Leisure Ltd
* BP
* BPP Learning Media
* Brasher Leisure Ltd T/A Sweatshop
* Brunel University
* BskyB
* Building Research Establishment Ltd
* CADinteractive
* Castle Computing Services Ltd
* Chroland Associates Ltd
* CIMA
* City Interactive Media
* Comet Group
* Community Server Ltd
* Concep Group Limited
* Concern Worldwide
* Control Techniques
* Copenhagen International School
* Crystalblue Solutions
* Cultoon Television Limited
* Customer Interaction
* David Richards Limited
* DBT
* Defaqto Ltd.
* dept of economics, maths & stats
* Discovery Communications Europe Ltd
* Discovery Communications Ltd
* DMG World Media
* Dubai College
* Dubai Heaven On Earth
* EDCTP-EEIG
* Enterprise Insight
* Europa Components
* Families for Children
* Findaplaceabroad.com
* FIRA International Ltd
* FL1 Solutions
* Foremost Curreny Group
* GE HEALTHCARE
* Giles & Posner Ltd
* Glint Facilities
* Global Beach
* H Bauer Publishing
* Harley Cosmetic Consultancy Ltd
* Harrow College
* Healthcare Education Services
* Hertfordshire County Council
* Hertfordshire Partnership NHS Foundation Trust
* Holland Park School
* HP Foods Ltd
* HWTMA
* I Want One Of Those.com
* Inspired Gaming Group
* International Greetings
* International University Link
* ISA Retail
* ITV
* Jog Ltd
* JollofTutors
* JWT London
* Kent County Council
* kerbsideprophet.com
* Keziah Design Ltd
* KLC School of Design
* Lee Valley Regional Park Authority
* Lehmann Communications
* London Fertility Centre
* Loudspeaker/ Lateral Group
* Man Investments
* Man Investments AG
* MCS Creative Ltd
* Medina High School
* Merton College
* Minerva Computer Services
* Mining Communications Ltd
* MOD, DASA(CS0)
* Modernisation Initiative
* Monarch Airlines
* Monks Walk School
* Mothercare
* Mothercare Uk Limited
* NATS c/o Business Training Partnership
* Network Data Holdings PLC
* Nichols Plc
* Nokia UK Ltd
* North Yorkshire Police
* Norwich City Football Club
* OHL GROUP LIMITED
* Oil Technics Ltd
* OmniLedger Ltd
* onezerosix
* Orantez
* OV Productions
* Oxford University Press
* P&O Ferries
* PartyGaming Marketing (UK)
* PFA Consulting
* Pfizer Limited
* Platform Sales & Hire Ltd
* Powergen / E.ON
* PreScript Communications Ltd
* R P Europe Limited
* Reed Learning
* Reed`s School
* Research Now
* RNIB
* Rocketseed
* Rothamsted Research
* Royal Academy Of Music
* RP Europe
* Sandwell and Birmingham Hospitals
* Saxon Industries
* Serco TTI
* Sesame
* Sesame Ltd
* Severndroog Castle Building Preservation Trust
* Something Graphic Ltd
* Sort IT.biz Ltd
* south kent college
* South West of England Regional Development Agency
* Southampton City Council
* Southampton Solent University
* St Matthew Academy
* Standout
* Stiefel Laboratories
* Stoke-on-Trent City Council
* Systex Ltd
* Tectura UK
* Tesco
* The Deeping School
* The Mobile Music Company
* The Mobile Music Company Ltd
* the National Deaf Children`s Society
* TMN Media
* Toshiba
* Tourdesign Ltd
* Twyford C of E High School
* United Utilities
* University of Hertfordshire
* University of Southampton
* V2 Music Group
* VillaCentre Limited
* Vocal Limited
* Vokera Limited
* Yamaha Electronics (UK) Ltd
* YouNique Photos

We are listed with


More >>>

A Few Testimonials


"Unbelievable, without a doubt the most competent and professional training course I have had the pleasure of taking."

Mark, Royal Academy Of Music.

"Great couple of days. Alex is a great tutor with extensive knowledge. I felt I achieved a firm grasp of the topic under good guidance! Very impressed."

Chris, Norwich City Football Club.

"Excellent course - not exactly what I expected but better for it. Will be extremely useful in many areas."

Paul, Bechtel Limited.

See more testimonials >>>

Elstree Film Studios - ASP & SQL - Scheduled Courses









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.

* During the course delegates will create a typical data driven website using HTML and ASP.

Other Courses Avalible:

Duration: 2 days.

Location: 21st Century New Media (Production Offices), Elstree Film Studios, Shenley Road, Borehamwood, Hertfordshire WD6 1JG. [MAP]

Prerequisites:

A reasonable knowledge of database concepts or exposure to MS Access is required. A little programming knowledge would be useful.

Delegates should have good HTML skills, and be familiar with using JavaScript or VB Script for client-side scripts in a web page. The use of Visual InterDev as a tool to help you write ASP code is optional, but recommended.

Why Take This Course?


The SQL language, with its relational database systems, is one of the most important foundation technologies in the computer industry. SQL stands today as the standard computer database language. ASP was designed as a faster and easier alternative to CGI scripting using Perl or C.




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

  • Using special operators

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
5-20% discount if you book for more than one delegate!
Further discounts are available when booking multiple courses,
Please call and arrange to speak to our training secretary
on 0844 844 2428.

ASP Training Courses
We are currently scheduling dates for this course. If you would like to be notified when this course is next due to be run, please enter your details below. All of our courses cost £250 + VAT per day which includes lunch, coffee/tea and training materials.

Your First Name *
Your Last Name *
Your Email Address *