ToolUniversal

Mysql

Universal interview questions — applies across Java, Python, Go, and every track that uses Mysql.

Beginner

Intermediate

See Mysql in context

ToolUniversal

Mysql

Universal interview questions — applies across Java, Python, Go, and every track that uses Mysql.

Beginner

Intermediate

See Mysql in context

Beginner

SQL Databases Fundamentals

Intermediate

Database Normalization Forms Explained

SQL vs NoSQL: When to Use Each

Modeling Many-to-Many Relationships in Databases

Database Normalization — 1NF, 2NF, 3NF, and When to Denormalize

SQL Joins — INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF Joins

SQL Subqueries vs Joins — Performance and When to Use Each

ACID Properties — Atomicity, Consistency, Isolation, Durability

Transaction Isolation Levels — Read Uncommitted to Serializable

MySQL Transaction Isolation Levels

InnoDB Locking: Row Lock, Gap Lock, and Next-Key Lock

Optimistic vs Pessimistic Locking — Patterns, Trade-offs, JPA Implementation

Database Connection Pooling Explained

Spring Boot + MySQL Connection Pool Tuning

Database Indexes: How They Work and What Types Exist

Database Indexes — B-Tree, Hash, Composite, and Covering Indexes

MySQL Index Types: B-tree, Full-text, and Composite

SQL EXPLAIN Plan — Reading and Optimizing Query Execution Plans

Using EXPLAIN to Optimize MySQL Queries

MySQL Query Cache and Query Optimization

Zero-Downtime DB Migrations: Flyway, Liquibase, Expand–Contract

SQL Window Functions — ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD

SQL CTEs and Recursive Queries — WITH Clause, Recursion, and Performance

Database Sharding: What It Is and When to Use It

Partitioning in MySQL

MySQL Replication: Primary-Replica Setup

PostgreSQL Streaming vs Logical Replication

Postgres Backup & Recovery Strategy

Postgres vs MySQL vs Aurora vs CockroachDB

OLTP vs OLAP: Understanding the Two Database Workload Types

Designing Databases for High Read Throughput

Soft Deletes in Database Design

Eventual Consistency: What It Is and How to Design for It

InnoDB vs MyISAM Storage Engines

See Mysql in context

Beginner

SQL Databases Fundamentals

Intermediate

Database Normalization Forms Explained

SQL vs NoSQL: When to Use Each

Modeling Many-to-Many Relationships in Databases

Database Normalization — 1NF, 2NF, 3NF, and When to Denormalize

SQL Joins — INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF Joins

SQL Subqueries vs Joins — Performance and When to Use Each

ACID Properties — Atomicity, Consistency, Isolation, Durability

Transaction Isolation Levels — Read Uncommitted to Serializable

MySQL Transaction Isolation Levels

InnoDB Locking: Row Lock, Gap Lock, and Next-Key Lock

Optimistic vs Pessimistic Locking — Patterns, Trade-offs, JPA Implementation

Database Connection Pooling Explained

Spring Boot + MySQL Connection Pool Tuning

Database Indexes: How They Work and What Types Exist

Database Indexes — B-Tree, Hash, Composite, and Covering Indexes

MySQL Index Types: B-tree, Full-text, and Composite

SQL EXPLAIN Plan — Reading and Optimizing Query Execution Plans

Using EXPLAIN to Optimize MySQL Queries

MySQL Query Cache and Query Optimization

Zero-Downtime DB Migrations: Flyway, Liquibase, Expand–Contract

SQL Window Functions — ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD

SQL CTEs and Recursive Queries — WITH Clause, Recursion, and Performance

Database Sharding: What It Is and When to Use It

Partitioning in MySQL

MySQL Replication: Primary-Replica Setup

PostgreSQL Streaming vs Logical Replication

Postgres Backup & Recovery Strategy

Postgres vs MySQL vs Aurora vs CockroachDB

OLTP vs OLAP: Understanding the Two Database Workload Types

Designing Databases for High Read Throughput

Soft Deletes in Database Design

Eventual Consistency: What It Is and How to Design for It

InnoDB vs MyISAM Storage Engines

See Mysql in context