🗄️ Database
Database Learning Path: Beginner to Advanced
A structured database roadmap from indexing and query basics to replication, partitioning, and schema-safe operations.
Tag Archive
#sql
This tag currently appears in 5 posts. Following adjacent tags and category signals usually makes the topic easier to understand from multiple angles.
Expand The Topic
Tags that often appear together
🗄️ Database
A Practical Database Index Design Playbook
A production-oriented playbook for index design that covers read/write tradeoffs, composite indexes, covering indexes, cardinality, execution plans, anti-patterns, and an operational review workflow.
🗄️ Database
A Practical Guide to PostgreSQL
A production-focused guide to PostgreSQL that explains why its real strength is not feature count but the ability to combine relational rigor, analytical SQL, and operational discipline in one system.
🗄️ Database
A Practical Guide to SQL Performance Optimization
A production-focused guide to SQL tuning that treats performance as a workload problem. Learn how to read plans, reduce data access, tune indexes honestly, and avoid premature query heroics.
🗄️ Database
Oracle vs. MySQL Differences — Syntax, Functions, and Sequences
This post summarizes the main syntax and feature differences you need to know when migrating from Oracle to MySQL, or from MySQL to Oracle, with practical query examples.