1× knowledge

SQL / Subject

Research Level

Explore research-level SQL through database internals, query optimization, concurrency, distributed consensus, replication, analytical systems, cloud databases and emerging database research.

Your Progress

Learning Summary

0 of 162 topics completed
Quizzes Completed 0Best Quiz Score —Current Level Not startedContinue Choose a topic

Suggested sequence

Learning roadmap

Topics follow the Admin display order

Research

162 topics
  1. Database Architecture
  2. Storage Engines
  3. Database Pages
  4. Database Blocks
  5. Record Storage
  6. Buffer Pool
  7. Buffer Management
  8. Disk Management
  9. Write-Ahead Logging
  10. Redo Logs
  11. Undo Logs
  12. Transaction Logs
  13. Checkpoints
  14. Recovery Algorithms
  15. SQL Parsing
  16. Query Compilation
  17. Query Rewriting
  18. Relational Algebra
  19. Relational Calculus
  20. Query Planning
  21. Query Optimization
  22. Physical Query Plans
  23. Join Ordering
  24. Cost Estimation
  25. Cardinality Estimation
  26. Adaptive Query Processing
  27. Parallel Query Processing
  28. Concurrency Control
  29. Two-Phase Locking
  30. Strict Two-Phase Locking
  31. Timestamp Ordering
  32. Optimistic Concurrency Control
  33. Multiversion Concurrency Control
  34. MVCC
  35. Serializable Snapshot Isolation
  36. Deadlock Detection
  37. Deadlock Prevention
  38. Distributed Transactions
  39. Two-Phase Commit
  40. Three-Phase Commit
  41. Distributed Database Systems
  42. Distributed SQL
  43. Data Distribution
  44. Data Fragmentation
  45. Data Replication
  46. Distributed Query Processing
  47. Distributed Transactions
  48. Distributed Consensus
  49. Leader Election
  50. Sharding
  51. Horizontal Sharding
  52. Vertical Sharding
  53. Shard Keys
  54. Rebalancing
  55. Distributed Joins
  56. Database Replication
  57. Primary-Replica Replication
  58. Multi-Primary Replication
  59. Synchronous Replication
  60. Asynchronous Replication
  61. Logical Replication
  62. Physical Replication
  63. Replication Lag
  64. Conflict Resolution
  65. Failover
  66. Database Clustering
  67. Failover
  68. Automatic Failover
  69. Load Balancing
  70. Read Replicas
  71. Database Availability
  72. Fault Tolerance
  73. Disaster Recovery Architecture
  74. High Availability Architecture
  75. Vertical Scaling
  76. Horizontal Scaling
  77. Database Sharding
  78. Connection Pooling
  79. Read Scaling
  80. Write Scaling
  81. Caching
  82. Database Performance Engineering
  83. Data Warehouses
  84. OLTP
  85. OLAP
  86. OLTP vs OLAP
  87. Fact Tables
  88. Dimension Tables
  89. Star Schema
  90. Snowflake Schema
  91. Galaxy Schema
  92. Slowly Changing Dimensions
  93. Data Cubes
  94. Materialized Views
  95. ETL
  96. ELT
  97. Advanced Window Analytics
  98. Cohort Analysis
  99. Funnel Analysis
  100. Retention Analysis
  101. Time-Series Analysis
  102. Statistical SQL
  103. Percentiles
  104. Median Calculations
  105. Rolling Metrics
  106. Ranking Analytics
  107. Temporal Databases
  108. Temporal Tables
  109. System-Versioned Tables
  110. Bi-Temporal Data
  111. Recursive Queries
  112. Graph Queries
  113. JSON Data in SQL
  114. JSON Functions
  115. XML Data in SQL
  116. XML Functions
  117. Arrays
  118. Spatial SQL
  119. Geospatial Data
  120. Full-Text Search
  121. Cloud Databases
  122. Database as a Service
  123. Serverless Databases
  124. Cloud-Native Databases
  125. Distributed SQL Databases
  126. NewSQL
  127. NoSQL vs SQL
  128. Hybrid Databases
  129. Multi-Model Databases
  130. HTAP Systems
  131. Lakehouse Architecture
  132. Data Lakes
  133. Data Federation
  134. Federated Queries
  135. Learned Query Optimization
  136. AI-Assisted Query Optimization
  137. Learned Index Structures
  138. Adaptive Indexing
  139. Autonomous Databases
  140. Self-Tuning Databases
  141. Automatic Index Selection
  142. Automatic Query Rewriting
  143. Approximate Query Processing
  144. Streaming SQL
  145. Incremental View Maintenance
  146. Differential Dataflow
  147. Database Provenance
  148. Privacy-Preserving Databases
  149. Differential Privacy in Databases
  150. Encrypted Query Processing
  151. Secure Multi-Party Database Queries
  152. Blockchain Databases
  153. Vector Databases and SQL
  154. Vector Search Extensions
  155. SQL for Machine Learning
  156. In-Database Machine Learning
  157. Hardware-Aware Database Systems
  158. GPU-Accelerated Databases
  159. Persistent-Memory Databases
  160. Database Benchmarking
  161. Transaction Processing Research
  162. Distributed Database Research

