Part VI. Databases

Table of Contents
33. Introduction
Tools Installation, etc
Fundamental Database Design Principles
34. Semantic Modelling I
References for this Lesson
Semantic Data Modelling
Demo of Dia
Assignments DB.1
35. Semantic Modelling II. Relational Model. SQL
References for this Lesson
Last Lesson's Assignments
Semantic Data Modelling II
The Relational Model
SQL
Assignments DB.2
36. Normalization, SQL Schema, ER2RM
References for this Lesson
Last Lesson's Assignments
Normalization ((elaborate))
SQL Schema
ER2RM aka Mapping
Assignments DB.3
37. SQL Data
References for this Lesson
Last Lesson's Assignments
SQL Data
SQL Data II
Assignments SQL Data I
Assignments SQL Data II
38. Views, Complex SQL DATA
References for this Lesson
Last Lesson's Assignments
SQL Data III
SQL Data - Relational Algebra
MySQL 5.0 Views, Intro
Assignments SQL Data III
Assignments SQL Views (SQL Data)
39. Stored Procedures I
References for this Lesson
Last Lesson's Assignments
Stored Procedures
Assignments SQL Stored Procedures
40. Triggers
References for this Lesson
Last Lesson's Assignments
Assignments SQL Triggers
41. Stored Procedures II, PHP, SQL Recursion, etc
References for this Lesson
Last Lesson's Assignments
Stored Procedures II
Stored Procedures, PDO and PHP
Traversing Trees, Recursion in SQL
Assignments Stored Procedures
42. Functions, Practice
References for this Lesson
Last Lesson's Assignments
Persistent Stored Modules, Functions
Assignments SQL Functions
43. XML, XML and XSD
Last Lesson's Assignments
Todays Topics
44. Extra: Project Reporting
Project Reporting, Project Work
45. NoSQL Database Systems
References for this Lesson
NoSQL Database Systems
NoSQL and All That
MongoDB, a NoSQL Document Type Database
MongoDB from PHP
Assignments NoSQL 0