Course: Linux credits: 3
- Course code
- BFVH17LINUX
- Name
- Linux
- Study year
- 2023-2024
- ECTS credits
- 3
- Language
- English
- Coordinator
- R. Wedema
- Modes of delivery
-
- Lecture
- Tutorial
- Assessments
-
- Linux - Computer, organised by School
Learning outcomes
After this course:
- A student will be able to retrieve and sort data from specific fields in a single table using SQL without help from others.
- A student will be able to retrieve and sort data from specific fields contained in more than one table without help from others.
- A student will be able to independently create queries, using the 'group by' and 'having' clauses, standard SQL-functions, subqueries etc, that answer arbitrary complex questions about the data contained in a database.
- A student will be able to independently alter, add or delete specific records.
- A student will be able to independently manipulate field and table definitions using SQL-scripts and/or the terminal.
- A student will be able to access and use data contained in a sqlite database using a python script.
Content
By themselves, data have little or no information content. Only by placing a datum in a certain context, or by combining it with other data, can information be generated. In the stone age of information sciences, data were stored in files, which reflected the required information. Due to its dependence on inflexible file structures, this approach proved to be quite cumbersome to work with. When relational databases were invented, which allow researchers to flexibly recombine data, they became the de facto standard to the extent that the term 'database' often is used as a synonym for 'relational database'.
In this course basic usage of SQL, the programming language used to access and manipulate relational databases, will be explained.
In this course basic usage of SQL, the programming language used to access and manipulate relational databases, will be explained.
Included in programme(s)
School(s)
- Institute for Life Science & Technology