Elstree Film Studios - Training Courses - Web Database Techniques
Many websites are static creations designed purely to promote businesses or individuals. Yet on many occasions, more powerful and dynamic database driven systems are required and these can often be complex to understand and create without the proper background knowledge.
This course gives you a fantastic head start in setting up database driven systems for your clients and personal web projects. Beginning without any prior knowledge, this course guides you through all of the basics, from understanding how dynamic web programming languages like PHP and ASP work, progressing through how to set up your own database tables and field values, to how to create and debug your own database scripts, this course presents you with the quickest route to setting up database systems that will allow you to move on to the next level in your dynamic website creations.
Duration: 1 day.
Prerequisites: This course is ideal for beginners who have little or no knowledge of database languages. Good Mac or PC skills and an understanding of the web and its terminologies are required.
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
Web database languages explained
- PHP
- ASP
- ASP.NET
- The uses of Javascript
Types of databases and how they work
- mySQL databases explained
- SQL databases explained
- Hosting requirements
- Database tables
- Field types and values
Setting up web databases
- Setting up a new database
- Creating database tables
- How to choose the correct field types
- Things you should know before writing database scripts
Writing database scripts
- Adding data to a table using PHP/ASP
- Retrieving data from a table using PHP/ASP
- Editing data within a table using PHP/ASP
- Using Javascript to validate user input
Displaying data
- Displaying data on a webpage
- Searching for specific data in a database
- Further uses for database scripting
