Any good SQL resources ?

Question

Any suggestions how to learn SQL? Maybe a good YouTube video tutorial? Or a must read book? Thank you!

Answer 1

Not much! I think that you could find an online course for it; there are heaps of stuff on the Web ;-) Except that it would have to be a local server, which means that only people on your internet network can view it. To put it live and public, you need to pay for the hosting, and also the domain name. You would also need a computer running all the time, though you can find free web hosting sites that will enable you to do that without costs (as I currently know).

Answer 2

I would finish the SQL course, then practise, practise practise! Experience can be better then a good book!

Answer 3

Try out your new skill on https://www.w3schools.com/sql/trysql.asp?filename=trysql_asc, so that you can fully understand what each statement does. Then you could try a few small projects, like a login system which combines HTML, PHP and SQL together to make the final product:

Note: Connecting PHP to SQL would probably use MySQL, and PHP itself would need a server. I would suggest setting up a local WAMP or MAMP server to try it out.

Answer 4

It isn’t a newbie comment... I just learnt it one week ago or so 😂
WAMP: Windows Apache2 MySQL PHP
MAMP: macOS Apache2 MySQL PHP
They’re both types of servers that you can set up.

Answer 5

Hey Rowsej, thank you for your answer. What would you recommend for practice?

Answer 6

This is a newby comment but where can I learn hoe to set up a WAMP/MAMP server? I will google it though ... Tja k you Rowsej

Answer 7

Wow, so cool :))) I have no clue about servers but it is an old dream of mine to set up one. What hardware do I need? Or can I set it up for free on my Mac?

Answer 8

Wow, thanks Rowsej!