relational-databases
Teaching Materials for the "Relational Database Course" taught at the HFTM
Science Score: 44.0%
This score indicates how likely this project is to be science-related based on various indicators:
-
✓CITATION.cff file
Found CITATION.cff file -
✓codemeta.json file
Found codemeta.json file -
✓.zenodo.json file
Found .zenodo.json file -
○DOI references
-
○Academic publication links
-
○Committers with academic emails
-
○Institutional organization owner
-
○JOSS paper metadata
-
○Scientific vocabulary similarity
Low similarity (11.1%) to scientific vocabulary
Keywords
Repository
Teaching Materials for the "Relational Database Course" taught at the HFTM
Basic Info
- Host: GitHub
- Owner: erhardtconsulting
- License: cc-by-sa-4.0
- Language: CSS
- Default Branch: main
- Homepage: https://relational-databases.erhardt.consulting/
- Size: 2.13 MB
Statistics
- Stars: 4
- Watchers: 0
- Forks: 0
- Open Issues: 4
- Releases: 0
Topics
Metadata Files
README.md
Relational Database Course
This repository contains all materials for the "Relational Database Course" taught to IT students at HFTM (Höhere Fachschule für Technik Mittelland).
Language Notice
Please note: While this README is in English, all course materials, documentation, and slides are provided in German.
About the Course
This course provides comprehensive knowledge about relational databases, covering topics such as:
- History and evolution of database systems
- Relational database concepts and theory
- SQL (Structured Query Language)
- Database design and normalization
- Performance optimization
- Modern database trends
- Working with PostgreSQL
Access
You can access the course materials online:
You are free to use these materials under the CC-BY-SA 4.0 License.
Purpose
This repository serves as:
- A living document that evolves with the teaching curriculum
- A resource for students during and after the course
- A reference guide for anyone interested in relational databases
Setup and Usage
Technology Stack
This project uses:
- Jupyter Book and MyST for documentation
- Marp for presentation slides
- Pandoc for other documents, like exercises.
Building Documentation
To build and view the documentation:
- Install Poetry (Python dependency management)
- Install dependencies:
poetry install - Build and serve the documentation:
cd docs/ jupyter book build .
Building Slides
To build and view the presentation slides:
- Install NodeJS
- Install dependencies:
npm install - Serve the slides:
npm run slides:serve
Contributing
We welcome contributions to improve and expand these materials:
- Open an Issue for bugs, suggestions, or content improvements
- Submit a Pull Request with proposed changes or additions
License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License (CC-BY-SA).
You are free to: - Share — copy and redistribute the material in any medium or format - Adapt — remix, transform, and build upon the material for any purpose, even commercially
Under the following terms: - Attribution — You must give appropriate credit, provide a link to the license, and indicate if changes were made. - ShareAlike — If you remix, transform, or build upon the material, you must distribute your contributions under the same license as the original.
Owner
- Name: erhardt consulting GmbH
- Login: erhardtconsulting
- Kind: organization
- Location: Switzerland
- Repositories: 1
- Profile: https://github.com/erhardtconsulting
Citation (citation_guide.md)
# Citation Guide for Database History Files
This guide shows how to update references in your markdown files using MyST MD citation syntax.
All references are stored in `docs/references.bib` as BibTex.
## MyST MD Citation Syntax
To cite a reference in your text, use the following syntax:
```
{cite}`citation_key`
```
Then add your key to `docs/references.bib` as BibTex.
For example:
- `{cite}`dataversity_history`` will render as a citation to the DATAVERSITY source
- `{cite}`twobithistory_ims`` will render as a citation to the Two-Bit History article
This will automatically generate a formatted bibliography from all cited references in your document.
GitHub Events
Total
- Create event: 24
- Commit comment event: 1
- Issues event: 2
- Watch event: 4
- Delete event: 26
- Issue comment event: 3
- Public event: 1
- Push event: 122
- Pull request event: 54
Last Year
- Create event: 24
- Commit comment event: 1
- Issues event: 2
- Watch event: 4
- Delete event: 26
- Issue comment event: 3
- Public event: 1
- Push event: 122
- Pull request event: 54
Committers
Last synced: 5 months ago
Top Committers
| Name | Commits | |
|---|---|---|
| Simon Erhardt | h****o@r****h | 78 |
| Erhardt Consulting Bot | 1****t | 31 |
Committer Domains (Top 20 + Academic)
Issues and Pull Requests
Last synced: 5 months ago
All Time
- Total issues: 1
- Total pull requests: 30
- Average time to close issues: N/A
- Average time to close pull requests: about 7 hours
- Total issue authors: 1
- Total pull request authors: 1
- Average comments per issue: 0.0
- Average comments per pull request: 0.0
- Merged pull requests: 28
- Bot issues: 0
- Bot pull requests: 0
Past Year
- Issues: 1
- Pull requests: 30
- Average time to close issues: N/A
- Average time to close pull requests: about 7 hours
- Issue authors: 1
- Pull request authors: 1
- Average comments per issue: 0.0
- Average comments per pull request: 0.0
- Merged pull requests: 28
- Bot issues: 0
- Bot pull requests: 0
Top Authors
Issue Authors
- erhardt-consulting-bot (2)
Pull Request Authors
- erhardt-consulting-bot (61)