Part of the Databases series, this is a standalone course; learners seeking to develop an understanding of topics in this course do not need to take other Databases courses. This course covers the JSON and XML standards for semistructured data, along with query languages and schema declaration features for XML. 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.

WHAT YOU WILL LEARN

Databases: Relational Databases and SQL

• Introduction to the relational model and concepts in relational databases and relational database management systems.
• Comprehensive coverage of SQL, the long-accepted standard query language for relational database management systems.

Databases: Advanced Topics in SQL (prerequisite: Relational Databases and SQL)

• Creating indexes for increased query performance.
• Using transactions for concurrency control and failure recovery.
• Database constraints: key, referential integrity, and "check" constraints.
• Database triggers.
• How views are created, used, and updated in relational databases.
• Authorization in relational databases.

Databases: OLAP and Recursion

• Star schemas, the data cube concept, and On-Line Analytical Processing (OLAP) features in relational databases including the Cube and Rollup operators.
• The SQL standard for queries over recursively-defined relations.

Databases: Modeling and Theory

• Relational algebra – the algebraic query language that provides the formal foundations of SQL.
• Dependency theory and normal forms in relational databases as the basis of schema design.
• The data-modeling component of the Unified Modeling Language (UML), how UML diagrams are translated to relations.

Databases: Semistructured Data

• The XML model for semistructured and self-describing data, including DTDs and some features of XML Schema.
• The JSON model for human-readable structured or semistructured data.
• The XPath language for processing XML data, and many features of the more advanced XQuery language.
• An introduction to the XSLT rule-based language for querying and transforming XML data.