ArchitectThe first three topics of every volume are live. New topics are added in rounds across all volumes, so the whole path grows evenly.
Database Fundamentals & Relational Data Modeling
1.1 Why Databases ExistPersistent data, structured data, data sharing, concurrent access and durability1.2 Database Management SystemsDBMS, RDBMS, database server and storage engine1.3 Database ArchitectureClient/server, database process, connection, query processing and storageSQL, Transactions, Concurrency & Database Performance
1.1 Data RetrievalSELECT, WHERE, ORDER BY and DISTINCT1.2 Data ModificationINSERT, UPDATE and DELETE1.3 AggregationGROUP BY, HAVING and aggregate functionsJava Persistence & Data Access Architecture
1.1 JDBC ArchitectureDriver, Connection, Statement and ResultSet1.2 PreparedStatementParameter binding, SQL injection protection and performance1.3 JDBC TransactionsAuto-commit, commit and rollbackNoSQL, Caching & Polyglot Persistence
1.1 Why NoSQL ExistsScale, flexible schemas and specialised workloads1.2 CategoriesKey-value, document, wide-column and graph1.3 Trade-offsConsistency, query flexibility, scalability and operational complexityAPI Design, HTTP & REST
1.1 HTTP ArchitectureClient, server, request and response1.2 MethodsGET, POST, PUT, PATCH, DELETE, HEAD and OPTIONS1.3 Status Codes2xx, 3xx, 4xx and 5xxAPI Management, GraphQL & Distributed API Design
1.1 Gateway ResponsibilitiesRouting, authentication, TLS termination and rate limiting1.2 Gateway PatternsRouting, aggregation and transformation1.3 Gateway RisksBottleneck, coupling and centralised failureEnterprise Integration & Messaging
1.1 Why Systems IntegrateData exchange, business processes, legacy integration and external services1.2 Integration StylesFile transfer, shared database, API and messaging1.3 Point-to-Point IntegrationDirect connections, coupling and scaling problemsIntegration Architecture & Data Consistency
1.1 Integration BoundariesSystem boundaries, ownership and contracts1.2 Synchronous vs AsynchronousREST, gRPC and messaging as integration styles1.3 CouplingTemporal, spatial and data coupling between systems
Newsletter
Get new tutorials every week
New ArchitectMind tutorials and interview questions, once a week. No spam, unsubscribe anytime.