Open Educational Resource (OER) presentations for selected topics of Computer Science
1. What is this?
These Open Educational Resources (OER) embed resources of the
oer/cs on GitLab. While
source files of that subgroup mostly focus on contents, the
presentations and texts here demonstrate how such source files can be
turned into teaching and learning material with the layout of a
specific university. Feel free to use, share, and adapt those
Presentations make use of the HTML presentation framework reveal.js.
3. HTML documents
- Introduction to functional dependencies and 3NF normalization with synthesis algorithm (that introduction is actually the documentation generated from doctests of this Python package)
- Introduction to the relational model of data (PDF)
- Getting started with PostgreSQL (PDF)
- Use of TPC-H database with PostgreSQL (PDF)
- Introduction to OLAP and ETL (PDF)
- OLAP Optimization (PDF)
- NoSQL and NewSQL (PDF)
- Pointers for data access: Databases, PDI, Scrapy (PDF)
4. Source code and licenses
In the spirit of
Open Educational Resources
(OER), source files, necessary software, and presentations are published in this GitLab repository
under free licenses.
All OER presentations are created from plain text files in a simple text
format called Org Mode (a
lightweight markup language),
focusing on content, while layout is defined separately.
Importantly, the separation of content and layout
simplifies collaboration across organizational boundaries, and the use
of a simple text format enables comparisons of adapted or enhanced
Using the free software emacs-reveal these text files are translated into reveal.js HTML presentations, which can be viewed on (almost) any device with a Web browser. In times of dragnet surveillance and surreptitious as well as blatant data brokerage I recommend the Firefox variant Tor Browser as tool for digital self-defense (here in English and here in German); presentations work for me under the higher-than-default “Safer” security settings in Tor Browser.