Help learning MySQL

[UBS2345]

I've just research about MySQL for my new major since I want to change into Business Analyst. How should I start? Thanks!

[james438]

MySQL is a lot like learning spreadsheets or Microsoft Excel. If you are looking into MySQL I would start by first creating a database and then creating a table for that database. Next, write a PHP script to interact with your database. You will need a web page to do this. You can get all of this for as little as $6.00 or $7.00 per month. I prefer GoDaddy.

You can read up on the official MySQL documentation here https://dev.mysql.com/ however, their website is not very navigable to the novice.
You can read up on the PHP side of things here: https://www.php.net/manual/en/function.mysqli-connect.php (also contains an example for connecting to your database.)

[UBS2345]

MySQL is a lot like learning spreadsheets or Microsoft Excel. If you are looking into MySQL I would start by first creating a database and then creating a table for that database. Next, write a PHP script to interact with your database. You will need a web page to do this. You can get all of this for as little as $6.00 or $7.00 per month. I prefer GoDaddy.

You can read up on the official MySQL documentation here https://dev.mysql.com/ however, their website is not very navigable to the novice.
You can read up on the PHP side of things here: https://www.php.net/manual/en/function.mysqli-connect.php (also contains an example for connecting to your database.)

It's a bit of great advice. Thank you so much. I also have some websites that are under construction for optimizing MySQL queries for performance and speed because they have large stocks. E.g this website https://www.alangrahams.com.au/.

I think this industry is really interesting and hope to learn from your specialized knowledge more. Many thanks!