Collected Resources

Created Monday 22 May 2017

File Transfer Administration

https://kb.site5.com/ftp/
https://help.ubuntu.com/community/SSH/TransferFiles

BASH / Shell Scripting

Guide For Administrative Tools
http://cli.learncodethehardway.org/bash_cheat_sheet.pdf

Just the basics:
http://www.linux-sxs.org/programming/bashcheat.html

Longer Guides to Bash Programming
http://bash.cyberciti.biz/guide/Main_Page
http://www.tldp.org/LDP/Bash-Beginners-Guide/html/

New for-loop
https://www.cyberciti.biz/faq/bash-for-loop/

On Bash variable (types)
http://stackoverflow.com/questions/18520951/bash-primitive-types


PHP Resources

http://www.w3schools.com/PHP/default.asp
http://www.tizag.com/phpT/

Composer (dependency management, similar to npm for Node) - https://getcomposer.org/


MYSQL Resources

Command Line guide - https://www.digitalocean.com/community/tutorials/a-basic-mysql-tutorial
Workbench guide - https://docs.oracle.com/cd/E19078-01/mysql/mysql-workbench/wb-getting-started-tutorial.html (this gives a good overview, though a bit out of date)

https://dev.mysql.com/doc/mysql-getting-started/en/ (this is the official one, but a bit harder to navigate)
Netbeans guide - https://netbeans.org/kb/docs/ide/mysql.html
Quick Guide to EER Modeling - https://interactiveonline.com/visual-database-creation-with-mysql-workbench/

PHP + MYSQL with PDO

Generally - https://code.tutsplus.com/tutorials/why-you-should-be-using-phps-pdo-for-database-access--net-12059
Basic CRUD (Create, Read, Update, Delete) - https://gist.github.com/odan/0c3f80eec13ac493ed64fadd0bb1a66e