PHP & MySQL resources for 2.41 / 3.41

Dynamic DB driven websites with PHP / MySQL need a web server. There are options such as: 

• https://codeanywhere.com/ - cloud based IDE
• 000webhost.com - free hosting
• Dreamspark Azure - free for students - ask about a serial no.
• XAMPP - you can run local web server on your PC / Mac etc.

YouTube Video Tutorials:

• Phil Adam's PHP & MySQL - Level 2
  https://www.youtube.com/playlist?list=PLC67539D5463C0BF6
• NZdZeni PHP & MySQL - Complex DB Level 3
  https://www.youtube.com/playlist?list=PLwll6mdTmnFGApCI3eBHRJlMpbNz8oBMK

Other Resources:

3 years ago, when I did the teacher PD with Andy Able from Yoobee (Natcoll) and read through their book on PHP & MySQL I was struck by the thought that it would too difficult for the average Y12/13 student and they may lose interest with the textbook / lecture format. So I put PHP/MySQL on a back burner to concentrate on teaching web dev, relational database management and programming separately.

However, having studied Blended Learning and flipped classroom models I now think that this could work really well to combine these three areas of web dev, programming and relational database management - if they are supported by good interactive resources. 

This list is by no means exhaustive - but I think these resources are more than sufficient to support teaching Y12 & Y13. I don't expect all of these will work for all of your students' preferred learning styles and I don't expect you should scare them off by tring to do all of them, however, I think combining some of them will work well.

1) Watch & Do these REALLY good Video Courses from Codeschool.com with interactive quizes (BTW these ones are FREE but you can subscribe for all courses)

ALL FREE ones: https://www.codeschool.com/free

• Try SQL : https://www.codeschool.com/courses/try-sql
• The Sequel to SQL: http://campus.codeschool.com/courses/the-sequel-to-sql/contents

2) Do these interactive courses on CodeCademy.com

• SQL 3hr - https://www.codecademy.com/learn/learn-sql
• PHP 4hr - https://www.codecademy.com/learn/php

3) Support the learning with SOLO Learn Interactive mobile learning quiz apps for iOS or Android etc

• http://www.sololearn.com/Play/PHP/#
• http://www.sololearn.com/Course/SQL/

MORE INFO: 

Bucky Roberts is awesome! is Youtube channel and website The New Boston are packed with CS goodness:
PHP: https://www.thenewboston.com/videos.php?cat=11 
SQL database: https://www.thenewboston.com/videos.php?cat=49

For Online reference tutorials on PHP and MySQL check out:

• http://www.w3schools.com/php/php_mysql_intro.asp
• http://www.tutorialspoint.com/php/php_and_mysql.htm

FREE UDEMY COURSES:

  (you can filter your search to FREE courses)

Thorough Video based courses (passive learning):

• Free 10.5hr course on Udemy - https://www.udemy.com/php-mysql-tutorial/learn/#/

• PHP Fundamentals (2hr) - https://www.udemy.com/learn-php-fundamentals-from-scratch/learn/#/

• MySQL for Beginners (6hr) - https://www.udemy.com/mysql-db-for-beginners/learn/#/