Topics
0 Syllabus and Course Pack
1 Foundations: Primitive Data, Logic, Sets, and Relations
-
Primitive data
-
Logic, sets, and relations
2 Relational Databases: SQL
3 Relational Database Design
4 Relational Databases: Application Development and Transactions
5 Midterm Review and Exam
8 Styling and Transforming XML
9 Parsing, Processing, and Querying XML
11 Final Review and Exam
-
Revised
Study Guide
(PDF) -- version 4.2, revised 2013 Apr 20
Reference
Theme Song
-
Chopin Valse in C# Minor, Op. 64 No. 2
-- Yuja Wang, piano
- Previous theme song:
Tschaikovsky's Swan Lake, beginning of Act II:
Textbooks for spring 2013
-
1. Coursepack (PDF)
-
2. Michael Morrison,
Sams Teach Yourself XML in 24 Hours.
Sams Publishing, 2006. ISBN 0-672-32797-X.
Other Software
-
Prolog/Datalog
-
PostgreSQL
-
Downloads
for various operating systems, Live CDs, etc.
-
Documentation
— note that we are using version 8.4.13 on merlin,
so the manuals for 8.4 (8.4.15) would be the closest match.
- On merlin you can also view
documentation with the command
'evince /usr/share/doc/postgresql-docs-8.4.13/postgresql-8.4.13-US.pdf' (18 MB PDF file),
or by browsing
file:///usr/share/doc/postgresql-8.4.13/html/index.html
-
Comparisons of SQL dialects (with each other and
with the SQL:2008 standard)
-
Dia
(diagram editor). The Dia Manual can be read online
through the Dia Help menu; you can also find the online
documentation
in the file system at /usr/share/gnome/help/dia/en/index.html
-
JDBC Tutorial
- Weka
data mining toolkit
-
SQuirreL SQL universal SQL client
-
iSQL Independent SQL Tool
-
MonetDB
-
Oracle Berkely DB
-
XML Resources
-
More database links
-
Object-relational and object-oriented databases
