Learn SQL

SQL lessons, examples, and practical exercises

  1. Introduction to Databases

  2. What is SQL?

  3. DBMS vs RDBMS

  4. Database, Table, Row, and Column

  5. SQL Data Types

  6. Installing MySQL and SQL Tools

  7. Creating a Database

  8. Selecting and Dropping Databases

  9. Creating Tables

  10. Table Constraints

  11. Primary Key

  12. Foreign Key

  13. Unique Constraint

  14. NOT NULL Constraint

  15. CHECK Constraint

  16. DEFAULT Constraint

  17. Auto-Increment Columns

  18. Altering Tables

  19. Renaming and Dropping Tables

  20. Inserting Data

  21. Selecting Data

  22. Column Aliases

  23. DISTINCT Values

  24. WHERE Clause

  25. Comparison Operators

  26. Logical Operators

  27. BETWEEN Operator

  28. IN and NOT IN

  29. LIKE and Wildcards

  30. NULL and IS NULL

  31. ORDER BY

  32. LIMIT and OFFSET

  33. Updating Data

  34. Deleting Data

  35. TRUNCATE vs DELETE vs DROP

  36. SQL Built-in Functions

  37. String Functions

  38. Numeric Functions

  39. Date and Time Functions

  40. Conversion Functions

  41. Aggregate Functions

  42. COUNT, SUM, AVG, MIN, and MAX

  43. GROUP BY

  44. HAVING Clause

  45. CASE Expression

  46. IF and Conditional Functions

  47. Inner Join

  48. Left Join

  49. Right Join

  50. Full Outer Join

  51. Cross Join

  52. Self Join

  53. Joining Multiple Tables

  54. UNION and UNION ALL

  55. INTERSECT and EXCEPT

  56. Subqueries

  57. Correlated Subqueries

  58. EXISTS and NOT EXISTS

  59. ANY and ALL Operators

  60. Common Table Expressions

  61. Recursive CTEs

  62. Views

  63. Temporary Tables

  64. Derived Tables

  65. Indexes

  66. Composite Indexes

  67. Unique Indexes

  68. Covering Indexes

  69. Index Performance

  70. Query Execution Plans

  71. EXPLAIN Statement

  72. Query Optimization

  73. Database Normalization

  74. First Normal Form

  75. Second Normal Form

  76. Third Normal Form

  77. BCNF

  78. Denormalization

  79. One-to-One Relationships

  80. One-to-Many Relationships

  81. Many-to-Many Relationships

  82. Junction Tables

  83. Transactions

  84. COMMIT and ROLLBACK

  85. SAVEPOINT

  86. ACID Properties

  87. Transaction Isolation Levels

  88. Dirty Reads

  89. Non-Repeatable Reads

  90. Phantom Reads

  91. Locks and Concurrency

  92. Deadlocks

  93. Stored Procedures

  94. Procedure Parameters

  95. Stored Functions

  96. Triggers

  97. Cursors

  98. User-Defined Variables

  99. Window Functions

  100. ROW_NUMBER

  101. RANK and DENSE_RANK

  102. LEAD and LAG

  103. PARTITION BY

  104. Running Totals

  105. Moving Averages

  106. Advanced Aggregations

  107. GROUPING SETS

  108. ROLLUP and CUBE

  109. Pivoting Data

  110. Dynamic SQL

  111. JSON Data in SQL

  112. JSON Functions

  113. Full-Text Search

  114. Database Users

  115. Roles and Permissions

  116. GRANT and REVOKE

  117. SQL Injection

  118. Parameterized Queries

  119. Database Security

  120. Backup and Restore

  121. Importing and Exporting Data

  122. CSV Data Handling

  123. Database Migrations

  124. Schema Versioning

  125. Data Integrity

  126. Auditing Changes

  127. Soft Delete

  128. Pagination Techniques

  129. Keyset Pagination

  130. Partitioning Tables

  131. Database Replication

  132. Sharding Concepts

  133. High Availability

  134. Read Replicas

  135. Materialized Views

  136. OLTP vs OLAP

  137. Data Warehousing Basics

  138. Star Schema

  139. Snowflake Schema

  140. Fact and Dimension Tables

  141. Slowly Changing Dimensions

  142. Advanced Query Optimization

  143. Large Data Handling

  144. SQL Performance Monitoring

  145. MySQL-Specific Features

  146. PostgreSQL-Specific Features

  147. SQL Server-Specific Features

  148. Database Design Project

  149. E-Commerce Database Project

  150. Banking Database Project

  151. Employee Management Project

  152. Inventory Management Project

  153. Reporting Dashboard Queries

  154. SQL Interview Questions

  155. Advanced SQL Practice Problems

  156. Real-World SQL Case Studies

  157. SQL Coding Standards

  158. Database Best Practices

  159. Production Database Management

  160. Final SQL Capstone Project