This is a very fundamental and wide course about the implementation and design concepts behind database management systems. In Course will cover such topics are data models (relational, document, key/value), storage models (n-ary, decomposition), query languages (SQL, stored procedures), storage architectures (heaps, log-structured), indexing (order preserving trees, hash tables), transaction processing (ACID, concurrency control), recovery (logging, checkpoints), query processing (joins, sorting, aggregation, optimization), and parallel architectures (multi-core, distributed).
Advanced Database Systems:
This is continuous of the first course and will cover more advanced topics about databases such that multi-version concurrency control, detailed talk about join algorithms, and query optimization implementation.
These courses required a lot of time and discipline from the listeners but you will be rewarded with a lot of very useful information about databases. And also Andy Pavlo is a little bit strange but a very impressive guy and very love databases :)
PS: Here is a more than 1000 pages book which Andy recommended.
Ceridan
commented
3 years ago
URL: Intro to Database Systems
This is a very fundamental and wide course about the implementation and design concepts behind database management systems. In Course will cover such topics are data models (relational, document, key/value), storage models (n-ary, decomposition), query languages (SQL, stored procedures), storage architectures (heaps, log-structured), indexing (order preserving trees, hash tables), transaction processing (ACID, concurrency control), recovery (logging, checkpoints), query processing (joins, sorting, aggregation, optimization), and parallel architectures (multi-core, distributed).
Advanced Database Systems: This is continuous of the first course and will cover more advanced topics about databases such that multi-version concurrency control, detailed talk about join algorithms, and query optimization implementation.
These courses required a lot of time and discipline from the listeners but you will be rewarded with a lot of very useful information about databases. And also Andy Pavlo is a little bit strange but a very impressive guy and very love databases :)
PS: Here is a more than 1000 pages book which Andy recommended.