diff options
| author | Jan Klemkow <j.klemkow@wemelug.de> | 2013-01-31 00:38:21 +0100 |
|---|---|---|
| committer | Jan Klemkow <j.klemkow@wemelug.de> | 2013-01-31 00:38:52 +0100 |
| commit | f909ad06c2a3340bf0668c9be6ea59a779ccb3a8 (patch) | |
| tree | 8fab1fdf95064bc5988ed0e9bcc7e4dffcb9a7d9 | |
| parent | a4c6af433a4be46df7433bf4de3b16d398c73abe (diff) | |
| download | sqltutor-plugin-f909ad06c2a3340bf0668c9be6ea59a779ccb3a8.tar.gz sqltutor-plugin-f909ad06c2a3340bf0668c9be6ea59a779ccb3a8.tar.bz2 sqltutor-plugin-f909ad06c2a3340bf0668c9be6ea59a779ccb3a8.zip | |
add slides
| -rw-r--r-- | doc/presentation.txt | 46 |
1 files changed, 42 insertions, 4 deletions
diff --git a/doc/presentation.txt b/doc/presentation.txt index 6382533..119d91d 100644 --- a/doc/presentation.txt +++ b/doc/presentation.txt @@ -3,17 +3,51 @@ :lang: de :imagesdir: image -== Ist-Zustand +== IST-Zustand - * Text auf Moodle - * Online-Web-Tutorial mit Oracle + * Datenbank-Lektionen in Moodle + * Online-Web-Tutorial mit Oracle (Nils Weber) -== Benutzertrennung +== Projekt Ziel + + * interaktive SQL-Tests innerhalb von Moodle + * Auswertung des Lernfortschrits + +== Problem: Benutzertrennung image:conflict.svg[] == Transaktionen +[source,sql] +---- +# sqlbox instruction +BEGIN TRANSACTION; + +# User Input: +SELECT * FROM blub; + +# sqlbox instruction +ROLLBACK TRANSACTION; +---- + +== Transaktionen + +[source,sql] +---- +# sqlbox instruction +BEGIN TRANSACTION; + +# User Input: +INSET INTO blub VALUES (1,'foo') +COMMIT TRANSACTION; +BEGIN TRANSACTION; +SELECT * FROM blub; + +# sqlbox instruction +ROLLBACK TRANSACTION; +---- + == Separate Datenbanken image:multi-db.svg[] @@ -22,4 +56,8 @@ image:multi-db.svg[] image:read-only.svg[] +== Demonstration + +Demonstration! + // vim: syntax=asciidoc : |