Films · Computer science · Relational databases

Prof. Dr. Dirk Schieborn
AM3 Data Analysis and Machine Learning · Reutlingen University
Lecture film · AM3
A Pot Full of Tables: The Relational Model
Lecture film · AM3
A Pot Full of Tables: The Relational Model

Prof. Dr. Dirk Schieborn
AM3 Data Analysis and Machine Learning · Reutlingen University
A database is a pot full of tables, connected by keys. An index finds one row among 100 million in three steps, and SQL only says what you want to know.
heyprof.app/f/am3-tabellen
More films: Signature · Prof. Dr. Dirk Schieborn
We store questions without any link to you; selected ones appear anonymously as frequent questions.
A Pot Full of Tables: The Relational Model
An explainer film in five chapters, made from a real lecture: why a course on machine learning starts with tables, what relation, attribute and tuple mean, how keys connect tables like joints, how a database finds one row among 100 million in three steps, and why SQL only says what should come out. Pause anywhere and ask.
How a film works on heyprof
Every film here listens. Pause it, ask it questions and let it continue with your own examples.
- PauseTap pause or press the space bar. The film waits right at that moment.
- AskTap “Ask” and type what you want to know. The answer comes inside the film, with picture and voice.
- Steer itTell it what to show, for example “Do this with z = 2 − 3i”. The film sets up the app and works it out.
- Try it yourselfWhile it is paused, drag points and sliders yourself. “Continue” takes you back into the film.
Without an account: five questions per visit. With an account you can also ask by voice.
Comments