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. 101 Database ModelingLearn Database Modeling through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  2. 102 Entity Relationship ModelLearn Entity Relationship Model through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  3. 103 ER DiagramsLearn ER Diagrams through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  4. 104 EntitiesLearn Entities through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  5. 105 AttributesLearn Attributes through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  6. 106 RelationshipsLearn Relationships through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  7. 107 CardinalityLearn Cardinality through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  8. 108 Participation ConstraintsLearn Participation Constraints through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  9. 109 Logical Database DesignLearn Logical Database Design through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  10. 110 Physical Database DesignLearn Physical Database Design through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  11. 111 Database NormalizationLearn Database Normalization through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  12. 112 Functional DependenciesLearn Functional Dependencies through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  13. 113 First Normal FormLearn First Normal Form through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  14. 114 Second Normal FormLearn Second Normal Form through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  15. 115 Third Normal FormLearn Third Normal Form through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  16. 116 Boyce-Codd Normal FormLearn Boyce-Codd Normal Form through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  17. 117 Fourth Normal FormLearn Fourth Normal Form through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  18. 118 Fifth Normal FormLearn Fifth Normal Form through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  19. 119 DenormalizationLearn Denormalization through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning
  20. 120 TransactionsLearn Transactions through a detailed SQL lesson with examples, exercises and practice questions.Intermediate · 16 min read · 120 min learning