Home

This lecture explores working with multiple tables in relational databases, covering relationships, keys, Entity Relationship Diagrams (ERDs), and advanced SQL queries in SQLite.

This lecture note explores the use of non-key column indexes in databases, discussing their benefits, costs, and best practices for implementation.

This lecture note explains the serializable isolation level in database transactions and compares it with the use of SELECT FOR UPDATE for concurrency control.

In this Q&A session, we explore why using a single database connection for multiple clients is problematic and how connection pooling solves these issues.

A lecture note on how indexing works with columns that have duplicate values, covering index selectivity and practical examples.

This lecture explains why databases fetch entire pages instead of individual rows when executing SQL queries, covering variable-sized rows, disk storage limits, and how indexes work.

Learn how databases solve modern data challenges through SQL querying, filtering, and aggregation using SQLite.

A clear explanation of how Repeatable Read and Snapshot Isolation work in databases, focusing on handling data changes during transactions.