/MySQL-Learning

This repository is a hands-on learning resource for MySQL enthusiasts, designed to enhance your understanding of fundamental database concepts. The commands folder contains essential .sql files that can be easily accessed using either VSCode or MySQL Community Workbench.

MySQL-Learning

The folder commands contains .sql files that can by accessed using VSCode of MySQL Community Workbench

The files are complete in themselves so run the blocks one by one and observe the output

Topics Covered

  1. databases
  2. tables
  3. insert rows
  4. select
  5. update and delete
  6. autocommit, commit and rollback
  7. current date, time and datetime
  8. unique
  9. not null
  10. check
  11. default
  12. primary key
  13. auto increment
  14. foreign keys
  15. joins
  16. functions
  17. logical operators
  18. wildcard characters
  19. order by
  20. limit
  21. union
  22. views
  23. index
  24. subqueries
  25. group by
  26. rollup
  27. on delete
  28. stored procedures
  29. triggers