JAVASCRIPT

https://github.com/vhf/free-programming-books/blob/master/free-programming-books.md
https://leanpub.com/bookstore/earnings_in_last_7_days/computer_programming/all
http://javascript.info/tutorial/number-math
http://jqfundamentals.com/
http://jstherightway.org/#screencasts

videos:
https://frontendmasters.com/courses/
http://devfreecasts.org/
https://egghead.io/

JqGrid with PHP Link

• http://dyels.blogspot.com/2011/08/jqgrid-with-json-tutorial.html
• http://www.jqueryrock.com/2014/08/jqgrid-tutorial.html

• https://ellislab.com/forums/viewthread/157452/
• http://blog.markmirandilla.com/2011/09/04/codeigniter-jqgrid-library/
• http://ykzir.wordpress.com/2011/11/17/jqgrid-add-edit-delete-view-and-search-with-codeigniter/
• http://gedelumbung.com/tutorial-codeigniter-jqgrid-menampilkan-data-grid-dengan-jqgrid-di-codeigniter/
• http://hasibarnab.wordpress.com/2012/09/01/integrate-jpgrid-with-codeigniter/
• http://sumonbd.wordpress.com/2009/10/04/jq-grid-with-codeigniter/
• http://ebalinside.com/jqgrid-dengan-codeigniter/
• http://ordinaryhumansays.wordpress.com/2012/03/30/tabel-dengan-jqgrid-di-framwork-codeigniter/

SQL Tutorial Link

• http://www.databasejournal.com/features/mysql/
• http://sol.gfxile.net/galaxql.html
• http://www.edventis.com
• http://sqlzoo.net/wiki/Main_Page
• http://cspractical.org/MySQL/SQL-Intro/tutorial
• http://beginner-sql-tutorial.com/sql.htm
• http://www.sql-tutorial.ru/
• http://www.sql-ex.ru
• http://www.tutorialspoint.com/sql/
• http://www.dreamincode.net/forums/blog/48/entry-4251-my-free-ebook-a-primer-on-sql/
• http://www.sqlskills.com/blogs/paul/
• http://blog.sqlauthority.com/
• http://www.mysqltutorial.org/
• http://www.artfulsoftware.com/infotree/queries.php 
• http://www.w3resource.com/mysql/advance-query-in-mysql/find-duplicate-data-mysql.php
• http://www.techotopia.com/index.php/Advanced_MySQL_Data_Filtering_-_AND,_OR,_NOT_and_IN
• http://www.tuxradar.com/practicalphp/9/3/13#null
• http://www.brainbell.com/tutorials/MySQL/Combining_WHERE_Clauses.htm
•  http://stackoverflow.com/questions/17318429/how-to-select-a-maximum-value-row-in-mysql-table
• http://www.psce.com/blog/2012/05/15/mysql-mistakes-do-you-use-group-by-correctly/ 
• http://www.edventis.com/video/Video-MySQL-Database-Tutorial-1-Introduction-to-Databases.html
• http://www.java2s.com/Tutorial/MySQL/CatalogMySQL.htm
•  
•  http://www.sitepoint.com/how-to-create-mysql-triggers/
• http://www.sitepoint.com/how-to-create-mysql-events/

• http://sqlfiddle.com/#!2/dc06f/1
  http://sqlfiddle.com/#!2/dc06f/88
  http://stackoverflow.com/a/19672038
• http://jsfiddle.net/kpu6mybb/ 

• http://pastebin.com/1REtKH7b
• http://www.proweb.co.id/articles/web_based_accounting/merancang_tabel_untuk_coa.html 
• http://www.kembar.pro/2014/10/klasifikasi-sistem-kode-akun-akuntansi.html

SQL NULL-IF USEFULL

http://www.bennadel.com/blog/579-sql-count-nullif-is-totally-awesome.htm

http://sqlfiddle.com/#!2/dc786/3/0
http://sqlfiddle.com/#!2/dc786/7
http://sqlfiddle.com/#!2/dc786/8

Rename 'jpg' to "JPG" dengan Paksa

find /path/to/images -name '*.JPG' -exec bash -c 'mv "$1" "${1/%.JPG/.jpg}"' -- {} \;

 use bash git in windows or linux to use thats script.

source: http://www.commandlinefu.com/commands/view/4471/rename-.jpg-to-.jpg-recursively