User:StanfordPioneers

From Wikibooks, open books for an open world
Jump to navigation Jump to search

Student FAQ - db-class.org (Introduction to Databases)[edit | edit source]

This FAQ is maintained by and for students of db-class: Introduction to Databases, taught by Stanford Professor Jennifer Widom, Fall 2011, mirroring the offline Stanford University CS145 class.

To learn more about Professor Widom, you can read this interview with distinguished members of the database community, look her up on wikipedia or visit her home page.


Registration not mandatory. Any edits without registering will record the IP address.

General Tips[edit | edit source]

Q&A Forum[edit | edit source]

  • How to post a clickable link
$$\href{http://en.wikibooks.org/w/index.php?title=User:StanfordPioneers}{Student FAQ}$$

Week 1 - Relational Algebra[edit | edit source]

Tools[edit | edit source]

Advanced topics beyond db-class[edit | edit source]

Week 2 - SQL[edit | edit source]

Tools[edit | edit source]

Week 3 - Relational Design Theory[edit | edit source]

Tools[edit | edit source]

Functional Dependency[edit | edit source]

Inference Rules & Equivalence[edit | edit source]

External References[edit | edit source]

Closure of Attributes & Minimal/Candidate Keys[edit | edit source]

Multivalued Dependency[edit | edit source]

External link


Inference Rules[edit | edit source]

Normalization[edit | edit source]

Beyond db-class[edit | edit source]

Week 4 - Querying XML[edit | edit source]

Tools[edit | edit source]

XPath, XQuery[edit | edit source]

Reading. xquery Book Authors site. Available on Amazon etc.

xpath, xslt. Almost a reference book (XSLT 2.0) Mike Kays book Mike is the W3C rec editor, long time mailing list supporter.

Beyond db-class[edit | edit source]

UML and conversion to DB model[edit | edit source]

External Resources

Transactions and Isolation Levels[edit | edit source]

Phantom Tuples