Databases: OLAP and Recursion
Course Features
Duration
2 weeks
Delivery Method
Online
Available on
Limited Access
Accessibility
Mobile, Desktop, Laptop
Language
English
Subtitles
English
Level
Beginner
Effort
10 hours per week
Teaching Type
Self Paced
Course Description
Course Overview
International Faculty
Post Course Interactions
Instructor-Moderated Discussions
Skills You Will Gain
What You Will Learn
An introduction to the XSLT rule-based language for querying and transforming XML data
Authorization in relational databases
Comprehensive coverage of SQL, the long-accepted standard query language for relational database management systems
Creating indexes for increased query performance
Database constraints: key, referential integrity, and "check" constraints
Database triggers
Dependency theory and normal forms in relational databases as the basis of schema design
How views are created, used, and updated in relational databases
Introduction to the relational model and concepts in relational databases and relational database management systems
Relational algebra – the algebraic query language that provides the formal foundations of SQL
Star schemas, the data cube concept, and On-Line Analytical Processing (OLAP) features in relational databases including the Cube and Rollup operators
The JSON model for human-readable structured or semistructured data
The SQL standard for queries over recursively-defined relations
The XML model for semistructured and self-describing data, including DTDs and some features of XML Schema
The XPath language for processing XML data, and many features of the more advanced XQuery language
The data-modeling component of the Unified Modeling Language (UML), how UML diagrams are translated to relations
Using transactions for concurrency control and failure recovery
Course Instructors