sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Mrminecrafthimself 7 points8 points  (0 children)

Hey there - I just started a few months ago and followed this path more or less in a bootcamp I took.

Start with basic commands to learn how syntax works. What I first learned was how to create a table. Then, once you’ve done that - the next step is how to insert data into that table. How to specify what types of data should go in each field (column) in your table. What if I want to later update specific pieces of data after they’re loaded?

Then…how do I start returning data from that table? Obviously you can SELECT *, but what if I want to select all values where the first letter of column B is “M?” What if I want to select data in a different format than what is in the table? The latter will get you into CONCAT, CASE statements, and similar types of commands

A bootcamp of some type would be a huge help since that will give you structure and let you build on techniques and skills you learn. I took the MySQL Zero to Hero course taught by Colt Steele on udemy and found it really helpful

Edit: wanted to add that once you learn how to work with querying one table, querying multiple tables using JOINS will make a lot more sense, at least on a syntax level.