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. 01 Introduction to DatabasesLearn Introduction to Databases through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  2. 02 What is SQL?Learn What is SQL? through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 17 min read · 90 min learning
  3. 03 DBMSLearn DBMS through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  4. 04 RDBMSLearn RDBMS through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  5. 05 Database vs DBMSLearn Database vs DBMS through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  6. 06 Relational DatabasesLearn Relational Databases through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  7. 07 TablesLearn Tables through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  8. 08 RowsLearn Rows through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  9. 09 ColumnsLearn Columns through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  10. 10 FieldsLearn Fields through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  11. 11 RecordsLearn Records through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  12. 12 Database SchemaLearn Database Schema through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  13. 13 Data TypesLearn Data Types through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  14. 14 NULL ValuesLearn NULL Values through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  15. 15 Primary KeysLearn Primary Keys through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  16. 16 Foreign KeysLearn Foreign Keys through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  17. 17 Candidate KeysLearn Candidate Keys through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  18. 18 Composite KeysLearn Composite Keys through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  19. 19 Unique KeysLearn Unique Keys through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning
  20. 20 Super KeysLearn Super Keys through a detailed SQL lesson with examples, exercises and practice questions.Beginner · 16 min read · 90 min learning