mysql pdf book notes download for free

About Book

This book has 100+ pages that cover the basic to advanced topic of Mysql with practical program and code examples and developed by www.goalkicker.com. if you want to learn Mysql then this book is for you. this book is developed by professional programmers for educational purposes.



Book contents

  1. Getting started with MySQL
  2. data types
  3. select
  4. backticks
  5. null
  6. limit and offset
  7. creating databases
  8. using variables
  9. comment MySQL
  10. insert
  11. delete
  12. update
  13. order by
  14. group by
  15. error 1055
  16. joins
  17. join 3 tables with the same name of the id
  18. union
  19. arithmetic
  20. string operations
  21. date and time operations
  22. handling tie zones
  23. regular expressions
  24. view 
  25. table creation
  26. alter table
  27. drop table
  28. MySQL lock table
  29. error codes
  30. stored routines
  31. indexes and keys
  32. full-text search
  33. prepare statements
  34. JSON
  35. extract values from JSON type
  36. MySQL admin
  37. triggers
  38. configuration and tuning
  39. events
  40. enum
  41. install MySQL container with docker-compose
  42. character sets and collations
  43. MyISAM engine
  44. converting from MyISAM to InnoDB
  45. transaction
  46. log files
  47. clustering
  48. partitioning
  49. replication
  50. backup using mysqldump
  51. mysqlimport
  52. load data file
  53. MySQL
  54. unions
  55. MySQL
  56. client
  57. temporary tables
  58. customize PS1
  59. dealing with sparse or missing data
  60. connecting with utf 8 using various programming language
  61. time with subsecond precision
  62. one to many
  63. server information
  64. SSL connection setup
  65. create new user
  66. security via grants
  67. change password
  68. recover and reset the default root password for MySQL
  69. recover from lost root password
  70. MySQL performance tips
  71. performance tuning
  72. reserved words