1× knowledge

SQL / Subject

Beginner

Start learning SQL with relational concepts, tables, keys, data types, data definition, CRUD statements, filtering, constraints, functions and grouped aggregation.

Your Progress

Learning Summary

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

Suggested sequence

Learning roadmap

Topics follow the Admin display order

Beginner

122 topics
  1. Introduction to Databases
  2. What is SQL?
  3. DBMS
  4. RDBMS
  5. Database vs DBMS
  6. Relational Databases
  7. Tables
  8. Rows
  9. Columns
  10. Fields
  11. Records
  12. Database Schema
  13. Data Types
  14. NULL Values
  15. Primary Keys
  16. Foreign Keys
  17. Candidate Keys
  18. Composite Keys
  19. Unique Keys
  20. Super Keys
  21. Relationships
  22. One-to-One Relationships
  23. One-to-Many Relationships
  24. Many-to-Many Relationships
  25. SQL Syntax
  26. SQL Statements
  27. SQL Keywords
  28. SQL Comments
  29. Creating a Database
  30. Selecting a Database
  31. Dropping a Database
  32. Creating Tables
  33. Altering Tables
  34. Dropping Tables
  35. Truncating Tables
  36. Renaming Tables
  37. Integer Types
  38. Decimal Types
  39. Numeric Types
  40. Floating-Point Types
  41. Character Types
  42. VARCHAR
  43. CHAR
  44. TEXT
  45. Boolean Types
  46. Date Types
  47. Time Types
  48. DateTime Types
  49. Timestamp Types
  50. Binary Types
  51. NULL
  52. INSERT
  53. SELECT
  54. UPDATE
  55. DELETE
  56. INSERT Multiple Rows
  57. SELECT Specific Columns
  58. SELECT All Columns
  59. SELECT Statement
  60. DISTINCT
  61. Column Aliases
  62. Table Aliases
  63. WHERE Clause
  64. ORDER BY
  65. LIMIT
  66. OFFSET
  67. TOP
  68. FETCH
  69. Filtering Data
  70. Sorting Data
  71. Arithmetic Operators
  72. Comparison Operators
  73. Logical Operators
  74. AND
  75. OR
  76. NOT
  77. IN
  78. NOT IN
  79. BETWEEN
  80. NOT BETWEEN
  81. LIKE
  82. NOT LIKE
  83. IS NULL
  84. IS NOT NULL
  85. ANY
  86. ALL
  87. EXISTS
  88. LIKE Operator
  89. Wildcards
  90. Percent Wildcard
  91. Underscore Wildcard
  92. Pattern Searching
  93. NOT NULL
  94. UNIQUE
  95. PRIMARY KEY
  96. FOREIGN KEY
  97. CHECK
  98. DEFAULT
  99. AUTO INCREMENT
  100. IDENTITY
  101. Constraints Management
  102. COUNT()
  103. SUM()
  104. AVG()
  105. MIN()
  106. MAX()
  107. UPPER()
  108. LOWER()
  109. LENGTH()
  110. ROUND()
  111. CONCAT()
  112. TRIM()
  113. Aggregate Functions
  114. COUNT()
  115. SUM()
  116. AVG()
  117. MIN()
  118. MAX()
  119. GROUP BY
  120. HAVING
  121. Grouped Aggregation
  122. Multiple-Column Grouping

Topics

122 published topics

  1. 61 Column AliasesLearn Column Aliases through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  2. 62 Table AliasesLearn Table Aliases through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  3. 63 WHERE ClauseLearn WHERE Clause through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  4. 64 ORDER BYLearn ORDER BY through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  5. 65 LIMITLearn LIMIT through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  6. 66 OFFSETLearn OFFSET through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  7. 67 TOPLearn TOP through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  8. 68 FETCHLearn FETCH through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  9. 69 Filtering DataLearn Filtering Data through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  10. 70 Sorting DataLearn Sorting Data through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  11. 71 Arithmetic OperatorsLearn Arithmetic Operators through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  12. 72 Comparison OperatorsLearn Comparison Operators through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  13. 73 Logical OperatorsLearn Logical Operators through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  14. 74 ANDLearn AND through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  15. 75 ORLearn OR through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  16. 76 NOTLearn NOT through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  17. 77 INLearn IN through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  18. 78 NOT INLearn NOT IN through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 17 min read · 90 min learning
  19. 79 BETWEENLearn BETWEEN through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  20. 80 NOT BETWEENLearn NOT BETWEEN through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning