• Lesson.No : 20
  • 00:16:12

  • Learning MySQL - SHOW, DESCRIBE, EXPLAIN, and SET

  • Play

Course Lessons

  1. 1- Learning MySQL - Getting Started
  2. 2- Learning MySQL - SELECT Statements
  3. 3- Learning MySQL - Aliasing
  4. 4- Learning MySQL - LIMIT keyword
  5. 5- Learning MySQL - SubQueries
  6. 6- Learning MySQL - INSERT Statements
  7. 7- Learning MySQL - UPDATE Statements
  8. 8- Learning MySQL - DELETE Statements
  9. 9- Learning MySQL - REPLACE Statement
  10. 10- Learning MySQL - INNER JOINs
  11. 11- Learning MySQL - Aggregate Functions
  12. 12- Learning MySQL - GROUP BY
  13. 13- Learning MySQL - String Functions
  14. 14- Learning MySQL - Numeric Functions
  15. 15- Learning MySQL - Numeric DataTypes
  16. 16- Learning MySQL - DataTypes for Time and Dates
  17. 17- Learning MySQL - String and Binary Datatypes
  18. 18- Learning MySQL - DROP TABLE Command
  19. 19- Learning MySQL - UNION Statements
  20. 20- Learning MySQL - SHOW, DESCRIBE, EXPLAIN, and SET
  21. 21- Learning MySQL - CREATE TABLE
  22. 22- Learning MySQL - ALTER TABLE
  23. 23- Learning MySQL - Filtering with BETWEEN
  24. 24- Learning MySQL - Filtering with IN vs equals
  25. 25- Learning MySQL - Using Indexes
  26. 26- Learning MySQL - FOREIGN KEY CONSTRAINTS
  27. 27- Learning MySQL - Date and Time Functions
  28. 28- Learning MySQL - LEFT, RIGHT, and self JOINs
  29. 29- Learning MySQL - Stored Functions
  30. 30- Learning MySQL - Multiple JOINS
  31. 31- Learning MySQL - CREATE VIEW
  32. 32- Learning MySQL- Encryption, Hashing, and Compressing
  33. 33- Learning MySQL - CASE Operator
  34. 34- Learning MySQL - IF and NULLIF functions
  35. 35- Learning MySQL - Stored Procedures
  36. 36- Learning MySQL - User Accounts
  37. 37- Learning MySQL - mysql CLI
  38. 38- Learning MySQL - TRIGGERS
  39. 39- Learning MySQL - JSON in MySQL
  40. 40- Up and Running with MySQL and NodeJS