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
Online English tests during COVID-19
We acknowledge the difficulties experienced worldwide in taking the compulsory language test, due to the Covid-19 situation. An alternative English test can be the TOEFL iBT Special Home Edition test (online test). This test is accepted by UT and is available everywhere that TOEFL iBT testing is normally available, with the exception of Mainland China and Iran.
Please note that the only online English language test that is accepted at UT is the TOEFL iBT Special Home Edition. Other online English language tests (i.e. IELTS Indicator test, Cambridge online test, etc.) will not be accepted(!).
To follow online education you must have basic computer experience, regular access to internet, and e-mail. For some courses, additional computer skills are required (see description of specific course).
Technical requirements online education and assessment
For online education, we formulated guidelines to guarantee optimal performance. For online oral exams and proctoring during online assessments, the webcam and headset requirements need to be met.
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.