Articles filed under “lessons”

  1. Lesson 1: What is SQL?

  2. Lesson 2: The SQL SELECT Statement

  3. Lesson 3: SELECT statement with specific columns.

  4. Lesson 4: Filtering results with the WHERE Clause.

  5. Lesson 5: Filtering results using the WHERE Clause and GREATER THAN.

  6. Lesson 6: Filtering results using the WHERE Clause and the AND operator.

  7. Lesson 7: Filtering results using the WHERE Clause and the OR operator.

  8. Lesson 8: Filtering results using the WHERE Clause and the IN operator.

  9. Lesson 9: Filtering results using the WHERE Clause and the NOT operator.

  10. Lesson 10: Using wildcard comparisons with the LIKE operator.

  11. Lesson 11: Handling Dates

  12. Lesson 12: Removing duplicates from results with the DISTINCT keyword.

  13. Lesson 13: Sorting results using ORDER BY.

  14. Lesson 14: Using the CASE statement.

  15. Lesson 15: How to LIMIT the number of results returned.

  16. Lesson 16: Counting the number of rows returned with COUNT.

  17. Lesson 17: Counting the number of rows returned with COUNT and the WHERE clause.

  18. Lesson 18: Summing all values using the SUM Function.

  19. Lesson 19: Finding the average of numerical values using the AVG function.

  20. Lesson 20: Finding the minimum and maximum values using MIN and MAX functions.

  21. Lesson 21: Aggregate functions using the GROUP BY clause.

  22. Lesson 22: Using the HAVING clause to filter aggregate functions.

  23. Lesson 23: Handling NULL values.

  24. Lesson 24: Using the COALESCE function.

  25. Lesson 25: Using Nested Queries

  26. Lesson 26: Joining tables using INNER JOIN.

  27. Lesson 27: Joining tables using LEFT JOIN.

  28. Lesson 28: Joining tables using Multiple Joins.

  29. Lesson 29: Joining tables using UNION joins.

  30. Lesson 30: Using a Table Alias.

  31. Lesson 31: Using a Column Alias.

  32. Lesson 32: Joining tables using Self Joins.

  33. Lesson 33: The INSERT INTO Statement

  34. Lesson 34: The SQL UPDATE Statement

  35. Lesson 35: The SQL DELETE Statement

  36. Well Done!! You've Completed The SQL Crash Course