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. 41 Character TypesLearn Character Types through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  2. 42 VARCHARLearn VARCHAR through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  3. 43 CHARLearn CHAR through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  4. 44 TEXTLearn TEXT through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  5. 45 Boolean TypesLearn Boolean Types through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  6. 46 Date TypesLearn Date Types through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  7. 47 Time TypesLearn Time Types through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  8. 48 DateTime TypesLearn DateTime Types through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  9. 49 Timestamp TypesLearn Timestamp Types through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  10. 50 Binary TypesLearn Binary Types through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  11. 51 NULLLearn NULL through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  12. 52 INSERTLearn INSERT through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  13. 53 SELECTLearn SELECT through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  14. 54 UPDATELearn UPDATE through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  15. 55 DELETELearn DELETE through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  16. 56 INSERT Multiple RowsLearn INSERT Multiple Rows through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  17. 57 SELECT Specific ColumnsLearn SELECT Specific Columns through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  18. 58 SELECT All ColumnsLearn SELECT All Columns through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  19. 59 SELECT StatementLearn SELECT Statement through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  20. 60 DISTINCTLearn DISTINCT through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning