1× knowledge

SQL / Subject

Intermediate

Build intermediate SQL skills with joins, set operations, subqueries, conditional expressions, functions, dates, views, indexes, data modeling, normalization and transactions.

Your Progress

Learning Summary

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

Suggested sequence

Learning roadmap

Topics follow the Admin display order

Intermediate

127 topics
  1. Introduction to Joins
  2. INNER JOIN
  3. LEFT JOIN
  4. RIGHT JOIN
  5. FULL OUTER JOIN
  6. CROSS JOIN
  7. SELF JOIN
  8. Natural Join
  9. Equi Join
  10. Non-Equi Join
  11. Multiple Table Joins
  12. Joining Three or More Tables
  13. UNION
  14. UNION ALL
  15. INTERSECT
  16. EXCEPT
  17. MINUS
  18. Introduction to Subqueries
  19. Single-Row Subqueries
  20. Multiple-Row Subqueries
  21. Multiple-Column Subqueries
  22. Nested Subqueries
  23. Correlated Subqueries
  24. Scalar Subqueries
  25. Subqueries in SELECT
  26. Subqueries in WHERE
  27. Subqueries in FROM
  28. EXISTS Subqueries
  29. NOT EXISTS Subqueries
  30. CASE
  31. Simple CASE
  32. Searched CASE
  33. Nested CASE
  34. COALESCE
  35. NULLIF
  36. IFNULL
  37. ISNULL
  38. NVL
  39. CONCAT
  40. CONCAT_WS
  41. SUBSTRING
  42. SUBSTR
  43. LENGTH
  44. CHAR_LENGTH
  45. LOWER
  46. UPPER
  47. TRIM
  48. LTRIM
  49. RTRIM
  50. REPLACE
  51. REVERSE
  52. LEFT
  53. RIGHT
  54. POSITION
  55. INSTR
  56. LOCATE
  57. ABS
  58. CEIL
  59. CEILING
  60. FLOOR
  61. ROUND
  62. TRUNCATE
  63. MOD
  64. POWER
  65. SQRT
  66. RANDOM
  67. RAND
  68. Current Date
  69. Current Time
  70. Current Timestamp
  71. Date Extraction
  72. Date Addition
  73. Date Subtraction
  74. Date Difference
  75. Date Formatting
  76. Date Parsing
  77. Time Zones
  78. Date Comparisons
  79. CAST
  80. CONVERT
  81. Type Conversion
  82. Implicit Conversion
  83. Explicit Conversion
  84. Introduction to Views
  85. Creating Views
  86. Updating Views
  87. Replacing Views
  88. Dropping Views
  89. Simple Views
  90. Complex Views
  91. Updatable Views
  92. Read-Only Views
  93. Introduction to Indexes
  94. Creating Indexes
  95. Dropping Indexes
  96. Unique Indexes
  97. Composite Indexes
  98. Clustered Indexes
  99. Non-Clustered Indexes
  100. Index Selection
  101. Database Modeling
  102. Entity Relationship Model
  103. ER Diagrams
  104. Entities
  105. Attributes
  106. Relationships
  107. Cardinality
  108. Participation Constraints
  109. Logical Database Design
  110. Physical Database Design
  111. Database Normalization
  112. Functional Dependencies
  113. First Normal Form
  114. Second Normal Form
  115. Third Normal Form
  116. Boyce-Codd Normal Form
  117. Fourth Normal Form
  118. Fifth Normal Form
  119. Denormalization
  120. Transactions
  121. ACID Properties
  122. COMMIT
  123. ROLLBACK
  124. SAVEPOINT
  125. Transaction States
  126. Transaction Isolation
  127. Autocommit

Topics

127 published topics

  1. 21 Multiple-Column SubqueriesLearn Multiple-Column Subqueries through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  2. 22 Nested SubqueriesLearn Nested Subqueries through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  3. 23 Correlated SubqueriesLearn Correlated Subqueries through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  4. 24 Scalar SubqueriesLearn Scalar Subqueries through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  5. 25 Subqueries in SELECTLearn Subqueries in SELECT through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  6. 26 Subqueries in WHERELearn Subqueries in WHERE through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  7. 27 Subqueries in FROMLearn Subqueries in FROM through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  8. 28 EXISTS SubqueriesLearn EXISTS Subqueries through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  9. 29 NOT EXISTS SubqueriesLearn NOT EXISTS Subqueries through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  10. 30 CASELearn CASE through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  11. 31 Simple CASELearn Simple CASE through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  12. 32 Searched CASELearn Searched CASE through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  13. 33 Nested CASELearn Nested CASE through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  14. 34 COALESCELearn COALESCE through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  15. 35 NULLIFLearn NULLIF through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  16. 36 IFNULLLearn IFNULL through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  17. 37 ISNULLLearn ISNULL through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  18. 38 NVLLearn NVL through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  19. 39 CONCATLearn CONCAT through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  20. 40 CONCAT_WSLearn CONCAT_WS through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning