com presentations: YII UG talk.: slides/mongodb/insert-intro-shell.xml slides/mongodb/insert-intro.xml slides/mongodb/normal-form.xml slides/mongodb/query-side-by-side.xml sql2nosql-yii-ug14.xml

Commit:    581540c6670b79b884c71f35ebdbaa040dae5045
Author:    Derick Rethans <[email protected]>         Tue, 15 Apr 2014 21:04:54 +0100
Parents:   c6d3fad173e2781f1b159447b3792474f5fe23ca
Branches:  master

Link:       http://git.php.net/?p=presentations.git;a=commitdiff;h=581540c6670b79b884c71f35ebdbaa040dae5045

Log:
YII UG talk.

Changed paths:
  A  slides/mongodb/insert-intro-shell.xml
  M  slides/mongodb/insert-intro.xml
  M  slides/mongodb/normal-form.xml
  A  slides/mongodb/query-side-by-side.xml
  A  sql2nosql-yii-ug14.xml


Diff:
diff --git a/slides/mongodb/insert-intro-shell.xml b/slides/mongodb/insert-intro-shell.xml
new file mode 100644
index 0000000..9366c46
--- /dev/null
+++ b/slides/mongodb/insert-intro-shell.xml
@@ -0,0 +1,14 @@
+<slide>
+<title>Inserting data</title>
+
+<example>
+db.steps.insert( {
+        person: "derickr",
+        steps_made: {
+                "20140201": 10800,
+        }
+} );
+</example>
+
+<blurb>No schema, and you also don't have to create a database or collection</blurb>
+</slide>
diff --git a/slides/mongodb/insert-intro.xml b/slides/mongodb/insert-intro.xml
index 9366c46..1b0a27c 100644
--- a/slides/mongodb/insert-intro.xml
+++ b/slides/mongodb/insert-intro.xml
@@ -1,13 +1,17 @@
 <slide>
 <title>Inserting data</title>
 
-<example>
-db.steps.insert( {
-        person: "derickr",
-        steps_made: {
-                "20140201": 10800,
-        }
-} );
+<example><![CDATA[
+<?php
+$m = new MongoClient;
+
+$m->dbname->steps->insert( [
+        person => "derickr",
+        steps_made: [
+                "20140201" => 10800,
+        ]
+] );
+?>]]>
 </example>
 
 <blurb>No schema, and you also don't have to create a database or collection</blurb>
diff --git a/slides/mongodb/normal-form.xml b/slides/mongodb/normal-form.xml
index 1d41417..9917e6e 100644
--- a/slides/mongodb/normal-form.xml
+++ b/slides/mongodb/normal-form.xml
@@ -1,7 +1,6 @@
 <slide>
 <title>Normalisation</title>
 
-<div effect="fade-out stop">
 <list>
 <bullet>*1NF*: A relation is in first normal form if the domain of each
 |aaaaaa|attribute contains| |cccccc|only atomic values, and the value of each attribute contains only a single value from that domain.|</bullet>
@@ -9,15 +8,4 @@
 |cccccc|on a proper subset of any candidate key|</bullet>
 <bullet>*3NF*: Every non-prime attribute is non-transitively |aaaaaa|dependent on every| |cccccc|candidate key in the table. The attributes that do not contribute to the description of the primary key are removed from the table. In other words, no transitive dependency is allowed.|</bullet>
 </list>
-</div>
-<div effect="fade-in">
-<list>
-<bullet>*EKNF*: Elementary Key Normal Form</bullet>
-<bullet>*BCNF*: Boyce–Codd normal form</bullet>
-<bullet>*4NF*: Fourth normal form</bullet>
-<bullet>*5NF*: Fifth normal form</bullet>
-<bullet>*DKNF*: Domain/key normal form</bullet>
-<bullet>*6NF*: Sixth normal form</bullet>
-</list>
-</div>
 </slide>
