Databases

This course covers underlying principles and design considerations related to databases; it can be taken either before or after taking other courses in the Databases series.

• The Relational Algebra section of this course teaches the algebraic query language that provides the formal foundations of SQL.
• The Relational Design Theory section of the course provides comprehensive coverage of dependency theory and normal forms in relational databases, a well-accepted theoretical framework for developing good relational database schemas.
• The Unified Modeling Language section of this course introduces the data-modeling component of UML, and describes how UML diagrams are translated to relational database schemas.
• Introduction to relational databases and comprehensive coverage of SQL
• The Indexes and Transactions section of this course covers two important features of database systems from the application-builder's perspective: indexing for increased performance, and transactions for concurrency control and failure recovery.
• The Constraints and Triggers section of this course explains key, referential integrity, and "check" constraints, followed by comprehensive coverage of database triggers.
• The Views and Authorization section of this course provides extensive coverage of how database views can be created, used, and updated, and introduces standard techniques for authorization in relational databases.
• The XML Data section of this course introduces the XML model for semistructured and self-describing data, including DTDs and some features of XML Schema.
• The JSON Data section of this course introduces the JSON model for human-readable structured or semistructured data.
• The XPath and XQuery section of this course covers the XPath language for processing XML data, along with many features of the more advanced XQuery language.
• The XSLT section of this course provides a general introduction to the XSLT rule-based language for querying and transforming XML data.
• The On-Line Analytical Processing section of this course introduces star schemas, the data cube concept, and OLAP features in relational databases including the Cube and Rollup operators.
• The Recursion section of this course covers the SQL standard for queries over recursively-defined relations.