Lectures related to MySQL | EPFL Graph Search

Delves into lock-based concurrency control, deadlock handling, transaction models, and their limitations.

Speculative Query Execution: Bottlenecks and Dependencies

Explores speculative query execution for complex queries, addressing bottlenecks, dependencies, and performance prediction.

DBMS Architecture: Query Optimization and Processing Models

Explores DBMS architecture, query optimization, and processing models for efficient query execution.

SQL Client-Server Architecture + IDE

Covers the architecture of a typical DBMS and SQL interfaces like SQL Developer and DataGrip.

Relational Model: Basics

Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.

Quantum Optics I: Stern-Gerlach Experiment

Explores the Stern-Gerlach experiment, strong measurements, cavity quantum electrodynamics, and quantum optomechanics.

SQL Basics: Select Queries

Covers the basic principles of the SQL language and select queries.

Distributed Transactions: 2PC Principles and Replication Strategies

Explores 2PC principles, failure scenarios, and replication strategies in distributed transactions and discusses the transition from ACID to BASE properties in NoSQL systems.

DDL, DML, Views

Covers SQL data definition, manipulation, and views in databases.

Distributed Transactions: Replication Strategies

Explores replication strategies for fault tolerance, load balancing, and eventual consistency in distributed transactions.

Query Processing: Relational Operations and Models

Discusses query processing models and relational operations, focusing on selections, projections, and joins in data-intensive systems.

Data Warehouses and Data Lakes

Covers data warehouses, data lakes, OLTP vs. OLAP, data quality, and the Data Lakehouse concept.

Querying a database: the SQL language

Covers the SQL language for interacting with databases through structured queries, including selecting, filtering, aggregating, and sorting data.

Database Management Systems: Fundamentals

Introduces the fundamentals of database management systems, covering relational model, storage options, data integrity, queries, and data manipulation languages.