diff --git a/slides/mongodb/query-side-by-side.xml b/slides/mongodb/query-side-by-side.xml
new file mode 100644
index 0000000..ca0a283
--- /dev/null
+++ b/slides/mongodb/query-side-by-side.xml
@@ -0,0 +1,29 @@
+<slide>
+<title>Querying</title>
+
+<example>
+SELECT * FROM table;
+
+$db->table->find();
+</example>
+<example>
+SELECT foo, bar FROM table;
+
+$db->table->find( [], ['foo', 'bar'] );
+</example>
+<example>
+SELECT * FROM table WHERE a = 42;
+
+$db->table->find( [ 'a' => 42 ] );
+</example>
+<example>
+SELECT * FROM table WHERE a = 'whisky' AND b > 18;
+
+$db->table->find( [ 'a' => 'whisky', 'b' => [ '$gt' => 18 ] ] );
+</example>
+<example>
+SELECT * FROM table1 LEFT JOIN table2 ON (table1.a = table2.b);
+
+???
+</example>
+</slide>
diff --git a/sql2nosql-yii-ug14.xml b/sql2nosql-yii-ug14.xml
new file mode 100644
index 0000000..27adf1e
--- /dev/null
+++ b/sql2nosql-yii-ug14.xml
@@ -0,0 +1,62 @@
+<?xml version="1.0" encoding="utf-8"?>
+<presentation css="10gen-strict.css">
+<topic>mongoDB</topic>
+<title>From SQL to NoSQL</title>
+<event>London Yii PHP Framework Group</event>
+<location>London, UK</location>
+<date>Apr 15th, 2014</date>
+<speaker>Derick Rethans</speaker>
+<email>[email protected]</email>
+<twitter>derickr</twitter>
+<url>http://derickrethans.nl/talks.html</url>
+<joindin>http://derickrethans.nl/talks/sql2nosql-yii-ug14</joindin>
+<slide>slides/mongodb/title.xml</slide>
+
+<!-- DINOSAUR vs PLATIPUS -->
+<slide>slides/mongodb/relational-model.xml</slide>
+<slide>slides/mongodb/dinosaur.xml</slide>
+<slide>slides/mongodb/normal-form.xml</slide>
+<slide>slides/mongodb/normal-form1.xml</slide>
+<slide>slides/mongodb/normal-form2.xml</slide>
+<slide>slides/mongodb/normal-form3.xml</slide>
+
+<!-- DIFFERENT NoSQL -->
+<slide>slides/mongodb/nosql.xml</slide>
+<slide>slides/mongodb/nosql-kv.xml</slide>
+<slide>slides/mongodb/nosql-column.xml</slide>
+<slide>slides/mongodb/nosql-graph.xml</slide>
+<slide>slides/mongodb/nosql-document.xml</slide>
+<slide>slides/mongodb/platipus.xml</slide>
+
+<!-- ACID vs CAP -->
+<slide>slides/mongodb/acid.xml</slide>
+<slide>slides/mongodb/cap.xml</slide>
+
+<!-- A FEW NOTES ON MONGODB -->
+<slide>slides/mongodb/databasefield.xml</slide>
+<slide>slides/mongodb/collections-documents.xml</slide>
+<slide>slides/mongodb/document.xml</slide>
+<slide>slides/mongodb/mongodb-1nf.xml</slide>
+<slide>slides/mongodb/mongodb-3nf.xml</slide>
+<slide>slides/mongodb/insert-intro.xml</slide>
+<slide>slides/mongodb/query-side-by-side.xml</slide>
+<slide>slides/mongodb/update-intro.xml</slide>
+<slide>slides/mongodb/update-atomicity.xml</slide>
+<slide>slides/mongodb/update-consistency.xml</slide>
+
+<slide>slides/mongodb/arbitrary-keys1.xml</slide>
+<slide>slides/mongodb/one-to-many2.xml</slide>
+<slide>slides/mongodb/one-to-many4.xml</slide>
+<slide>slides/mongodb/embed-vs-link.xml</slide>
+
+<!-- REPLICATION -->
+<slide>slides/mongodb/availability.xml</slide>
+<slide>slides/mongodb/repl-features.xml</slide>
+<slide>slides/mongodb/repl-works-normal.xml</slide>
+
+<slide>slides/mongodb/repl-eventual-consistency.xml</slide>
+
+<slide>slides/mongodb/sql2nosql-conclusion.xml</slide>
+<slide>slides/mongodb/resources.xml</slide>
+
+</presentation>