On-Line Course: CSEP 544, Winter 2014

Databases are at the heart of modern commercial application development. Data management techniques are used in many other environments and domains where large amounts of data must be stored for efficient update, retrieval, and analysis. This course is a comprehensive discussion of concepts, tools, and techniques in modern data management. It covers advanced SQL, data models and conceptual design, advanced use of views in databases, theory of transactions, XML data, database internals (indexes, query execution and optimization), parallel databases (including Map/Reduce).