Unless otherwise indicated, a grade of C or higher is required for all prerequisite courses.
This course covers database design and the use of database management systems. It includes an introduction to the relational model, relational algebra, and SQL. It also covers XML data including DTDs and XML Schema for validation, and an introduction to the query and transformation languages XPath, XQuery, and XSLT. The course includes relational design principles based on dependencies and normal forms. Additional database topics introduced are indexes, views, transactions, authorization, integrity constraints, triggers, on-line analytical processing (OLAP), and emerging NoSQL (Not only SQL) databases for cloud and desktop computing.