Articles filed under “lessons”

  1. What is SQL?

  2. The SQL SELECT Statement

  3. SELECT statement with specific columns.

  4. Filtering results with the WHERE Clause.

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

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

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

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

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

  10. Using wildcard comparisons with the LIKE operator.

  11. Handling Dates

  12. Removing duplicates from results with the DISTINCT keyword.

  13. Sorting results using ORDER BY.

  14. Using the CASE statement.

  15. How to LIMIT the number of results returned.

  16. Counting the number of rows returned with COUNT.

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

  18. Summing all values using the SUM Function.

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

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

  21. Aggregate functions using the GROUP BY clause.

  22. Using the HAVING clause to filter aggregate functions.

  23. Handling NULL values.

  24. Using the COALESCE function.

  25. Using Nested Queries

  26. Joining tables using INNER JOIN.

  27. Joining tables using LEFT JOIN.

  28. Joining tables using Multiple Joins.

  29. Joining tables using UNION joins.

  30. Using a Table Alias.

  31. Using a Column Alias.

  32. Joining tables using Self Joins.

  33. The INSERT INTO Statement

  34. The SQL UPDATE Statement

  35. The SQL DELETE Statement

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