Data & Databases

10 guides · about 1 hour of reading

Data outlives applications. This subject covers relational fundamentals that never go out of date — good SQL, normalisation, indexing and reading an execution plan — alongside the choice between Oracle and PostgreSQL, document databases with MongoDB, search with Apache Solr, log analytics with Elasticsearch, Logstash and Kibana, and the big-data and business-intelligence landscape with Hadoop.

Who this is for

  • Backend developers who write SQL
  • Developers picking a database for a new service
  • Analysts and engineers entering data engineering

Learning path

Read in order for a complete course, or pick the topic you need.

  1. 1SQL Best Practices: Writing Queries That Are Correct, Fast and MaintainablePractical SQL habits for application developers: sargable predicates, NULL handling, joins, EXISTS vs IN, bind parameters, keyset pagination and batching.Intermediate10 min read
  2. 2Database Design and Normalization: From Entities to BCNFModel entities, keys and functional dependencies, then work 1NF to BCNF on one example, choose keys, and denormalise deliberately.Beginner8 min read
  3. 3Oracle vs PostgreSQL: Architecture, SQL Dialect and MigrationHow Oracle and PostgreSQL differ in process model, MVCC, SQL dialect, partitioning, HA and licensing — and which to choose for a new system.Intermediate9 min read
  4. 4Indexes and Execution Plans: Making the Optimizer Work for YouB-tree internals, composite column order, covering and partial indexes, statistics, and how to read EXPLAIN ANALYZE output and fix a bad plan.Advanced9 min read
  5. 5MongoDB and the Document Model: Schema Design, Aggregation and ShardingWhen documents beat rows, how to model embedding versus referencing, the aggregation pipeline, index rules, replica sets, sharding and transactions.Intermediate8 min read
  6. 6Apache Solr: Inverted Indexes, Analysis Chains and Relevance TuningHow search differs from a database: inverted indexes, analysers, Solr schema and field types, query parsers, BM25 scoring, faceting and SolrCloud.Intermediate7 min read
  7. 7Centralised Log Management with Elasticsearch, Logstash and KibanaStructured logging, Beats and Elastic Agent, ingest pipelines and grok, index templates, ILM retention, Kibana dashboards and cluster sizing.Intermediate8 min read
  8. 8Big Data Architecture: Lakes, Lakehouses, Formats and ProcessingBatch versus streaming, lake and warehouse and lakehouse, columnar formats, partitioning, open table formats, governance — and when to skip it.Intermediate9 min read
  9. 9The Hadoop Ecosystem: HDFS, YARN, MapReduce, Hive, HBase and SparkHow HDFS stores blocks, how YARN schedules work, why Spark replaced MapReduce, what Hive and HBase are for, and where the ecosystem stands in 2026.Intermediate9 min read
  10. 10Business Intelligence: Dimensional Modelling, ETL and DashboardsOLTP versus OLAP, facts and dimensions, star and snowflake schemas, slowly changing dimensions, ETL versus ELT, semantic layers and KPI design.Beginner9 min read