Databases within website design
On this page
|
|
|
|
|
| 3 Interactive computer-marked assignments (iCMAs) | |
| End-of-course assessment | No residential school |
Register for the course
This course is available for study in the countries shown. Fees may vary by country.
Summary
This twelve-week course is the fourth of six that together make up the Certificate in Web Applications Development. Databases play a vital part in business, providing the means to store and retrieve data rapidly; process complex queries; and maintain data integrity and security. Study of this course will give you an understanding of how web applications can use databases. This course introduces you to basics of database design using ‘entity-relationship’ diagrams and the construction of simple queries using SQL-92. The course also explores a server-side development tool: the ColdFusion server extension.
Course content
At the core of this course are two text books on MySQL and Cold Fusion, with all the supporting material presented on a website to which only registered students have access.
By the end of the course you will be able to:
- discuss the role of databases in dynamic website design, such as a shopping site
- undertake practical exercises using ColdFusion and MySQL
- including the following ColdFusion elements with a WWW application:
- CFML tags
- CF variables and variable scope
- CF flow control
- CF functions
- CF action pages
- construct in SQL database, queries against single and multiple tables
- utilise ColdFusion to gather and track user preferences within a WWW application
- discuss the criteria used to select an appropriate database server for web applications
- explain how transaction processing is managed through commitment, and rollback
- describe the use of Entity-Relationship diagrams for database design and documentation
- explain the relative performance of native drivers versus ODBC for database connectivity.
Please note that the teaching material and assignments for this course are available from the course website 3 weeks before you need them. Therefore, if your circumstances do not allow you to study over the whole 12 weeks please think closely before registering for this course.
Entry
The course will appeal to a wide variety of people, for example:
- those who have already taken Web applications: design, development and management (TT280), The client side of application development (TT281) and The server-side of application development (TT282), or
- those who have some experience of developing dynamic web pages using a scripting language, such as JavaScript or ASP.
Although you are not prevented from registering for TT380 without any previous experience, we would not recommend this as you will need to have an understanding of the technicalities of this particular course. As this is a Level 3 course it places certain academic level aims on its students. For example, you will need to be able to complete a 2000-word report at the end of the course, with little help or advice. If you have any doubt about the suitability of the course, please contact our Student Registration & Enquiry Service. We strongly advise against studying two or more courses at the same time.
Visit the dedicated website to learn more about the details of the Certificate in Web Applications Development.
Qualifications
TT380 is a compulsory course in our
The Certificate in Web Applications Development comprises of six courses. If you wish to complete all six courses in order to obtain the Certificate, you should be aware that this Programme is coming to an end and you should plan to include these courses in your study plan in the near future. See the qualification description for details.
TT380 is an optional course in our
It can also count towards most of our other degrees at bachelors level, where it is equally appropriate to a BA or BSc. We advise you to refer to the relevant qualification descriptions for information on the circumstances in which this course can count towards these qualifications because from time to time the structure and requirements may change. You should think carefully about fitting 10 points into a degree that consists mostly of 30-point and 60-point courses.
If you have a disability or additional requirement
The course requires extensive use of a computer, the internet and electronic communications. If you use special hardware or software you must, well before the course begins, find out whether it will work with the course software. The course materials are available in Adobe Portable Document Format (PDF). Components may not be available or fully accessible using a screen reader and mathematical, scientific, and foreign language materials may be particularly difficult to read in this way. Large print versions of the course material can be provided on request. Our Services for disabled students website has the latest information about availability.
If you are a new student, or new to courses using a computer or the internet, you will need to inform us of your particular needs as soon as possible, as some of our support services may take several weeks to arrange. Details of how to do this and our range of support services are described in our booklet Meeting Your Needs which you can download or request from our Student Registration & Enquiry Service.
You can also find information about accessible course materials, financial support and the Disabled Students' Allowance, equipment and other services, on our Services for disabled students website. It also includes our contact details for advice and support both before you register and while you are studying.
Course materials
What's included
Access to the course website and Web Certificate DVD-ROM containing specialist software and multiple web browsers. Downloadable software for taking part in a single/national online forum.
You will need
You should be prepared to spend significant amounts of time online (at least three hours a week). This may mean extra charges to your telephone bill unless you have a package which provides unlimited access to the internet.
Computing requirements
This course includes online computer activities – you can access these using a web browser that can play Flash and Shockwave. Some of your course software will be provided on disk.
You will need internet access and a computer. If you have purchased a new Windows computer since 2002 it should meet your course computing requirements. Check our Technical Requirements section if your computer is older than this or is otherwise unusual. Please note that you cannot use an Apple Mac or Linux computer unless it is running windows Boot Camp or similar.
Teaching and assessment
Study support
The course is taught entirely online. You will not have an individual tutor, but you can use the online forum to ask for help and advice about any aspect of the course. The forum will be moderated by experienced tutors.
Assessment
The assessment details for this course can be found in the facts box above.
You must use the online eTMA system to submit your computer-marked assignments (CMAs). The written end-of-course assessment (ECA) must also be submitted electronically.
Students also studied
Students who studied this course also studied at some time:
Future availability
We expect this course to be available twice a year in February and October.
How to register
To register a place on this course return to the top of the page and use the Click to register button. For more information and advice about registration see OU Study Explained.
About this page
An undergraduate course in Computing and ICT.
Study explained
- Course
- - a module of study that can count towards a qualification.
- Credit points
- - show how much study is required to complete a course or qualification. One credit point represents roughly 10 hours of study.
- Level
- - indicates how difficult a course is. Undergraduate study starts at Level 1.
- Financial support
- - find out if you qualify for support with your fees with our eligibility checker.
- Study explained
- - all you need to know about studying with the OU.
Student Reviews
From a practical viewpoint I found it fairly easily working with MYSQL and ColdFusion. Try not to delete the special ...
Read more
Another course in the A&B series but overall very good. The database side was covered well but the use of ...
Read more
Got a question?
Contact an adviser in our Student Registration & Enquiry Service
Email or call +44(0) 845 300 60 90
Browse the prospectus
Request a print prospectus
Share
This PageThe University wishes to emphasise that, while every effort is made to regularly update this site, the material on it is subject to alteration or amendment in the light of changes in regulations or in policy or of financial or other necessity.