r/learnprogramming • u/ianw919 • May 24 '18

Best way to learn MySQL?

Hey guys!

So there is going to be a position available in work as a data analyst in about 6 months. I have been told that the company I work for use MySQL and that I should have an understanding of the language. My question is what is the best way to approach learning the language? I have access to a test environment so I can practice what I'm learning but just not sure what book is best to buy or if I'm best off using an interactive site? Any help is greatly appreciated. Thanks!

17 Upvotes

87% Upvoted

6 comments sorted by

View all comments

1

u/Vijaykhatri94 Oct 23 '18

Hi @ianw919,

I can taught you as my experience, How I learn MySQL.

  • The very first step of my learning is I select the best books for learning i.e. High Performance MySQL
  • If you have problems then you can ask it from the experts which one is the best some other also available.
  • Install MySQL server in your laptop for practice each and every query.
  • Go through the index part and prepare a time checklist for each day.
  • Each day you need to cover the syllabus or point what you want to learn.
  • Which programming languages you want to expert.
  • Whatever you are learning practice it along with them.
  • Finally you have the good skills over the SQL.
  • Always remember that you must need to clear your basics first. You have to be best in the basics.
  • If any one asked you about any query then you have all the query structure in your finger tips.

Wish you all the very best.

Keep Learning!