This course introduces you to databases and data manipulation.
This online course focuses on thematic (also known as attribute) databases, the relational data model, and queries in the query language SQL. Database engineering is an important tool for any type of information management. The techniques learnt will be useful in a variety of settings in professional life.
The course is relevant for anyone working with (usually large) collections of structured data. It focuses on what database technology has to offer, and lays the foundation for more advanced data handling techniques covered in other courses. We expect a basic level of computer skills and independence from you, as well as familiarity with standard Windows software and secondary school discrete mathematics, and the ability to explore new software and new datasets.
The course covers the following topics:
- what purposes do databases serve, and when should they be used?
- database management systems
- the relational data model
- set theory and mathematical logic as a foundation for data manipulation
- database querying using SQL
- database maintenance
- introduction to database design and UML
- database implementation.
You will learn how database management systems work, what stored tables and queries are, and how to define queries in SQL. In addition, the first aspects of database design will be covered.
On completion of this course, you will be able to:
- explain the fundamentals of the relational data model
- formulate simple queries in mathematics
- define, execute and verify SQL queries against an existing relational database
- follow simple steps in database design (UML class diagrams).
Academic level and background
Applicants for an online course should have a Bachelor degree or equivalent from a recognised university in a discipline related to the course, preferably combined with working experience in a relevant field.
The faculty accepts transcripts, degrees and diplomas in the following languages: Dutch, English, German, French and Spanish. It is at the discretion of the faculty to require additional English translations of all documents in other languages as well.
As all courses are given in English, proficiency in the English language is a prerequisite.
If you are a national of one of the countries in this list (PDF), you are exempted from an English language test.
Please note: the requirements when applying for fellowships may vary according to the regulations of the fellowship provider.
English language tests: minimum requirements
Only internationally recognized test results are accepted.
TOEFL Paper-based Test (PBT)
TOEFL Internet-based Test
British Council / IELTS
C2 Proficiency / C1 Advanced
Applicants for the online education programme must have elementary computer experience, regular access to internet and e-mail. For some courses additional computer skills are required (see description of specific course).
GIS and remote sensing
Most online courses, except for the introductory course, require knowledge of, and skills in, working with GIS and/or digital image processing of remotely sensed data.
Candidates are asked to provide proof of identity during the registration process.
Upon successful completion of this course you will receive a Certificate which will include the name of the course.
Along with your Certificate you will receive a Course Record providing all the subjects studied as part of the course. It states: the course code, subject, ECTS credits, exam date, location and the mark awarded.
If you decide to follow a full Postgraduate or Master's course at ITC, and after approval of the Examination Board, you will be exempted from the course(s) you followed successfully as an online course.