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. 101 Constraints ManagementLearn Constraints Management through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  2. 102 COUNT()Learn COUNT() through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  3. 103 SUM()Learn SUM() through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  4. 104 AVG()Learn AVG() through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  5. 105 MIN()Learn MIN() through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  6. 106 MAX()Learn MAX() through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  7. 107 UPPER()Learn UPPER() through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  8. 108 LOWER()Learn LOWER() through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  9. 109 LENGTH()Learn LENGTH() through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  10. 110 ROUND()Learn ROUND() through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  11. 111 CONCAT()Learn CONCAT() through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  12. 112 TRIM()Learn TRIM() through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  13. 113 Aggregate FunctionsLearn Aggregate Functions through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  14. 114 COUNT()Learn COUNT() in Grouped Aggregation through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  15. 115 SUM()Learn SUM() in Grouped Aggregation through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  16. 116 AVG()Learn AVG() in Grouped Aggregation through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  17. 117 MIN()Learn MIN() in Grouped Aggregation through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  18. 118 MAX()Learn MAX() in Grouped Aggregation through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  19. 119 GROUP BYLearn GROUP BY through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  20. 120 HAVINGLearn HAVING through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning