+ 2

Any good SQL resources ?

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

19th Jan 2019, 7:11 AM
Schleifer Grigorij
Schleifer Grigorij - avatar
8 odpowiedzi
+ 3
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).
19th Jan 2019, 8:58 AM
Rowsej
Rowsej - avatar
+ 3
I would finish the SQL course, then practise, practise practise! Experience can be better then a good book!
19th Jan 2019, 7:32 AM
Rowsej
Rowsej - avatar
+ 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.
19th Jan 2019, 7:39 AM
Rowsej
Rowsej - avatar
+ 3
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.
19th Jan 2019, 7:55 AM
Rowsej
Rowsej - avatar
+ 1
Hey Rowsej, thank you for your answer. What would you recommend for practice?
19th Jan 2019, 7:35 AM
Schleifer Grigorij
Schleifer Grigorij - avatar
+ 1
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
19th Jan 2019, 7:53 AM
Schleifer Grigorij
Schleifer Grigorij - avatar
+ 1
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?
19th Jan 2019, 8:44 AM
Schleifer Grigorij
Schleifer Grigorij - avatar
+ 1
Wow, thanks Rowsej!
19th Jan 2019, 11:14 AM
Schleifer Grigorij
Schleifer Grigorij - avatar