Topics

162 published topics

  1. 01 Database ArchitectureLearn Database Architecture through a detailed SQL lesson with examples, exercises and practice questions.Research · 16 min read · 240 min learning
  2. 02 Storage EnginesLearn Storage Engines through a detailed SQL lesson with examples, exercises and practice questions.Research · 17 min read · 240 min learning
  3. 03 Database PagesLearn Database Pages through a detailed SQL lesson with examples, exercises and practice questions.Research · 16 min read · 240 min learning
  4. 04 Database BlocksLearn Database Blocks through a detailed SQL lesson with examples, exercises and practice questions.Research · 16 min read · 240 min learning
  5. 05 Record StorageLearn Record Storage through a detailed SQL lesson with examples, exercises and practice questions.Research · 16 min read · 240 min learning
  6. 06 Buffer PoolLearn Buffer Pool through a detailed SQL lesson with examples, exercises and practice questions.Research · 16 min read · 240 min learning
  7. 07 Buffer ManagementLearn Buffer Management through a detailed SQL lesson with examples, exercises and practice questions.Research · 17 min read · 240 min learning
  8. 08 Disk ManagementLearn Disk Management through a detailed SQL lesson with examples, exercises and practice questions.Research · 17 min read · 240 min learning
  9. 09 Write-Ahead LoggingLearn Write-Ahead Logging through a detailed SQL lesson with examples, exercises and practice questions.Research · 17 min read · 240 min learning
  10. 10 Redo LogsLearn Redo Logs through a detailed SQL lesson with examples, exercises and practice questions.Research · 17 min read · 240 min learning
  11. 11 Undo LogsLearn Undo Logs through a detailed SQL lesson with examples, exercises and practice questions.Research · 17 min read · 240 min learning
  12. 12 Transaction LogsLearn Transaction Logs through a detailed SQL lesson with examples, exercises and practice questions.Research · 16 min read · 240 min learning
  13. 13 CheckpointsLearn Checkpoints through a detailed SQL lesson with examples, exercises and practice questions.Research · 16 min read · 240 min learning
  14. 14 Recovery AlgorithmsLearn Recovery Algorithms through a detailed SQL lesson with examples, exercises and practice questions.Research · 16 min read · 240 min learning
  15. 15 SQL ParsingLearn SQL Parsing through a detailed SQL lesson with examples, exercises and practice questions.Research · 17 min read · 240 min learning
  16. 16 Query CompilationLearn Query Compilation through a detailed SQL lesson with examples, exercises and practice questions.Research · 17 min read · 240 min learning
  17. 17 Query RewritingLearn Query Rewriting through a detailed SQL lesson with examples, exercises and practice questions.Research · 16 min read · 240 min learning
  18. 18 Relational AlgebraLearn Relational Algebra through a detailed SQL lesson with examples, exercises and practice questions.Research · 16 min read · 240 min learning
  19. 19 Relational CalculusLearn Relational Calculus through a detailed SQL lesson with examples, exercises and practice questions.Research · 16 min read · 240 min learning
  20. 20 Query PlanningLearn Query Planning through a detailed SQL lesson with examples, exercises and practice questions.Research · 16 min read · 240 min learning