1× knowledge

SQL / Subject

Advanced

Master advanced SQL through CTEs, window analytics, routines, triggers, concurrency control, execution plans, indexing, partitioning, security, auditing and recovery.

Your Progress

Learning Summary

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

Suggested sequence

Learning roadmap

Topics follow the Admin display order

Advanced

144 topics
  1. Common Table Expressions
  2. CTEs
  3. Recursive CTEs
  4. Hierarchical Queries
  5. Derived Tables
  6. Lateral Joins
  7. APPLY Operators
  8. Pivot Queries
  9. Unpivot Queries
  10. Dynamic SQL
  11. Conditional Aggregation
  12. Window Functions
  13. OVER Clause
  14. PARTITION BY
  15. Window ORDER BY
  16. ROW_NUMBER()
  17. RANK()
  18. DENSE_RANK()
  19. NTILE()
  20. LAG()
  21. LEAD()
  22. FIRST_VALUE()
  23. LAST_VALUE()
  24. Cumulative Aggregation
  25. Running Totals
  26. Moving Averages
  27. Window Frames
  28. ROWS
  29. RANGE
  30. Stored Procedures
  31. Creating Procedures
  32. Procedure Parameters
  33. Input Parameters
  34. Output Parameters
  35. Calling Procedures
  36. Altering Procedures
  37. Dropping Procedures
  38. Procedure Error Handling
  39. User-Defined Functions
  40. Scalar Functions
  41. Table-Valued Functions
  42. Function Parameters
  43. Function Return Values
  44. Database Triggers
  45. BEFORE Triggers
  46. AFTER Triggers
  47. INSTEAD OF Triggers
  48. INSERT Triggers
  49. UPDATE Triggers
  50. DELETE Triggers
  51. Row-Level Triggers
  52. Statement-Level Triggers
  53. Trigger Management
  54. SQL Cursors
  55. Declaring Cursors
  56. Opening Cursors
  57. Fetching Data
  58. Closing Cursors
  59. Cursor Loops
  60. Cursor Performance
  61. SQL Errors
  62. Exception Handling
  63. TRY/CATCH
  64. Error Codes
  65. Custom Errors
  66. Transaction Error Handling
  67. Isolation Levels
  68. Read Uncommitted
  69. Read Committed
  70. Repeatable Read
  71. Serializable
  72. Snapshot Isolation
  73. Dirty Reads
  74. Non-Repeatable Reads
  75. Phantom Reads
  76. Lost Updates
  77. Deadlocks
  78. Locking
  79. Optimistic Concurrency
  80. Pessimistic Concurrency
  81. Query Execution
  82. Query Execution Plans
  83. Query Optimizer
  84. Cost-Based Optimization
  85. Rule-Based Optimization
  86. EXPLAIN
  87. EXPLAIN ANALYZE
  88. Full Table Scans
  89. Index Scans
  90. Index Seeks
  91. Join Algorithms
  92. Nested Loop Join
  93. Hash Join
  94. Merge Join
  95. Query Rewriting
  96. Predicate Pushdown
  97. Cardinality Estimation
  98. Statistics
  99. Query Performance Analysis
  100. B-Tree Indexes
  101. B+ Tree Indexes
  102. Hash Indexes
  103. Bitmap Indexes
  104. Full-Text Indexes
  105. Partial Indexes
  106. Filtered Indexes
  107. Covering Indexes
  108. Function-Based Indexes
  109. Expression Indexes
  110. Index Selectivity
  111. Index Cardinality
  112. Index Fragmentation
  113. Index Maintenance
  114. Table Partitioning
  115. Horizontal Partitioning
  116. Vertical Partitioning
  117. Range Partitioning
  118. List Partitioning
  119. Hash Partitioning
  120. Composite Partitioning
  121. Partition Pruning
  122. Database Users
  123. Authentication
  124. Authorization
  125. Roles
  126. Privileges
  127. GRANT
  128. REVOKE
  129. Row-Level Security
  130. Column-Level Security
  131. Data Encryption
  132. SQL Injection
  133. SQL Injection Prevention
  134. Prepared Statements
  135. Parameterized Queries
  136. Database Auditing
  137. Database Backups
  138. Full Backup
  139. Differential Backup
  140. Incremental Backup
  141. Transaction Log Backup
  142. Database Restore
  143. Point-in-Time Recovery
  144. Disaster Recovery

Topics

144 published topics

  1. 81 Query ExecutionLearn Query Execution through a detailed SQL lesson with examples, exercises and practice questions.Advanced · 16 min read · 180 min learning
  2. 82 Query Execution PlansLearn Query Execution Plans through a detailed SQL lesson with examples, exercises and practice questions.Advanced · 16 min read · 180 min learning
  3. 83 Query OptimizerLearn Query Optimizer through a detailed SQL lesson with examples, exercises and practice questions.Advanced · 16 min read · 180 min learning
  4. 84 Cost-Based OptimizationLearn Cost-Based Optimization through a detailed SQL lesson with examples, exercises and practice questions.Advanced · 16 min read · 180 min learning
  5. 85 Rule-Based OptimizationLearn Rule-Based Optimization through a detailed SQL lesson with examples, exercises and practice questions.Advanced · 16 min read · 180 min learning
  6. 86 EXPLAINLearn EXPLAIN through a detailed SQL lesson with examples, exercises and practice questions.Advanced · 16 min read · 180 min learning
  7. 87 EXPLAIN ANALYZELearn EXPLAIN ANALYZE through a detailed SQL lesson with examples, exercises and practice questions.Advanced · 16 min read · 180 min learning
  8. 88 Full Table ScansLearn Full Table Scans through a detailed SQL lesson with examples, exercises and practice questions.Advanced · 16 min read · 180 min learning
  9. 89 Index ScansLearn Index Scans through a detailed SQL lesson with examples, exercises and practice questions.Advanced · 16 min read · 180 min learning
  10. 90 Index SeeksLearn Index Seeks through a detailed SQL lesson with examples, exercises and practice questions.Advanced · 16 min read · 180 min learning
  11. 91 Join AlgorithmsLearn Join Algorithms through a detailed SQL lesson with examples, exercises and practice questions.Advanced · 16 min read · 180 min learning
  12. 92 Nested Loop JoinLearn Nested Loop Join through a detailed SQL lesson with examples, exercises and practice questions.Advanced · 16 min read · 180 min learning
  13. 93 Hash JoinLearn Hash Join through a detailed SQL lesson with examples, exercises and practice questions.Advanced · 16 min read · 180 min learning
  14. 94 Merge JoinLearn Merge Join through a detailed SQL lesson with examples, exercises and practice questions.Advanced · 16 min read · 180 min learning
  15. 95 Query RewritingLearn Query Rewriting through a detailed SQL lesson with examples, exercises and practice questions.Advanced · 16 min read · 180 min learning
  16. 96 Predicate PushdownLearn Predicate Pushdown through a detailed SQL lesson with examples, exercises and practice questions.Advanced · 16 min read · 180 min learning
  17. 97 Cardinality EstimationLearn Cardinality Estimation through a detailed SQL lesson with examples, exercises and practice questions.Advanced · 16 min read · 180 min learning
  18. 98 StatisticsLearn Statistics through a detailed SQL lesson with examples, exercises and practice questions.Advanced · 16 min read · 180 min learning
  19. 99 Query Performance AnalysisLearn Query Performance Analysis through a detailed SQL lesson with examples, exercises and practice questions.Advanced · 17 min read · 180 min learning
  20. 100 B-Tree IndexesLearn B-Tree Indexes through a detailed SQL lesson with examples, exercises and practice questions.Advanced · 16 min read · 180 min learning