COURSES
The European Projects Portal

Database design

A database is an essential part of any distributed software application. In this course students will learn the basics of a database designed to support a typical web application.

Modules from this course can be combined with those from Web Design and Web Server to create a course more tailored to your students' requirements. Please contact the coordinator for more information.


Audience

Students in IT and programming who are interested in developing multi-user applications.

Goals

To understand how data can be stored and accessed safely and efficiently. Design and implement database solutions.


1 week Ref: ECDB

Week 1

Day 1
Introduction to databases

The student will learn the fundamentals of good database design. Creating and maintaining database tables.

Day 2
User registration and login

The student creates a database with a table to store typical details related to a user account.

Day 3
Gallery maintenance

The student adds tables to store and cross-reference a gallery of images associated with the user account.

Day 4
Server integration

The student expands the database to include additional information accessible on the eurovoca website.

Day 5
Practical field work

The student uses a smartphone to capture an image and text along with its geolocation, which is displayed on a web page using Google Maps or posted in social media to demonstrate the practical application of what they have learned. This module can be taken at any point during the course.
For terms and conditions and privacy policy please visit the web site eurovoca.com