Module 8

SQL and Database Usage

Query and modify the database you have designed.

Beginner 480 min 0 of 20 lessons published

Lessons

  1. 1
    Introduction to SQL Beginner Coming soon
  2. 2
    DDL, DML, DQL, DCL and TCL Beginner Coming soon
  3. 3
    CREATE TABLE Beginner Coming soon
  4. 4
    INSERT Beginner Coming soon
  5. 5
    UPDATE Beginner Coming soon
  6. 6
    DELETE Beginner Coming soon
  7. 7
    SELECT Beginner Coming soon
  8. 8
    WHERE Beginner Coming soon
  9. 9
    ORDER BY Beginner Coming soon
  10. 10
    DISTINCT Beginner Coming soon
  11. 11
    INNER JOIN Beginner Coming soon
  12. 12
    LEFT JOIN and RIGHT JOIN Beginner Coming soon
  13. 13
    Aggregate Functions Beginner Coming soon
  14. 14
    GROUP BY and HAVING Beginner Coming soon
  15. 15
    Subqueries Beginner Coming soon
  16. 16
    EXISTS Beginner Coming soon
  17. 17
    Views Beginner Coming soon
  18. 18
    Transactions: COMMIT and ROLLBACK Beginner Coming soon
  19. 19
    Introduction to SQL Optimisation Beginner Coming soon
  20. 20
    Final Exercise Beginner Coming soon