summaryrefslogtreecommitdiff
path: root/doc
diff options
context:
space:
mode:
authorJan Klemkow <j.klemkow@wemelug.de>2013-01-31 00:38:21 +0100
committerJan Klemkow <j.klemkow@wemelug.de>2013-01-31 00:38:52 +0100
commitf909ad06c2a3340bf0668c9be6ea59a779ccb3a8 (patch)
tree8fab1fdf95064bc5988ed0e9bcc7e4dffcb9a7d9 /doc
parenta4c6af433a4be46df7433bf4de3b16d398c73abe (diff)
downloadsqltutor-plugin-f909ad06c2a3340bf0668c9be6ea59a779ccb3a8.tar.gz
sqltutor-plugin-f909ad06c2a3340bf0668c9be6ea59a779ccb3a8.tar.bz2
sqltutor-plugin-f909ad06c2a3340bf0668c9be6ea59a779ccb3a8.zip
add slides
Diffstat (limited to 'doc')
-rw-r--r--doc/presentation.txt46
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 :