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.
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
Continue with
Spring Boot & Spring CloudBuild, configure, document, test and deploy production-ready services with Spring Boot, Spring Data, Spring Batch and Spring Cloud.11 guides →Software ArchitectureLayered systems, SOA, microservices, DDD, REST and API management, reactive systems, performance, TOGAF and distributed consistency.12 guides →Cloud ComputingCloud fundamentals, AWS and Azure core services, well-architected design, migration strategies, high availability, cloud-native apps and cost control.8 guides →