Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Explore advanced database system concepts through this comprehensive university-level course covering modern OLAP systems, query processing, and cutting-edge database technologies. Master data formats and encoding techniques, delve into vectorized query execution using SIMD instructions, and understand JIT compilation for database queries. Learn parallel processing strategies including hash join algorithms and multi-way join optimizations, while examining query scheduling, coordination, and user-defined function optimizations. Investigate database networking protocols and gain deep insights into query optimizer implementation across multiple sessions. Study real-world systems through detailed examinations of Google BigQuery/Dremel architecture, Databricks Photon and Spark SQL, Snowflake's data warehouse internals, DuckDB's embedded approach, Yellowbrick's specialized system, and Amazon Redshift's cloud-native design. Develop expertise in modern database internals, performance optimization techniques, and the architectural decisions behind leading commercial and open-source database systems used in production environments today.
