CS 245 Databases

Prerequisites: working knowledge of basic discrete mathematics e.g., sets, functions and relations) and programming skills. Database design and use of database management systems for applications. The relational model, relational algebra and SQL, the standard language for creating, querying and modifying relational and object-relational databases. XML data including the query languages XPath and XQuery. UML database design and relational design principles based on functional dependencies and normal forms. Other topics include indexes, views, transactions, authorization, integrity constraints and triggers. Advanced topics from data warehousing, data mining, Web data management, Datalog, data integration, data streams and continuous queries and data-intensive Web services.