Databases
Follow the Databases learning paths and articles in a structured order.
7 learning paths • 301 articles
01Cassandra Introduction02Architecture03Ring04Nodes05Keyspaces06Tables07CQL08CRUD09Primary Key10Partition Key11Clustering Key12Data Modeling13Replication14Consistency Levels15Hinted Handoff16Gossip17SSTables18Compaction19Bloom Filters20MemTables21Repair22Nodetool23Backup24Restore25Security26Authentication27Monitoring28Performance29Spring Boot30Reactive31Kafka32Spark33Docker34Kubernetes35AWS36Azure37IoT38Time Series39Event Logging40Scalability41Migration42Troubleshooting43Testing44Enterprise Patterns45Banking46Telecom47Healthcare48Best Practices49Production50Architecture
01What Is A Database02Database Types03RDBMS Vs NoSQL04ACID Properties05BASE Consistency06CAP Theorem07Database Architecture08Primary Key Vs Foreign Key09Normalization10Denormalization11Indexes12Clustered Vs NonClustered Indexes13Execution Plans14Transactions15Locking16Isolation Levels17Deadlocks18Optimistic Vs Pessimistic Locking19Database Replication20Sharding21Partitioning22Backup And Recovery23Database Migrations24Connection Pooling25Read Replica26High Availability27Failover28Disaster Recovery29Materialized Views30Stored Procedures31Triggers32Sequences33Database Security34Encryption35Auditing36Performance Tuning37Database Monitoring38Scaling Databases39Cloud Databases40Enterprise Best Practices
01MongoDB Introduction02Installation03Collections04Documents05CRUD06Data Modeling07Embedding Vs Referencing08Indexes09Compound Indexes10Text Indexes11TTL Indexes12Aggregation13Pipeline14Lookup15Unwind16Transactions17Replica Sets18Sharding19Atlas20Backup21Restore22Change Streams23GridFS24Schema Validation25Security26Roles27Authentication28Monitoring29Performance30Explain31Spring Data Mongo32Reactive Mongo33Docker34Kubernetes35AWS36Azure37Event Sourcing38CQRS39Caching40Logging41E Commerce Use Cases42Healthcare Use Cases43IoT Use Cases44AI Applications45Migration46Testing47Best Practices48Production49Troubleshooting50Enterprise Architecture
01Oracle Introduction02Oracle Architecture03Tablespaces04Users And Schemas05Tables06Indexes07Sequences08Synonyms09Views10Materialized Views11PLSQL12Stored Procedures13Functions14Packages15Triggers16Cursors17Bulk Collect18FORALL19Transactions20Locking21Isolation22Partitioning23Parallel Execution24Execution Plans25Hints26Performance Tuning27AWR Reports28ASH29RMAN30Backup And Recovery31Flashback32DataGuard33GoldenGate34RAC35ASM36Security37Transparent Data Encryption38Auditing39Enterprise Manager40Spring Boot41JPA42OCI43AWS RDS Oracle44Docker45Kubernetes46Migration47Enterprise Patterns48Banking Use Cases49Insurance Use Cases50Production Best Practices
01PostgreSQL Introduction02Installation03Database And Schema04Data Types05Tables06CRUD07Constraints08Indexes09Composite Indexes10JSONB11Arrays12UUID13Views14Materialized Views15Functions16Procedures17Triggers18Transactions19Locking20Isolation Levels21Partitioning22Inheritance23Full Text Search24Extensions25PGVector26PostGIS27Replication28Streaming Replication29Logical Replication30Backup31Restore32Performance Tuning33VACUUM34ANALYZE35Explain Analyze36Connection Pooling37PgBouncer38Authentication39Roles40Permissions41Auditing42Monitoring43Spring Boot Integration44JPA With Postgres45Flyway46Liquibase47Docker48Kubernetes49AWS RDS50Production Best Practices
01Redis Introduction02Installation03Strings04Hashes05Lists06Sets07Sorted Sets08Bitmaps09HyperLogLog10Geospatial11Streams12PubSub13Transactions14Lua Scripting15Persistence16RDB17AOF18Eviction Policies19TTL20Replication21Sentinel22Redis Cluster23Performance24Monitoring25Security26Spring Cache27Spring Boot28Distributed Lock29Rate Limiter30Session Management31Leaderboards32Caching Patterns33Cache Aside34Write Through35Write Behind36Read Through37Kafka38Docker39Kubernetes40AWS ElastiCache41Azure Redis42Production43Best Practices44Troubleshooting45Enterprise Architecture